Event Registration without forms

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.

There’s a feature in staging that I hope is release sometime soon. If it truly is what I think it is, it’s a new column type that will save user specific data in a single column. I have no idea when or if it will be released, but if/when it is, I think it will be a great new feature. This would allow you to have a switch to save a value per user. The only downside is that it would most likely not save any of the selections to the sheet for you to gauge attendance.

Until the User Specific Data column is available, I think your best bet would be to use a form to record attendance to a new sheet.

  • On the Event sheet, create a template column to create joined value of event and the word TRUE
  • On the Event sheet, create a template column to create joined value of event and the word FALSE
  • Create a template column on the response sheet to join the event and the users TRUE/FALSE response
  • Create a relation column to link the true template column in the event sheet to the template in the response sheet
  • Create a relation column to link the false template column in the event sheet to the template in the response sheet
  • Create a lookup column to pull back an array list of emails from people who selected the switch to indicate they are attending.
  • Create a lookup column to pull back an array list of emails from people who selected the switch to indicate they are not attending.
  • Using the lookup columns, you can set a visibility condition to hide the form button and show a rich text component that indicates if the user is or is not attending. This takes care of your number (2) concern.
1 Like

Jeff. Thank you for this. It was the perfect solution. I appreciate the quick help.

1 Like