Form from legacy

[Shodushi]

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 ?

[Steve]

None of this makes sense to me. Can you restate?

[Shodushi]

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

[Steve]

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?

[Shodushi]

Or can CONTEXT(“Device”) to initial value serve as well to some identify in public app (to prevent multiple FORMs from same user)

[Steve · Accepted 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:

1. Each form submission must add only a single row to the worksheet.

2. That one row must contain all of that user’s responses for that form submission.

3. 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.

Shodushi:

Or can CONTEXT(“Device”) to initial value serve as well to some identify in public app (to prevent multiple FORMs from same user)

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.