Hi everyone! I’m a complete beginner at building apps — this is my very first time and I really don’t want to give up halfway through. 
I’m trying to build an app for my wife’s spa, where she can store the clinical history of her patients. So far, I’ve created three tabs/screens: Clients, Clinic Record, and Sessions.
What I want to do is: every time I add a new record in the Clients tab, I’d like the client’s name to automatically appear as a choice in the Clinic Record tab, so I can continue entering their clinical information.
Also, in the Sessions tab — which will be used to record each of the patient’s visits — I’d like to link each session to a specific client as well.
Does anyone know how I can set this up?
Thanks in advance!
You can use the clients table as the source of a choice component, or create a query column to get data from the clients table and use the column as the source.
You will need to use the row id of each client (add a new column in clients table of type row id, if you don’t already have one) and put it in a client id column for each sessions. Then, you will be able to create a relation column with the clients table => row id and the client id column of this row.
2 Likes
Thank you very much, Maxime. I created a ‘Name’ column and used it as the relation column between the different tabs, using a Choice component as you suggested. However, I’m curious about the part regarding the query column — what are the benefits of using that option?
The query column allows you to apply filters, sorting and limits. It is arguably one of the most powerful computed column types.
2 Likes