Update a field according to the selected value to go to the detail

#1

I have a tab that’s generated from a Query. This query brings up the summation of the transactions.I want to put the graph on the same screen where it shows the composition of the total balance, that information is on another sheet and is obtained with another query. The relationship between tables is done, but for the query where the graph comes from depends on the value selected. Next image is with the value entered manualy

bitso1
bitso11662×728 125 KB

Is it possible to detect which option was selected on the screen to pass that value to the cell from which the query that obtains the detail is controlled?

bitso 2
bitso 21694×463 92.1 KB

Many thanks for you help

#2

Hi Juan, sorry if I got it wrong, but can’t you just setup a choice component containing all the options available, then pass that value to the cell you want?

1 Like
#3

Can you show a little more information? Are you building your second query dynamically based on a selected value in the app? If so, that’s not going to work very well. You should be able to do this with relations/lookups/rollups and no queries at all, but it’s hard to tell without seeing more of your data layout.

1 Like