This time I´m trying to get a data field auto populated in a form for a household water pumping project.
So, when filling the form in the app, the user selects a “Tank” from a dropdown, the next field (which is Litres per minute) it should be autopopulated according to the water flow the pump can provide to that specific tank.
That data should be pulled from another table called “LitresperMinute” which has two columns, “Tank” and “LXM”, which basically says how many litres per minute the pump gets to that tank.
This is the formula used, but it keeps retrieving only the first result of the returnColumn, and its not updating when selecting different “Tank” from the dropdown.
LOOKUP([Tank], Litresperminute, Tank, LXM)
Would appreciate some help!