Skip to main content

Building a form to build a form?

  • August 8, 2024
  • 3 replies
  • 75 views

Forum|alt.badge.img+1

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?

3 replies

Forum|alt.badge.img+3
  • New Participant
  • August 8, 2024

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
Forum|alt.badge.img+31

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
Forum|alt.badge.img+35
  • Genius
  • August 9, 2024

@LFtwarrington 

You can’t programmatically create forms in Airtable, but you have 2 different ways of doing this:

#1. You can LITERALLY create forms PROGRAMMATICALLY 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 to programmatically create forms, you can automate the entire process by using Make’s advanced automations for JotForm.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable

But you may want to consider if this is really what you want to do, because if you programmatically create your own forms, you would still need to connect those forms to Airtable after creating those forms. So you’re not really saving much time here.

You probably just need a very easy way to create a form that communicates with Airtable.

#2. So your much better option here is to use Fillout’s advanced forms for Airtable because it natively communicates directly with Airtable. So, as soon as the form is built, it is already communicating with Airtable.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a formcreate custom PDF files from a form submissionaccept payments on formspre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a formadd a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld