I have created an app for a centralized sign in. Every attendee will sign in on our company's devices at the front desk. Once the attendees sign in, I want to send an email with a survey to fill out about the presentation. I have created the automation that sends out the form (survey) after they sign in. Some of the fields of the form are prefilled with their name and the presentation they attended. I want the attendees to be able to fill out the survey without signing in but I don't want them to be able to enter the app and see any data other than their data that is prefilled in the form. Do I have to turn off the "Require user sign in?" in Security? If so, how do I protect the data in the app?
I'm not completely sure that you want to provide a lot of people access to your app, this doesn't sound like a wise thing to do based on the cost per user.
Anyway, a public form sounds like a better option and it works outside AppSheet
If I used a form, would I be able to prefill some of the answers with AppSheet and/or bring in the data collected from the form into the spreadsheet that AppSheet is tied to? I would really like to keep the sign in data and survey data for each attendee together in one row.
If you just want people to be able to submit data through you app, there's a toggle you can turn on (at the TABLE level) to filter out all existing rows:
We are working with existing data in a google sheet to create the centralized sign in. I would really like to keep the sign in data and survey data together. Could I create another app that is just for the form and have the data from that populate the same spreadsheet as the sign in? So, columns A - I are existing data brought in from our payment platform, column J records their sign in with centralized sign app, columns K-Q record survey data from a public app expressly for that purpose and with only the form view. Would that work?
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |