I’ve tried many experiments so far but I can’t quite grasp the best way to achieve what I am looking for.
The app is for a street team to visit multiple venues and prove they have been there.
My main issue is how I organise things, in my mind 2 tabs Users & Venues or should I add a visits aspect to it? The purpose is that members of the team (users) visit a specific venue and to prove they have done so they take a photograph and fill in a few key details about the venue.
Venues: I want to display if it has been visited or not (by one or more users)
Users: I want to display which venues they have visited and when.
I know this is all quite generic but pointers in the right direction would be much appreciated.
I like starting with the user experience – pencil, paper, sticky notes, drawing screens and user journeys – and working backwards from there to determine how screens might be built in the Glide builder and how the tables of data might be organized in the Glide Data Editor and Google Sheets.
Idea:
Users (tab) – name, email, image, description, etc.
Visits (tab) – venue_name (where), user_name (who), date (when), visit_proof (what, the image)
Venues or Choices (table only) – venue_name, venue_image, address, phone, etc. (information that purely describes the venue, if at all necessary)
How you display the components in the builder with date and image pickers and inline lists and whatnot is really up to you. For me it’s easier to start from the user experience and work backwards from there.
