I have tried everywhere to find the answer to this one and I am now going slightly crazy……………….
in summary, when I allow my user to add a new record I want to set the value of one of the fields (columns) based on a relation (in order to maintain a link) rather than have the user chose.
In this specific case a PATIENT is related to a single PRACTITIONER which they cannot change. The PATIENT can add updates on their progress and so is also related to multiple UPDATES. When the PATIENT adds a new UPDATE (which Glide beautifully relates to them automatically) I also want this UPDATE to relate to the USER’s current PRACTITIONER (for future reporting purposes). I cannot see how to “automate” this without asking the user to select the PRACTITIONER manually.
How on earth do I do this?
Many thanks - loving Glide so far.