Every month I receive a spreadsheet with tickets available with its code, expiration date and type.Code  |   Expiration Date  |  Type (3d or normal)...            ...                  ......            ...                  ...I tried using Google App Scripts, however, to request tickets, I've made a form, and I can't create a ListBox based on something. For example, I have the type ListBox, and once I've selected the type, the Quantity checkbox should be able to show how many tickets are in for that type.Form:Type: [listbox]Quantity: [listbox based on how many tickets are available for that type][Submit]edit: Spreadsheet example
How would I use Google App Script to create a ListBox based on a spreadsheet entry?
google spreadsheets;google apps script