Hi, Can I put legacy to public app to FORM, where data will be saved to google sheets and used to read only ?
For example Jotform.com where is good integration
If this way somehow doesnt work can webhook do it ?
Solved! Go to Solution.
That helped a lot! Thanks!
It appears youโre collecting responses to a form on jotform.com, and that the form responses are saved to a Google Sheets worksheet. It appears you want to be able to view the form responses from an AppSheet app. You can, with the following conditions:
Each form submission must add only a single row to the worksheet.
That one row must contain all of that userโs responses for that form submission.
Each row must have a unique identifier to distinguish it from every other row.
Based on the images you posted, it appears all of those conditions are met, so you should be able to use AppSheet without a problem.
CONTEXT("Device")
can be used in an AppSheet app to identify the current device, and to limit repeat submissions from the same device. However, it must be used at form submission; it cannot be used after the form has already been submitted. I know nothing about jotform.com, but it appears from what youโve posted here that it does not integrate with AppSheet directly, so I donโt see an obvious way to make use of CONTEXT("Device")
to limit repeat submissions of forms through jotform.com.
None of this makes sense to me. Can you restate?
Sure,
Legacy in the app to the another web(where I can identifiy user) where is a FORM (connected with google sheets) and after this data will be used for read only just with same column
Iโm afraid I still donโt understand. If you are not a native English speaker, perhaps post in your native language and I can try Google Translate?
Or can CONTEXT(โDeviceโ) to initial value serve as well to some identify in public app (to prevent multiple FORMs from same user)
That helped a lot! Thanks!
It appears youโre collecting responses to a form on jotform.com, and that the form responses are saved to a Google Sheets worksheet. It appears you want to be able to view the form responses from an AppSheet app. You can, with the following conditions:
Each form submission must add only a single row to the worksheet.
That one row must contain all of that userโs responses for that form submission.
Each row must have a unique identifier to distinguish it from every other row.
Based on the images you posted, it appears all of those conditions are met, so you should be able to use AppSheet without a problem.
CONTEXT("Device")
can be used in an AppSheet app to identify the current device, and to limit repeat submissions from the same device. However, it must be used at form submission; it cannot be used after the form has already been submitted. I know nothing about jotform.com, but it appears from what youโve posted here that it does not integrate with AppSheet directly, so I donโt see an obvious way to make use of CONTEXT("Device")
to limit repeat submissions of forms through jotform.com.
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |