Requesting data from from non users

[KC_REMOTE]

New to App Sheets..

Is it possible to send a non user (B2C scenario) a form to fill out that populates their project record? 

For example, so they can choose products chosen for a renovation.

The they can view their project data only.

The purpose is avoid making a paid user for each B2C client. They are typically one time clients.

Thanks.

[WillowMobileSys]

Anytime you are having a user "SUBMIT" information directly into the app, they should be a properly authenticated user to avoid any security concerns with some nefarious person submitting bogus details.  Keep in mind that AppSheet only charges license fees for ACTIVE users.  If you have about 20 different consumers each month, you would only need about 20 additional licenses to cover them.

Having said that, you could create a Public app which has access to the same data but in a limited way.  The consumer could access records by providing some identifier as a lookup to the project and then submit updates.   Maybe a project id is emailed to them?

If it is somewhat important to prevent bad actors from interfering, you might need something a little more secure.  For example, maybe an expiring code is sent to their email and they must use the code, before it expires, to gain access into the Public app.  Again, this is not very secure as emails can be intercepted but maybe it's sufficient for the information you wish to have the customers interact with.

I hope this helps!