Create dynamically generated forms with Appsheet and Google Forms?

[michael12]

I have an Airtable database that has a table of over 50 options, and then a table of hundreds of onboarding questions. Depending on the options a user selects I need to dynamically generate a form with the relevant application questions. For example, option A is linked to questions 1, 2, 3, 4; option B is linked to questions 2, 3, 4, 5. If Option A and B are both selected I need to populate a form the client can fill out that has questions 1, 2, 3, 4, 5.

I can't find out of the box solutions for something that can dynamically generate forms. I think Appsheet may be able to do this, maybe in combination with Google forms and Google scripts. But can it pull from my Airtable database to generate forms in this way??? Any thoughts??

[WillowMobileSys]

AppSheet allows for dynamic VIEWING of the Form.  You would build your Form so that it has ALL of your necessary fields in the order you wish them to be displayed.  You then control which fields are shown to the user as they fill out the Form. 

So, in your example, your Form would have a field to choose the options A or B and then also have all 5 question fields listed on the Form.  You would configure Questions 1, 2, 3, 4 to show on the Form if Options A was selected.   Questions 4 and 5 would be configured to show if Option B was selected.  If both options are selected then all questions would be shown based on the configuration noted above.

I hope this helps!!

[MultiTech]

You might find the following app that I made a while ago helpful, it allows for the creation of kind of what you're talking about; the form that the users use to collect information is technically a single form, but it allows for various different data types to be collected - conforming the data collection type columns based on whatever's specified for the item that's being collected.

https://youtu.be/U7wNAE_KQcw

It's a very non-standard app, but it demonstrates how you can build a dynamic data collection system that's based off of the data inside the records - versus how the app is conformed.

I would never make my main data collection system this way, this is purely for demonstration purposes showing how you could create some sort of dynamic thing.

[michael12]

Thanks for the example I'm curious why you would never make your main data collection system this way?

I can't find any out of the box SAAS solutions that let you generate forms dynamically based on user selection of a subset of records in a database.

Google forms, Jotforms, etc all have you create specific forms.

[MultiTech]

---

@michael12 wrote:

I'm curious why you would never make your main data collection system this way?

---

When you record your data this way you're creating one record for each data point, versus one record for each of vent or whatever that you're recording data for. So instead of having one record, we have 15, or 35, or 490. 

Capturing the data in this way can be helpful in certain circumstances, but for long-term storage you'd want to roll all of these up into some sort of single record with a more horizontal format.

[michael12]

This is another example of what I was trying to create: https://www.jotform.com/answers/3074071-can-i-generate-completely-dynamic-forms-on-the-fly