I’m new to Glide and I’m struggling with a few concepts and I got stuck with the schedule section of my veterinary hospital app.
In order to have the vets checking their next appointments, I added on their profile page a button that’s linked to an appointment table (“appointments”). But this forces me to repeat some information (pet’s pictures, owner names, appointment date, etc…) that is already included in a “master” table (“identification”) where already lives all the information regarding the pets, including their next vet appointement. And the thing is the appointment page would retrieve dates from the “appointments” sheet but not from “identification” sheet. I’m obviously not doing it the right way.
My question: what would be the process to retrieve an appointment date from the “master” sheet instead of fishing from a specific “appointment” sheet?
I’m totally stuck and lost after two days trying different things… thanks for your help