Checkbox instead of choices selection products

Hi Friends!

I have a column called products. How to add multiple products using checkbox instead of choice?

Using choice I need to make one choice at a time. I would like to optimize the choice of several at the same time.


Haven’t done this myself, but here’s my 2 cents about this:

  • Use checkbox to tick multiple products as you wish, remember to set the checkbox to user-specific.
  • Once the check is recorded in the sheet, have a script to write the row to a “Cart” sheet for said customer.
  • Let the customer edit their cart because the quantity wasn’t recorded in the previous part.
  • Once the customer has submited their order, have a script to turn the checkboxes to unchecked again, prepare for their next order.