This so quickly and easily solved my airtable problem...I was trying to prefill the form using automations and couldn't figure it out, but changing the URL was so quick and easy. THANK YOU!!!!
This is so clear and helpful, thank you! One question (and I'm using the Kuvuonne app): I tried doing this without creating and then linking a separate table, but when I do that it simply creates a new record instead of updating the old one. Is the only way to prevent this to have the results in a separate table and then set up an automation to link them?
Short answer, yes. Submitting a form will ALWAYS create a new record. If you want a form-like interface where you are directly editing an existing record, you might try creating an Airtable Interface. Interfaces are an incredible tool, the main downside being that only logged-in users can access them (at the time of writing). Fingers crossed that they change that at some point
Awesome video! Super helpful! In my use case however, for some reason, for some records the prefill works but for other records the field that should be prefilled is blank even though that field in the table has a value. Any idea why that may be? Thanks again
Hi Jason! Two questions for you: 1) does it work for the same field sometimes and not other times? 2) Do the prefill data types match the field type? for example putting only numbers into a number field
@@julian_post Thanks! I think it was the fact that the value to be prefilled was a single select. Once I change it to a simple text field it worked. For some reason, using a single select made it work for one value but not for any of the others. Thanks again, looking forward to more of your videos!
Very helpful! I do have one issue in that prefilled date fields (like Birthday), in the pre-filled form show the date as one day earlier than what's actually entered (for instance, a birthday is entered in the Airtable data correctly as 1/14/87, but in the pre-filled form it shows 1/13/87). This happened for another date field as well, and I checked it for multiple records. I copied the Prefill extension code into TextEdit to check it and that seems fine, but then I copied the URL into TextEdit to check, and there's some code with the date fields that I'm unfamiliar with: &prefill_Industry%20Start%20%28Year%29=2015&prefill_JSI%20Start%20Date=2019-04-15T00%3A00%3A00.000Z&prefill_Birthday=1987-01-14T00%3A00%3A00.000Z. How would you clean that up to reflect the actual data? Thanks so much!
Hi Kirsten! My guess is that it's a time zone issue. Airtable handles all dates in GMT, but you can format them to show your local time. Post your question in the community, and I'll help you figure it out! community.3rings.co/t/discussion-for-how-to-set-up-prefilled-and-hidden-form-fields-in-airtable/25
This so quickly and easily solved my airtable problem...I was trying to prefill the form using automations and couldn't figure it out, but changing the URL was so quick and easy. THANK YOU!!!!
Welcome! The URLs are so useful :)
This is so clear and helpful, thank you! One question (and I'm using the Kuvuonne app): I tried doing this without creating and then linking a separate table, but when I do that it simply creates a new record instead of updating the old one. Is the only way to prevent this to have the results in a separate table and then set up an automation to link them?
Short answer, yes. Submitting a form will ALWAYS create a new record. If you want a form-like interface where you are directly editing an existing record, you might try creating an Airtable Interface. Interfaces are an incredible tool, the main downside being that only logged-in users can access them (at the time of writing). Fingers crossed that they change that at some point
Awesome video! Super helpful! In my use case however, for some reason, for some records the prefill works but for other records the field that should be prefilled is blank even though that field in the table has a value. Any idea why that may be? Thanks again
Hi Jason! Two questions for you: 1) does it work for the same field sometimes and not other times? 2) Do the prefill data types match the field type? for example putting only numbers into a number field
@@julian_post Thanks! I think it was the fact that the value to be prefilled was a single select. Once I change it to a simple text field it worked. For some reason, using a single select made it work for one value but not for any of the others. Thanks again, looking forward to more of your videos!
Very helpful! I do have one issue in that prefilled date fields (like Birthday), in the pre-filled form show the date as one day earlier than what's actually entered (for instance, a birthday is entered in the Airtable data correctly as 1/14/87, but in the pre-filled form it shows 1/13/87). This happened for another date field as well, and I checked it for multiple records. I copied the Prefill extension code into TextEdit to check it and that seems fine, but then I copied the URL into TextEdit to check, and there's some code with the date fields that I'm unfamiliar with: &prefill_Industry%20Start%20%28Year%29=2015&prefill_JSI%20Start%20Date=2019-04-15T00%3A00%3A00.000Z&prefill_Birthday=1987-01-14T00%3A00%3A00.000Z. How would you clean that up to reflect the actual data? Thanks so much!
Hi Kirsten! My guess is that it's a time zone issue. Airtable handles all dates in GMT, but you can format them to show your local time. Post your question in the community, and I'll help you figure it out! community.3rings.co/t/discussion-for-how-to-set-up-prefilled-and-hidden-form-fields-in-airtable/25
You had me until Donald Trump and Ted Bundy... 😆
😂It's the top most searched names on Wikipedia (in random order)