Hello. I have created an app that lists multiple events in a calendar view. The supporting sheet is a simple list of date/time, event name, event description.
I’d like to allow users to have a switch / choice where they can say “Yes” or “No” for attending a particular event and have their view of that choice remain on the page for them. (Like a favorite.)
I’d like to be able to go back into the spreadsheet to gauge attendance and report.
I don’t want to use a form because (1) seems like an extra step / bad user experience and (2) I don’t think I can get the form response to persist on the event page.
Any suggestions appreciated.