Re: Form (public) > Spreadsheet (private, based on form answers)

351 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I want a user’s answers populate a template spreadsheet. Airtable form > template Airtable spreadsheet. The user’s unique spreadsheet can’t be seen by anyone else.

Is this possible? Or is the purpose of a form solely to gather information for one’s own records?


1 Reply 1

Welcome to the community, @Wage_Buddy! :grinning_face_with_big_eyes:

Maybe and mostly. :slightly_smiling_face:

I say “maybe” for the “is this possible” question because, while it’s possible to create on-the-fly tables (not spreadsheets) based on form input (using an automation that runs a script to create a table and its contents based on the form data), only the most basic options would be available in terms of the table layout, and making these on-the-fly tables available to users on anything other than a read-only basis would be tricky. There currently isn’t a way to create a shared view programmatically, so someone would need to create that shared view, copy the view URL, then send that to the user. All manually. And even then, they could only view it. They couldn’t edit the data or easily save it anywhere (unless you want to make them a collaborator in the base…again, manually). Also, there’s the issue of longevity, meaning how long do you plan on making these tables available to other users?

Let’s take a step back for a moment. Tools and terminology aside, what is your use case? What’s your goal? There may be a way to achieve what you want through other means.