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?
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.