How to display a message based on a field choice in appsheet form

[Nielay]

I'm building a form in which when I select the drug name field I need to show a message based on the choice of the drug, but the data of the message is in a different sheet which was initially a JSON file that I converted into a sheet. How do I do this?

This is the sample data that I'm trying to work with. I need to display the data in baseline provided

JSON format: 

{
"criteria-schema": [

{
"Diagnosis":{
"disease":[
"congenital generalized lipodystrophy",
"acquired generalized lipodystrophy"
],
"relation":"OR"
},
"Baseline provided":{
"baseline":[
"HbA1c",
"Triglycerides",
"INSULIN, FASTING, SERUM"
],
"relation":"AND"
},
"Complication":{
"complication":[
"Diabetes mellitus;>6.5",
"hypertriglyceridemia;>200 mg/dL",
"fasting insulin;>30 uU/mL"
],
"relation":"atleast"
},
"Dosage_thr":{
"male":"<40kg:0.13 mg/kg;>40kg:10 mg",
"female":"<41kg:0.14 mg/kg;>41kg:11 mg"
},
"Relation":"AND-AND-AND"
}

]
}

[dbaum]

You presumably need to structure your data in rows and columns, rather than JSON arrays within cells.

Once you can reliably reference the data, you can create a Show type column with an expression in the Content property that retrieves the "baseline provided" message that's applicable to the selected drug.