Here i show how to use Google sheets and form as a theatre seat booking system. There is no payment options but it gives a chance to book seats on internet or on phone. It's not "bullet proof" and with little upgrades You may get it even better :) I'm just an amateur with Sheets, and this will be my first and last tutorial video.

Long and hard formula from video: ArrayFormula(TRIM(split(TRANSPOSE(split(query(TRANSPOSE(query(IF(Form!A2:A="";;IF(SPLIT(Form!C2:C;" ")="";;"☺"&SPLIT(Form!C2:C;" ")&"~"&Form!B2:B&"~"&Form!D2:D));;6^6));;6^6);"☺"));"~")))

свернуть