Hi all! Is there a way to return a text value of a specific row number in a column of one table, to a specific row number in a column of another table? For example, I have created 2 tables โPersonal Detailsโ and โDiagnosisโ, and the โDiagnosisโ table is referenced to the โPersonal Detailsโ table by a UniqueID. If I want the โPersonal Detailsโ table to have a column name called โInvolved organโ, which is just a text field that cannot be filled by anyone, but will only get filled with either โLiverโ, โPancreasโ or โBiliary Tractโ words only when I go and select either โLiverโ, โPancreasโ or โBiliary Tractโ option from a Enum column called โInvolved organโ in the โDiagnosisโ table, can that be done? Thank you.
May I ask which one is a parent table? โPersonal Detailsโ or โDiagnosisโ?
@Aleksi_Alkio Personal Details Translate
I wrote an arrayformula expression to the spreadsheet and now it fetches the data from the Diagnosis table that I populate through the AppSheet app and displays that data on the read-only text columns in the Personal details table. So now it works. Still couldnโt figure out a way to do that through AppSheet though.
Although Iโd be grateful if you could shed some light as to how one could fetch data from one table to another within the app itself. Opens up loads of possibilities.
You can do that with a virtual column likeโฆ INDEX(SELECT([VirtualListColumn][ColumnName],TRUE),1). Please remember it will read only the first value if you have chosen the same parent record more than once. The same with your sheetformula.
@Aleksi_Alkio It worked! Super cool! Thank you very much for your help!
Youโre welcome
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |