jtherieauI'm exporting a large database to Google Spreadsheet Live Data. The export script provided works, except the Google Spreadsheet times out sporadically, resulting in this error: "error: Service timed out: Apps Script"
I thought if I limited the export to the past 2-3 months, for example, that might resolve the problem. But I'm not sure how to achieve this. I figured out how to generate shortcode using the submit_time function (submit_time>-8 weeks) for don't know how to integrate it with the Google doc.
I also noted the "optional search" in the Google Doc cell formula (Enter in the cell the formula:
=CF7ToDBData("siteUrl", "formName", "optional search", "user", "pwd") but I don't know what search term to use for the optional search property. (optional search: leave as "" by default or add a search term to filter rows).
Can anybody help me with this?
many thanks,
Jennifer
