I am working on a seat booking system so that user can fill in seat preference on Google form and data would be updated on Google sheet linked to Google form. However the key is that I want to show a real time information in form of matrix (with row and column in grid like fashion to indicate which seat is booked and which is available), so that user can fill the choice correctly in the Google form before submitting the form.

I somehow feel that requirement to show the real time information in form of matrix side by side to Google form may not be possible.

It could be my technical knowledge limitation on Google form and Google sheet. Would appreciate your thoughts on this if this can be achieved.

Thanks

CodePudding user response：

• Publish