I have a table whose source spreadsheet has rows added to it when a Google Form is submitted. This works, but I wanted to replace a row-number key with a unique key, so I performed the following steps:
When I submitted a form from Google Forms, a row was added to the spreadsheet in which all cells other than the internal case ID were filled in, but the internal case ID remained empty.
I noticed that row 1 of the spreadsheet had a comment of the form AppSheet:{...} in each column except the internal case ID column. I closed the AppSheet editor, went back to the AppSheet add-on in Google Forms, and clicked PREPARE and LAUNCH. The AppSheet editor reopened and the internal case ID column of row 1 in the spreadsheet now had the following comment:
AppSheet:{"IsRequired":true,"IsEditable":true,"Type":"DateTime","IsKey":true,"IsHidden":true}
I corrected the type from DateTime to Text.
None of this helped. When I submit a form from Google Forms, a row is still added to the spreadsheet in which all cells other than the internal case ID are filled in, but the internal case ID remains empty. What can I do to populate the key?
Solved! Go to Solution.
Aleksi, from AppSheet support, confirmed that when a spreadsheet is linked to Google Forms, submission of a form fills in only the columns corresponding to the form. Thus adding a column to the spreadsheet generated by Google Forms and specifying a formula for that column has no effect; the formula is never invoked,
I came up with the following workaround, which solves the problem:
@nhcohen wrote:When I submitted a form from Google Forms, a row was added to the spreadsheet in which all cells other than the internal case ID were filled in, but the internal case ID remained empty
It's because AppSheet expressions are calculated inside AppSheet, not using any external thing
Aleksi, from AppSheet support, confirmed that when a spreadsheet is linked to Google Forms, submission of a form fills in only the columns corresponding to the form. Thus adding a column to the spreadsheet generated by Google Forms and specifying a formula for that column has no effect; the formula is never invoked,
I came up with the following workaround, which solves the problem:
Very well done!
User | Count |
---|---|
26 | |
25 | |
25 | |
20 | |
19 |