Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 08, 2024 03:54 AM
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?
Aug 08, 2024 07:35 AM
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?
Aug 08, 2024 11:33 PM - edited Aug 08, 2024 11:34 PM
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