-
JJeff D
How can I refresh the spreadsheet frequently (e.g. every 30 minutes)?
Can I use the pre-populate URL style to call the unique code. i.e. /form?uniquecode={{contact.email}}
Unique code would be hidden, as these would be customer details that we'd want to be pulling out via the spreadsheet (currently 70K customers, though only 4 fields, name (first & last), email address and 1 other).
-
Chris_L JotForm SupportHi Jeff,
Thanks for reaching out to us for help. If you're trying to refresh the spreadsheet automatically, that is not possible. But it's possible to manually update the spreadsheet. Let me show you how:
1. In Form Builder, select the Spreadsheet To Form widget and click on the Wand icon.
2. In Widget Settings that opens on the right side of the page, click on Remove File.
3. Now, click on Upload File, then upload your spreadsheet.
4. Fill the relevant fields, then click on Update at the bottom right side of the page.
To keep the conversation organized, I moved your other question to its own thread, and someone from our Support Team will help you with it here.
Reach out again if you need any other help.