Discussions

 View Only
  • 1.  API_DoQuery and response array with Google Scripts

    Posted 06-29-2018 16:50
    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!


  • 2.  RE: API_DoQuery and response array with Google Scripts

    Posted 06-29-2018 19:15
    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.