Form Fields Auto Populating based on another field selection

[KatBolish]

Hi everybody, 

I am attempting to use forms to update fields in my table. I need to be able to pre-populate the other fields in the form with the current information that is in the table, is this possible?

For example: 

I have a table of "Items", and each row has the item name and columns of information about the item- owner, amount, etc. In the form, the first question is "what item would you like to update?" with a linked record to the first column with all the items. When an item is chosen, I'd like the other fields to auto-populate with the current information in the table with that item, so they can see what they're updating. If they choose "Scraper", for example, I want the next field of "How many" to auto-populate with the amount that is in the table, and then of course I want them to be able to edit it if necessary. 

Is this possible, maybe with Zapier? Thank you.

[TheTimeSavingCo]

Hi Kat, you'll probably need to use a third party tool like miniExtensions or On2Air forms for what you're looking to do

Pre-populating fields based off of existing data is possible with Airtable's native functionality (with a somewhat complicated setup), but having the pre-populated data updated based on the linked field the user selects in the first question is not possible with native Airtable forms, thus my recommendation of third party tools

[HannesK-ME]

Hey there, Hannes from the miniExtensions team here. Like Adam has already mentioned, our form can do just what you're looking for! The easiest way to set this up would be to use our login/lookup functionality, which would allow your users to select the item they want to edit. Once they select the item on the login page, our form would pull up the corresponding record from the items table, where your users could then view/edit the appropriate fields! It's all very straightforward and can be set up in a matter of minutes. Plus, you can try it out for free right now by signing up for a free account! 🙂