If you open the form editor, the products added in the inventory sheet will appear as options.Įvery time a product is chosen, it will disappear from the form.
Var form = FormApp.openById('paste_ID_of_your_FORM_here') įor (var i = 0 i Create triggers and create these two triggers. Harry is a bit of a slow poke, so when he gets home he opens my link, but alas, he can only have a bowl full of mush.īased on my research so far I will be needing to use the if function on the responses spread sheet to see if there has been a take for an item (see if the cell is vacant) and maybe VLOOKUP, but I can't get a clear picture of how to make it all work together.īased on gssi's answer, I wanted to post the code and describe the way I did it. Dick opens the form link and in the same drop down question he chooses out of the two remaining items. He enters his name and chooses a comb out of a three item drop down list. I tell Thomas, Richard and Henry that they can each have one and send them a link to a Google form I created. I don't what anyone to choose the same as any one else. I want to create a Google form with a drop down list populated form a spreadsheet. I have been trying to get this to work for a couple of days now and I give up.