I create an app to let parents neighbours schedule kids go-to-school walk buses. I would like that this app should be very extra simple for users, so I didn’t want them to have to login or signin.
Here’s how it works :
- 2 tab in gsheet : one for the journey and one the building identification (name and building id)
- an input on the home, which is user specific (user code on the journeys sheet tab)
- always on home, a button to go to the building journey tab, with an inline list of journeys filtered by building code
- on this building journey listing tab, a button with action! 1/ add a new row to journey tab, populating the building id input with User code (preset on home by user) 2/ open a link to screen in detail mode with input to add a new journey to this building (name of parent, date of journey, way school to building or building to school)
I don’t want people to add a journey if the building doesn’t exist in the building gsheet tab. To not allow this, my trick was to set a single value column in the building tab sheet, populated by the User code from Journey tab, and an if/then/eslse column displaying “yes” if the single value column equals the building code id
When it doesn’t shows a “yes” in this column, I don’t show the “add journey” button
For filtering the building journey inline list, I have an If/the/else column that display “yes” if User code equals building code on the Gsheet Journey tab :
My problem is that if there’s more than one people with the same User Code in the app at the same time, just one can see the button nor the listing in the building Journeys tabs. Here are screenshots for the building journeys tab showing different for 2 users with same User Code at the same time :
I think it is because there’s a conflict with User code that are the same for users and that is User specific, but I don’t really understand what’s happening.
If someone could help
Thanks a lot!