Create the Tables with Data

We will create the core tables for our application. To create a table in App Engine Studio:

1. Click the Add icon (⨁ Add) for Data on the App Home tab.

   

2. ① Select Import a spreadsheet tile, ② Click on the Continue button.

   

3. ① Drag and drop the file Telework Data.xlsx (in the telework_lab files folder we downloaded earlier), ② Click on the Continue button.

   

4. Our spreadsheet has multiple sheets. We only need the first one "Telework Arrangement".

5. ① Check ☑ Import spreadsheet data (in the telework_lab files folder we downloaded earlier), ② Click on Convert to table.

   

6. ① Select Create new table (to hold the Arrangement data), ② Click on the Continue button.

   

7. ① Click the Expand/Collapse icon (⌄) to see advanced configuration options, ② Check the Display checkbox, ③Click on the Continue button.

   

   tip

   We need to set what value to display when these records will be referenced.

8. Set the table name

   ① Set the table label to Arrangement. (Hit ⇥ Tab) The table name will auto populate. ② Click on the Continue button.

   

9. Set the permissions.

   ① For the admin role, click the All checkbox ② For the user role, click the All checkbox and then remove the Delete permission. ③ Click on the Continue button.

   

10. A loading screen will appear while the table is being created. When it completes, click Done.

    

11. We haven't converted all the sheets in the spreadsheets, so we'll see this message pop up.

12. Click Yes, leave.

    

13. Let's add the Telework Case table. Click the Add icon (⨁ Add) for Data on the App Home tab.

    

14. (1) Select the Import a spreadsheet tile, (2) Click on the Continue button.

    

15. On the Choose a spreadsheet to import from screen, click the Drag and drop or browse to upload spreadsheet link.

16. Browse and select the Telework Cases.xlsx file you downloaded.

17. Select ☑ Import spreadsheet data.

18. Click on the Continue button.

19. This time on the Where do you want to import your file into? screen, select the Create from an extensible table tile.

20. Click on the Continue button.

    

21. On the Which table do you want to use? screen,

    
    ➊ Click in the table field,
    
    ➋ Select the Task table,
    ➌ Click on the Continue button.

    

22. On the let's get more info about your new table screen,

    ➊ Set the table label to Telework Case. (Hit ⇥ Tab) The table name will auto populate,
    
    ➋ Check the Auto number,
    ➌ Keep the Prefix as TEL
    ➍ Click the Continue button.

    

23. Set the permissions.

    ① For the admin role, click the All checkbox ② For the user role, click the All checkbox and then remove the Delete permission. ③ Click on the Continue button.

    

24. On the Great! Now your table is ready for data screen, select the Continue button.

    

25. A loading screen will appear: Sit tight while we create data mapping instance for table Arrangement.

26. Read the help pop-up and click Next until Done.

    

27. Notice the fields have already been auto-mapped, but some are not correct. Clear out the Transfer reason value.

    

28. Click on the Add Fields link button at the top.

    

29. Hover over the row and edit the Reason field by clicking on the pencil icon.

    

30. In the Field type section select Choice then click the Update field button. The choices will be added for you based on the spreadsheet data!

    

31. Days per week is ok as an integer.

32. Days per week is ok as an integer, but Edit the Arrangment field.

    1. Field type: Reference
    2. Reference table: Arrangement
    3. Click the Update field button.

    

33. Lets add the new fields to our table by clicking the Add fields button.

1. Clear the Description, Opened, and Transfer reason values. Click on the Continue button.

   

2. Your table is now ready. Click the Edit table button. Click through all the helper screens.

   

3. Click the Next button on the Welcome to Table builder helper and other popups.

info

We can see all the fields that our table inherited from the Task table, making building applications faster.

Exercise Recap Congratulations, you've built the first tables in your solution.

In this exercise, we learned how to create a new application and map out the data elements important to enable our business process.

We learned to use the Table Builder to add and configure columns including Reference fields and Choice lists.

We were able to complete all these tasks using simple point-and-click administration and without requiring specialized application or database knowledge.

Next we'll take a look at the list & form views that have been generated for our table and adjust the layouts.