Help

Prefilled Forms

Topic Labels: Interface Designer
194 3
cancel
Showing results for 
Search instead for 
Did you mean: 
FPX
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

FPX_0-1720701645266.png

 

3 Replies 3

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":

Screenshot 2024-07-11 at 10.03.41 PM.png

Screenshot 2024-07-11 at 10.03.34 PM.png


---
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 offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.

— ScottWorld, Expert Airtable Consultant

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