Hello,
I am querying 4 values from the API i am using into a combo box 1, and i using the following formula to get the data to show.
Option({project: PID.text, phase: phase.text, plan: ???, elev: ???}).codes
I am using another combo box 2 that are showing the plan and the elev with this formula: Concatenate(Plan(PID.text, {phase: phase.text}).plan, "-E", Plan(PID.text,{phase.text}).elev).result
How can i fill the gaps on my combo box 1 values for plan and elev leveraging combo box 2 data?

Report
All responses (
Answers (