I’m building an app where doctors can create appointments with patients.
I have 4 collections: Users, user type, relation and appointments
Users have all users with an user type (either doctor or patient).
Relation has a 1 to 1 relationship between patients and doctors (doctors can have many relations while patients can have only 1).
Now the problem:
I’m trying to show the names of the patients in a form where the doctors create appointments.
But, I’m not able to show the name of the patients related with the doctor (logged user) in a dropdown.
My form creates appointments and in the Select field for the “Patient” the custom filter is “Current user > appointments” from here, I can go to “relation” but not to “users” to get the name of the patients.
I’m trying to follow the blue line to get the name, but is not possible.
Is there a way to do this?
Thanks
