Building a form to build a form?

[LFtwarrington]

I would like input on design or if it's even possible. Here's my scenario.  I have tried this a few ways through Co-Builder, but nothing that works yet.

Our organization does a survey for every event/program we have.  The questions are always different.

Other staff need to build forms, but they are not 'techy.'  I would like to build a system that creates their evaluation forms automatically and they would have the ability to edit easily through the interface or form builder.  I also need to be able to show the results through an interface real-time.

Surveys look like this:
Speaker 1 Rating (rating field)
Speaker 1 Comments (long text field)
Speaker 2 Rating (rating field)
Speaker 2 Comments (long text field)
(more speakers, not always the same number of them)
Which experience was the best? (single select field)
Open-ended question (long text field)

I do have a license for mini-extensions.  Other staff members do not though.

Any thoughts?

[esther598]

Hello,

. Form Creation
Google Forms: It’s free, easy to use, and allows for a variety of question types. You can create templates for different types of surveys and share them with your team.
Typeform: Known for its user-friendly interface and visually appealing forms. It also offers conditional logic, which can help in creating dynamic surveys.
Microsoft Forms: If your organization uses Microsoft 365, this could be a seamless option. It integrates well with other Microsoft tools and is easy to use.
2. Automation
Zapier: This tool can automate the creation of forms based on certain triggers. For example, when a new event is added to your calendar, Zapier can trigger the creation of a new survey form.
Google Apps Script: If you’re using Google Forms, you can use Google Apps Script to automate form creation and customization.
3. Editing Interface
JotForm: Offers a drag-and-drop form builder that is very intuitive. It also allows for easy editing and customization.
Airtable: While not a traditional form builder, Airtable can be used to create forms and manage survey data. It also offers a user-friendly interface for editing.

Best Regards

esther598

[TheTimeSavingCo]

Hmm, maybe you could try creating a form that would allow them to set the fields and field types they want for their form (i.e. "Speaker 1 Rating" - "Rating Field") as a combination of text fields for the questions and single select fields for the field types

Once they've set all that up, you could create a new table and create all the fields they requested in it via the API, and then send them an email with a link to the table.  At this time I don't think there's a way to create views or interfaces though, so they'd then have to go to the table you setup and create a form view?

[ScottWorld]

@LFtwarrington 

You can’t programmatically create forms with Airtable, but you CAN do that with JotForm’s advanced forms because that is one of the supported features of JotForm’s API.

So if you’d like to use JotForm for your forms, you can automate the process by writing your own custom Javascripts, or you can do it with no coding at all by using Make’s advanced automations for JotForm.

The entire process can be automated between Airtable and JotForm by using Make’s advanced automations for Airtable.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread: https://air.tableforums.com/t/make-com-basic-navigation-tips/277

For example, here is one way that you could instantly trigger a Make automation from Airtable. https://air.tableforums.com/t/sending-airtable-data-to-an-external-webhook-such-as-make-com/159

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here: https://www.youtube.com/playlist?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1

For example, in this video, I show how to work with Airtable arrays in Make. https://www.youtube.com/watch?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&v=sKPyG0HZCYY

— ScottWorld, Expert Airtable Consultant