API_DoQuery and response array with Google Scripts

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • In Progress
I've been attempting to build a script on Google Scripts that will run daily and send notifications. 

The concept behind it is that it should perform an API_DoQuery on a table that contains customer records, retrieving all customers that need to be sent a reminder. 

I want to store those records in an array that i will then loop through, performing an API_editRecord on a checkbox field, sending an email to each customer reminding them they have pending documentation.

I've seen Kirk's video on how to use google scripts and have managed to use itfor API_EditRecord and AddRecord, but Do_Query and processing the results I've had no success with. 

Any help, pointers, etc. would be much appreciated!!

Photo of Carlos


  • 836 Points 500 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of Joe Acunzo

Joe Acunzo, Champion

  • 240 Points 100 badge 2x thumb
Contact me directly if you need some help at joe.acunzo @ SoftTechExperts.com.  However, you may be able to use a service I offer called SmartEmailReminder for Quick Base.  Contact me for details.