Skip to main content

AirTable whipped me up an amazingly impressive starter app - tables and forms - from a description of my needs.   (Which blew me away.)  I'm now trying to tweak at it to make it do some basic things.   The application manages the inventory of a seed sharing scheme for a horticultural society.   As you can see, it's done something really sensible as regards the tables needed.  (I added the gallery view of the seed types list.) 

AirTable has also made a nice little request form.

 

What I'd like to whip up, is a public interface which shows something like the Gallery view, where on each of the cards, there is a link to a request form. When the form pops up, it is autopopulated with details of the seed packet being requested.  So the person requesting a seed packet will not have to enter the info about that specific item, but can request simply by supplying their email address.   (I'm not, at the moment, at all  concerned with people being able to order multiple seed packs in one go,  or with whether they are on a recipients list, etc.)

Is this something I can achieve in AirTable?  What kinds of things should I be looking at, in order to get this together?   I've totally new to building anything more than simple search in AirTable, so I'm still trying to work out what makes sense as an approach here.

 

thanks!

 

Try using a prefilled form link?  The gallery would look like this:

And once the user clicked the 'Request' button they'd be shown a form like this with the 'Seed' pre-selected:

They'd then key in the amount they want and hit submit, which results in this:

And I've set it up for you here!

@MegaCurious 

Yes, you can do that with prefilled forms in Airtable.

Airtable’s support article on prefilled forms is located here, but it’s significantly easier to setup a prefilled form URL by using @kuovonne’s free Prefilled Forms Extension, which will generate the URL formula for you.

You can also use very similar prefill techniques with Fillout’s advanced forms for Airtable, which is 100% free and offers hundreds of advanced features that you can’t get with Airtable’s native forms.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Try using a prefilled form link?  The gallery would look like this:

And once the user clicked the 'Request' button they'd be shown a form like this with the 'Seed' pre-selected:

They'd then key in the amount they want and hit submit, which results in this:

And I've set it up for you here!


awesome!  thank you.  (please could you keep the example up until I have time to study it.)

@MegaCurious 

Yes, you can do that with prefilled forms in Airtable.

Airtable’s support article on prefilled forms is located here, but it’s significantly easier to setup a prefilled form URL by using @kuovonne’s free Prefilled Forms Extension, which will generate the URL formula for you.

You can also use very similar prefill techniques with Fillout’s advanced forms for Airtable, which is 100% free and offers hundreds of advanced features that you can’t get with Airtable’s native forms.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 


great resources - many thanks.  I picked the "first past the post" one as "solution" as had essentially the same core advice and  it pipped you by 10 minutes - but I really appreciate the extra info about other resources.  thanks!

great resources - many thanks.  I picked the "first past the post" one as "solution" as had essentially the same core advice and  it pipped you by 10 minutes - but I really appreciate the extra info about other resources.  thanks!


Ha, you're welcome! I believe that you are allowed to mark multiple posts as solutions, if you're so inclined!

- ScottWorld, Expert Airtable Consultant 

Ha, you're welcome! I believe that you are allowed to mark multiple posts as solutions, if you're so inclined!

- ScottWorld, Expert Airtable Consultant 


done

Reply


Terms & Conditions