Table Builder

Table Builder enables Studio Users to build Tables to store data used within multiple apps in the Studio. 

Each Table has the following:

• Column Name - Provides a name for the Column to indicate what the data represents. You'll use the Column Name when connecting a Form Field to a specific Column in the Table. 
• Type - This is the type of data that is being stored in this Column. There are five data types available:
  • Checkbox
  • Date/Time
  • Dropdown 
  • Numeric
  • Text
• Active Toggle - All Columns are Active when a new Column is added to the Table. Toggle off Active if you no longer want data to be submitted to this Column.
• Test Data Icon - All Forms submissions done through the Test URL for an App or within the Studio Phone Preview will have a Test Icon appear in the applicable row. Test Data is not included in the CSV export.
• Delete Row - Any row of data can be deleted manually by clicking on the Trashcan icon next to the applicable row. 

Get Started with Table Builder

1. Login to your Studio
2. Click Data in the left side navigation. 
3. Click the green Add button to build a new Table. You can choose to create a new Table, Create from a Template, or Copy an existing Table. 
4. Name your table and click Save.
5. If you are creating a new Table, input each Column you want in your Table. You'll also need to select the appropriate Data Type for the Column (i.e. Text, Checkbox, Date/Time, Dropdown, and Numeric). 
6. If you are copying a Table from a Template or an existing Table, Columns and Data Types should automatically be pulled in from the Table you are copying from. Just ensure your Table's permissions are designated appropriately. For instance, you may choose to give all users permission to Create, Read, and Edit, while giving permission to Delete to only Authorized users.
7. Click  Save.

Edit an Existing Table

1. Login to your Studio and click Data in the left side navigation.
2. Click on the Table you want to edit. 
3. Click the Edit Table button.
4. Add new Columns or toggle off any previous Columns you no longer want to use. 
5. Click Save.

Export

1. Login to your Studio and click Data in the left side navigation.
2. Click on the Table you want to edit. 
3. Click the orange Export button.
4. A CSV is exported to your computer.