Hey, so I have a list of โPatient IDsโ which I get by subtracting two lists e.g (list 1 - list 2). Now the resulting list of โPatient IDsโ from this expression contains IDs which I want to show in an enum list. Until here it is all fine and I am able to do this.
Now, instead of the patient IDs, I want to show the Patient Names in the Enum list because that will be more readable for the user. I am not able to find a way of doing this.
I was thinking of functionality like a Lookup function which can lookup an entire list of values and returns a list of values instead of just a single value (if that makes sense)
Hi Mate, thanks for such a quick reply. I like the approach you shared but actually even my Patient ID is not the Key Column, I have a different Key Column. Is there any way for that?
The only way to display one thing in a dropdown while storing something else is by using a key (a Ref value) to display its label.
Please describe your table structures a little more. This dropdown is to provide a value for a column of a row of what table? Is there a separate patients table?
Yeah Steve, I have two tables. One is โPatients Sample Sentโ and another is โSample Return from Chinaโ. In โPatients Sample Sentโ table I record the Patientโs sample sent to China row by row. Then I have a โReturn from Chinaโ table. Now, in โReturn from Chinaโ table, I have a enumlist dropdown for selecting patient samples as multiple patients sample can be returned in single courier from China.
Also, a very important thing. I have created a third table โPatients sample returnedโ for recording the patient samples row by row which have already returned from china The dropdown will only show the patient samples which have not yet returned. To achieve this I use list subtraction where I deduct Patient Sample Column of table โPatient Sample Returnedโ from Patient Sample Column of table โPatient Sample Sentโ
Provided that multiple โpatientsโ sample sentโ can be contained in a single โReturn from Chinaโ, I would advise setting the โSample sentโ table as a child of (search : ispartof appsheet) the โReturnโ table.
Keeping things as enumlist can get things done too, but a parent-child relation offers far more flexibility.
From the โSample sentโ table :
You can add that sample to a new โSample returnโ by an action. Make a column in the โsentโ table thatโs a yes/no column (sample marked for return?). An action will mark that column of the concerned โsample sentโ record to yes.
You can add a sample to an existing โSample returnโ, same way marking that column to yes.
You can add sample sent records to sample return records from within the sample return table, by referencing the sample sent table (which would be set up already if you do the โispartofโ) and devise a proper valid-if to filter all those records that doesnโt have the โsample marked for return?โ column as yes.
Also, since the sample sent rows that have been assigned a return shipment, will inherently contain the sample return reference, you can make use of isblank() and IN() to do away with the additional column.
Given that you are subtracting lists, I might as well would assume you are advanced enough to understand what I said above.
Sorry friend but i am not that advanced user in App Sheet. Can you please refer me a resource where i can understand a little more about your approach. Or if you can just guide me a little more over how to set a child tble. I will try to do the rest myself
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |