I am creating a scheduling feature in my app, where members can give options to each other about when they would like to have their next meeting set.
I was able to show a list of proposed dates as an inline list, and since the project is still small and there are only a few members participating, I was able to single out each attendee to create an action row where there is an option to click either Yes, I can attend or No, I cannot attend in the detailed screen. The results will be sent to another sheet called Confirmed Attendees using the “add row” function.
The problems that I need help with are below:
-
Because the name of attendees shown in the detailed screen are the attendees that the owner of the meeting has selected using the Choice botton, the names are not tied to each of the attendee’s User ID. These names are tied to the owner’s User ID who is convening the meeting. Because of this, I am unable to filter the list of names thus enabling all attendees to confirm attendance of any one of the attendees in the list.
-
I also want to prevent duplicate submissions from the same action row by the same attendee. I read the Help section that touched on how to avoid duplicate entries and it said that I should create a relation for this but the demo was when a user was entering his/her name in a form and this situation doesn’t apply in my case where I want to search for a duplicate in the same sheet.
Thank you for your help! I am VERY new to Glide but I am already excited about what I can do with this. I really appreciate any advice I can get to get over this hurdle.