create-airtable

 Task: Create Table in Airtable

In this task, we will create a table to keep track of which tasks have been completed.  Then we will update the rest of the application to make use of it.

1. In Airtable, create a new table named "Activity" with the following columns:

  • id [formula: RECORD_ID()]
  • task [link to another record:Task]
  • employee [link to another record:Employee]
  • store [link to another record:Store]
  • date [date: do not include time]

2. In Google Apps Script editor, select "debug.gs" and click "Run" to simulate the web call again.

  • If the table is created correctly, you will see a message indicating "Success"
3. Examine the newly created record in the Activity table in Airtable

4. In Google Apps Script Editor, Deploy your current server-side code and copy the Deployment ID to the appropriate place in the front-end code.

5. Test the "Done" button in the application.  
  • If everything is configured correctly, the button will be replaced by a checkbox when clicked.
  • Each time you click a button, a new record should appear in the Activity table in Airtable.