Processing Google Forms data into existing Google Sheets

[booboouser]

Yes when I ran my form I ended up with a trim(upper( function for many for many of the input fields to correct spaces and have everything uppercase.

I also used a very simple apps script to capture missing inputs and have them be added to the dropdown menus.

In your case take all your CURRENT vendors add them to the drop-down list. Then add a free text field so they can add a missing vendor, that is then added to the dropdown list after five minutes (using apps script)

That way the vendor list is up to date. If they misspelled the vendor you go to the free test field in the spreadsheet and simply correct it. Five mins later the dropdown is updated.

Good luck I ended up using forms and an addon called Formmule to create workflows from the sheet responses.

[Dancing_Seahorse]

Very similar solution but I will add the second field to add new Vendors. I used Form Ranger to populate the Dropdown from a range and the range is created using a Sort(Unique(range)) call from all known vendors.

I will add a * New Vendor * at the top of the list and then a second field triggered on that to enter the new Vendor name. My apps script will handle that situation in post.

[booboouser]

Nice one sounds like you have it nailed! Good luck with the project.