API_DoQuery and response array with Google Scripts

  • 0
  • 1
  • Question
  • Updated 9 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!!

thanks!
Photo of Carlos

Carlos

  • 796 Points 500 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of joe.acunzo

joe.acunzo, Champion

  • 180 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.