google apps script

Copy Google Apps Script

The instructions on this page will help you configure a Google Apps Script to act as the business logic tier of the application.

1. Setup the business logic tier by copying a Google Apps Script Project:

• Navigate to https://script.google.com/home/projects/1Zz0kM...
• Click the "Make a copy" icon in the upper right corner.  This will make a copy of the project in the top-level folder of your google drive.
  
  
  
  
  
• Change the name of the project from "copy of three-tier template" to "three-tier"
• Double-click the file name to open the script project in the script editor

2. Enter your Airtable Credentials into the "Airtable_class.gs" file of the Google Apps Script project you created in step 1 above. 

• Navigate to https://airtable.com/account and click the "Generate API Key" button and copy the newly created key
  
  
  
  
  
•  In the Google Apps Script editor, update line 10 of the Airtable_class.gs, replacing "YOUR TOKEN ID GOES HERE" with the API Key just copied
  
  
  
  
  
• Navigate to https://airtable.com/api and click on the name of the Airtable base you created. 
  
  
  
  
• Find the base ID near the top of the "Introduction" section after the text "The ID of this base is".  Copy the Base ID (without the trailing period)
  
  
  
  
  
• In the Google Apps Script editor, update line 15 of the Airtable_class.gs, replacing "YOUR BASE ID GOES HERE" with the Base ID just copied.
  
  

←

→