Skip to main content

Hi all

I want to build an Enquiry form that will have prefilled information and prefilled options based off the logged in user. e.g. they may have multiple delivery locations

I also want to have an option to create more options for adding products (as per below)

Thanks!

 

re: I want to build an Enquiry form that will have prefilled information and prefilled options based off the logged in user. e.g. they may have multiple delivery locations

Hmm, prefills will require user to click on a link that includes the prefill data I'm afraid: https://support.airtable.com/docs/prefilling-a-form-via-encoded-url

Maybe check out Fillout.com? Seems like they let you prefill stuff dynamically, but I'm not sure how that would work with the login stuff you mentioned: https://www.fillout.com/help/prefill-fields

For the multiple delivery locations thing specifically, you could do that with Interface forms I believe, you'd just need to assign an email to each location.  In your form you'd then have a linked field to the "Locations" table and have a filter on the email field for "Current User":


---
re: I also want to have an option to create more options for adding products (as per below)

This is adding new records to the "Products" table I presume?  If so, I'd suggest trying Fillout.com as Airtable forms don't allow for linked record creation at this time.  A workaround people use sometimes is they provide a link to another form for users to create records there, then come back to the original record


@FPX 

You would typically want to use Fillout’s advanced forms for Airtable for this.

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, display Airtable lookup fields on forms, create new linked records on a form, add 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


re: I want to build an Enquiry form that will have prefilled information and prefilled options based off the logged in user. e.g. they may have multiple delivery locations

Hmm, prefills will require user to click on a link that includes the prefill data I'm afraid: https://support.airtable.com/docs/prefilling-a-form-via-encoded-url

Maybe check out Fillout.com? Seems like they let you prefill stuff dynamically, but I'm not sure how that would work with the login stuff you mentioned: https://www.fillout.com/help/prefill-fields

For the multiple delivery locations thing specifically, you could do that with Interface forms I believe, you'd just need to assign an email to each location.  In your form you'd then have a linked field to the "Locations" table and have a filter on the email field for "Current User":


---
re: I also want to have an option to create more options for adding products (as per below)

This is adding new records to the "Products" table I presume?  If so, I'd suggest trying Fillout.com as Airtable forms don't allow for linked record creation at this time.  A workaround people use sometimes is they provide a link to another form for users to create records there, then come back to the original record


Thanks mate. 

 

The products part is for buyers to submit an enquiry per line item (product) on quantity and price. 

I will eventually want to have this where enquires get sent to all suppliers on the marketplace (currently just me as the supplier).

Thanks