Yes i did use row owners for the user profiles, so yes i realized this will be the issue. Is it Possible to have two row owners? I am thinking about the user being the row owner as well as myself as an admin? (For all users)
Yes, you can do this by creating an array column in your Google sheet by naming consecutive columns the same with sequential numbering (ex. āEmail 1ā, āEmail 2ā, etc.). This will create a single array column of āEmailā in the data editor that you can then assign as your Row Owner column. The first āEmail 1ā column can be filled and used by to the user. The second āEmail 2ā column can be filled on your sheet using an arrayformula to automatically fill with your email address when new user rows are created. This will make both the user and yourself a row owner.
You can avoid all that by removing row owners, but if user data needs to remain confidential and secureā¦and you are the only one that needs to see all participants for an event, then I would recommend sticking with the Row Owners option.
2 Likes
I donāt really understand how the template column can join the Event ID and the signed in User, do I miss a function of the Template column here?
Your template would be āEVENT_ID USER_IDā, replacing EVENT_ID with the event ID, and USER_ID with the user ID.
3 Likes
Thank you, what an honor! it worked out!
I will keep asking here, because you helped a lot so far:
What I would like to achive next, is that the participant will see a ādrag outā option, so that in case the participant doesnāt want to participate anymore, he will have the option to drag out of the event. I am not sure if this is possbile, because we had the issue before with deleting rows as a user, which is not possible as far as i understoodā¦ So visibility will be the previous discussed relation āis not emptyā. but then I am not sure how to achiven that instead of deleting the row in the participant sheet, the already existing columns ( ID and mail) can be clearedā¦ I assume the screen column feature within the form does always relate to a new row and not an existing oneā¦
Well, the issue mentioned before with not being able to delete is really an issue with not having the ability for a deleted event to automatically go through and delete all participant records. In that case, the participant records would just be left hanging, but due to how the relations are set up, those hanging records would never be visible in the app.
You can definitely remove a participant by deleting a row. When you add editing functionality to a record in the Details view, you also have the option to add Delete functionality. But the complication comes in the fact that we have set up a relation to the participant sheet, then a lookup of those participants to create another relation to the user sheet. Currently, the list of users you see under the event are coming from the user sheet (not the participant sheet), so itās not as simple as opening the details of a participating user clicking the edit pencil and deleting the record. That would delete the user out of the user sheet.
There are a couple of ways to approach this.
- First, you could get rid of the participant lookup and the relation to the user sheet from that lookup from the Events sheet. Instead, you would directly use the original relation to the participant sheet to view your list of users for an event. With your current setup (assuming you are using row owners on the user sheet), this would cause all users to be able to view all other participants, but weāll come back to that. In the participants sheet, you would then need to create a single relation to link the participant ID to the ID in the user sheet. Then you could create Lookup columns to pull in relevant information from the User sheet into the Participant sheet, such as user image or name. The only downside is if you have row owners enabled on your user sheet, then only the information for the signed in user will be visible and you may see additional empty rows on the list of participants under the event. You could however filter that list if the relation is empty. Doing everything this way would allow the user to view their participant row details for an event, and then have the option to edit the record and delete the row (or drag out) of the event. This would delete their record from the the participant sheet.
- The second option is somewhat similar, but you could keep your existing setup where the list of participants is actually a list from the user sheet, but either create a separate section in you app to allow the users to view their rows in the participant sheet and allow them to edit and delete the record, or you create a relation in the user sheet to the participant sheet, that would allow them to edit and delete their row.
There are a handful of ways to approach it, but it all comes down to how you want the app to flow.
2 Likes
Would I have to remove it, or is it possible to keep it and set up this feature, because for now i went with option 2 and the user is able to remove himself from the event through his profile, where i activated another inline list.