Is there a way to pass data from one form to another? For example, if I have 'Orders' and 'Order Line Items' tables, and I want to create a form to add a new order and include all of its line items. Today I have to do it in two different forms. First create the order, then create the line items and manually input the order ID that I just created through the first form. Would be great to be able to do it in a single form, or at least to connected forms where the 2nd one just draws the newly created data from the first form.
@sgrass111 Yes, there actually is a way to do this! I wish there was a less hacky way to do it, but this will work: Forms allow you to redirect to a specified URL (see "Redirect to" at the bottom of the form builder). In your "Order" form, enter the line item form URL and add to the end of it: ?prefill_Order={Record_ID} Where Order is the name of the field in the Order Line Items table that links to Orders. Then at the end of the line item form, toggle the option to "Submit another response" or "Show another form after 5 seconds" to add more line items. This Airtable doc shows how to do a similar thing, but go to the actual form record: support.airtable.com/docs/applications-of-record-functions#form-redirects-with-recordid If you try this and run into issues, post a question in the community forum (link in video description) so that we can use screenshots to better see what's going on!
0:30 - Grid to Form
1:44 Customizing Fields
3:13 Conditional Fields
4:50 Logo & Banner
5:31 Submission Options
7:11 Sharing & Embedding
13:14 Prefilling & Hiding
19:22 Updating Existing Records
Thank you for this informative vid
Glad you liked it!
Is there a way to pass data from one form to another? For example, if I have 'Orders' and 'Order Line Items' tables, and I want to create a form to add a new order and include all of its line items. Today I have to do it in two different forms. First create the order, then create the line items and manually input the order ID that I just created through the first form. Would be great to be able to do it in a single form, or at least to connected forms where the 2nd one just draws the newly created data from the first form.
@sgrass111 Yes, there actually is a way to do this! I wish there was a less hacky way to do it, but this will work: Forms allow you to redirect to a specified URL (see "Redirect to" at the bottom of the form builder). In your "Order" form, enter the line item form URL and add to the end of it:
?prefill_Order={Record_ID}
Where Order is the name of the field in the Order Line Items table that links to Orders. Then at the end of the line item form, toggle the option to "Submit another response" or "Show another form after 5 seconds" to add more line items. This Airtable doc shows how to do a similar thing, but go to the actual form record: support.airtable.com/docs/applications-of-record-functions#form-redirects-with-recordid
If you try this and run into issues, post a question in the community forum (link in video description) so that we can use screenshots to better see what's going on!
@@julian_post will try that, thanks!
@@julian_post worked, tx!
Julian, I need to speak to you about building a base for me. How can I contact you?
Hi Greg! Shoot me an email info at 3rings.co - look forward to speaking with you