Multiple Airtable records with a single form using Fillout
HTML-код
- Опубликовано: 2 окт 2024
- Fillout for the win!!!
Follow: / realationlco
##
My name is Max, the founder of Relationl and we build custom Airtable databases for the music industry.
If you find this content helpful and want to explore more you can schedule a free consultation using this link bit.ly/ia30yt
Check out more case studies at industryauto.co
Get started with Airtable & Make (affiliate links): airtable.com/i...
www.make.com/e...
Hi! Thanks for this. Is there a way to do something similar to this without creating an entry on the main page? Im setting up a run log for people to add their times. I want them to chose their existing record and add as many runs as they want, on new lines. A version of this method works, but its creating a new blank record on the main table each time I use it. Thanks!
@@nickcross410 hey! You want to create a form in the Run Log table that includes the Person field and then use the URL from that form to construct a prefilled version in a formula field on the People table. The field you want to prefill and hide is the “Person” field.
This will give you a unique Run Log form URL for each Person to use to log their runs.
support.airtable.com/docs/prefilling-a-form-via-encoded-url
Thanks for the video, it definitely clarifies the concept
Are you familiar with the "generate pdf" integration by fillout themselves? If so, is it possible to include the "members" list in the pdf?
Hey Mosh, no I am not. I use documint.me for Airtable to pdf automations.
Excellent. Although I think using the URL attribute to pass the family name was an unnecessary step in this case. I think we could have simply used @ and added the field directly from the first table. Since these tables are part of the same form, all of the information is available available using @. URL parameters are great for loading fields with record data that are not collected in the form. Anothrr cool idea would be to preload the last name field using @ in the default value. and we could also default the relationship value to child.
Fillout is such a remarkable tool, They have truly done great things in the form space.
You are exactly right!
Can then the submitters edit their submissions?
Why with airtable and not with notion or google sheets?
Hey! Yes they can edit their submissions, and Fillout integrates with Notion and Google Sheets as well.
Quick question. A new record is created for the child object when they click submit on the subform before the whole form itself is submitted. What if an applicant closes out of the form before they complete it? Or what if they want to delete a record they just generated? Doesnt this mess with the back end?
If they don’t submit the parent form then the child record will remain orphaned. You can leave it there or create an automation to have it deleted. I just leave them there. Same thing if they unlink a child record before submitting the parent form.
This is a wonderful solution, only better would be Airtable integrating this into their forms. I do have a question in Airtable I have a % field and when using Fillout I enter in 6.25 in the field it populates at 625% in Airtable. Any thoughts on how to fix this?
I agree that Airtable would be well served to have the best forms solution in the market. Especially since most people's introduction to Airtable is from having been sent a form. Regarding your question: there are two ways to accomplish this.
1. just type in .0625 into the fillout form.
2. click Logic in the lower right, then Calculations at the top. Create a new value that divides your % field by 100. Then close out the Logic section and click into the Integrations tab at the top of the page. Hover over your Airtable connection right at the top and click into it. You will see a list of Mappings. Change the Mapping of the % Field to the new calculated value you created.
Let me know how that goes!
@@relationl I appreciate the suggestions. I was able to get the calculations to work, this is better for my brain to understand when entering the form. Appreciate your valuable time, thank you!
@@cottagekeeper i totally understand that! moral of the story is that Fillout has thought if literally everything :)