# Event Registration without forms **URL:** \ **Category:** Ask for Help\ **Created:** [February 25, 2020, 5:08pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924 "2020-02-25T17:08:00Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Stefan\_LK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefan_lk/32/3825_2.png) [@Stefan\_LK](https://community.glideapps.com/u/Stefan_LK)\ **Post date:** [February 25, 2020, 5:08pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/1 "2020-02-25T17:08:01Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 26, 2020, 5:12am UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/2 "2020-02-26T05:12:39Z")
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. ---
**Author:** ![Stefan\_LK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefan_lk/32/3825_2.png) [@Stefan\_LK](https://community.glideapps.com/u/Stefan_LK)\ **Post date:** [February 26, 2020, 9:39pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/3 "2020-02-26T21:39:07Z")
Jeff. Thank you for this. It was the perfect solution. I appreciate the quick help. ---
**Author:** ![Ns\_Melaka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ns_melaka/32/10399_2.png) [@Ns\_Melaka](https://community.glideapps.com/u/Ns_Melaka)\ **Post date:** [July 14, 2020, 2:37pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/4 "2020-07-14T14:37:52Z")
Hi Stefan, Is it possible to share this solution? I am just starting on this journey, so unsure how to setup. Thank ---
**Author:** ![Stefan\_LK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefan_lk/32/3825_2.png) [@Stefan\_LK](https://community.glideapps.com/u/Stefan_LK)\ **Post date:** [July 15, 2020, 12:54pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/5 "2020-07-15T12:54:14Z")
I’ll be honest … it’s been several months since I’ve looked at this … let me review what we built and see if I can share the template. ---
**Author:** ![Ns\_Melaka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ns_melaka/32/10399_2.png) [@Ns\_Melaka](https://community.glideapps.com/u/Ns_Melaka)\ **Post date:** [July 23, 2020, 12:09am UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/6 "2020-07-23T00:09:34Z")
Much appreciated. thanks ---
**Author:** ![Stefan\_LK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefan_lk/32/3825_2.png) [@Stefan\_LK](https://community.glideapps.com/u/Stefan_LK)\ **Post date:** [July 23, 2020, 7:38pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/7 "2020-07-23T19:38:07Z")
Here is the app I created based on the solution provided. I hope it helps: [https://go.glideapps.com/app/hBynhXz54EtN6IpvTwym](https://go.glideapps.com/app/hBynhXz54EtN6IpvTwym) ---
**Author:** ![Ns\_Melaka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ns_melaka/32/10399_2.png) [@Ns\_Melaka](https://community.glideapps.com/u/Ns_Melaka)\ **Post date:** [July 24, 2020, 9:12am UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/8 "2020-07-24T09:12:58Z")
Thank you. For some reason the link does not open up. it keeps going forever like attached photo. some permission setting? Kind regards. ![hang](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5434737d1ece7e0ab931ba448f579e58ad6fa1f3.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 24, 2020, 9:29am UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/9 "2020-07-24T09:29:15Z")
You share the wrong link I’m afraid. That’s the link to edit in your editor, others can’t have access. You can use the “Share” button and copy the public link to your app there. ---
**Author:** ![Stefan\_LK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefan_lk/32/3825_2.png) [@Stefan\_LK](https://community.glideapps.com/u/Stefan_LK)\ **Post date:** [July 24, 2020, 4:38pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/10 "2020-07-24T16:38:25Z")
[https://rhetorical-spoon-4169.glideapp.io/](https://rhetorical-spoon-4169.glideapp.io/) hopefully the above works? ---
**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\ **Post date:** [July 24, 2020, 8:47pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/11 "2020-07-24T20:47:59Z")
Hi Jeff, Can you explain this a little further. I am having trouble connecting this. I know its probably something simple. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 26, 2020, 8:05pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/12 "2020-07-26T20:05:11Z")
What are you having a problem with? ---
**Author:** ![Ns\_Melaka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ns_melaka/32/10399_2.png) [@Ns\_Melaka](https://community.glideapps.com/u/Ns_Melaka)\ **Post date:** [July 29, 2020, 11:18am UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/13 "2020-07-29T11:18:17Z")
Thank you Stefan…I have a better understanding now. ---
**Author:** ![rmst60](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rmst60/32/587_2.png) [@rmst60](https://community.glideapps.com/u/rmst60)\ **Post date:** [April 7, 2021, 6:38pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/14 "2021-04-07T18:38:58Z")
Looks like the google sheet is too large to copy the app. Is there anyway you can create a template or something where the copy app would work? I’d appreciate it as this has some excellent features ---
**Author:** ![Stefan\_LK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefan_lk/32/3825_2.png) [@Stefan\_LK](https://community.glideapps.com/u/Stefan_LK)\ **Post date:** [April 7, 2021, 7:01pm UTC](https://community.glideapps.com/t/event-registration-without-forms/4924/15 "2021-04-07T19:01:02Z")
It’s been a while since I looked at this, and for some reason I couldn’t convert to a proper template. I’m not sure why anymore.