Inserting form information is a specific field

Barbara Witt

I am colleting one piece of information via a form. How can I match the information up with the primary column, so that the field for this specific row is updated?

It appears forms add information to the bottom of the sheet. I have created a separate sheet to collect the information via the form and then I am using a vlookup to insert the specific piece of information into the field, by matching up the primary column. I would like to avoid the extra step and automatically insert the specific piece of information into my field. Is that possible?

If not, within the form, can I reference the drop down from the main spreadsheet or can I only reference information within the spreadsheet, where the form lives?

Thank you very much.

Kelly Moore

Hey @Barbara Witt

In the trigger, did you specifically check the box of ANY VALUE and specify the column that will be updated? Often the words 'any value' are displayed however I have to physically check the box. Which column you designate is also important - for instance If you chose Created (date) as your column to trigger, it only changes that first time when a row is created. It is never modified after that time.

When you build automation, in addition to the triggers that are listed in the top field of the automation window, you can specific conditions that may further filter your workflow- which is probably not the problem in this case. But for future reference here's an example

If you share your automation and help us understand your workflow so we have an idea of how the triggers occur, we can help you with the automation.

Let us know what we can do to help

cheers,

Kelly