is it possible to use the toggle switch in some clever way to either use query a or b for tables / charts etc.
reason: I've got an table where i can select entries to get usage details. the way this works: i hit an button that triggers an automation script with different feeds to it, based on the toggle switch i either create an CSV with the total count or i create an CSV with an Detailed count. in the total count i mark the unused detail fields empty.
Then i use the CSV adhoc source to fetch that file and join the data with the table i selected information from. However if i selected the toggle switch i want to have some more joins.
There are several solutions to this but it all boils down to, can we have the toggle switch as an sort of if statement (and queries usable in flows)
option 1) have the flows have an if operator that takes the state from the toggle (bit like the merge then then A/B) (also have the flows handle query as input)
option 2) in the actions have an if option based on the state of the toggle( if toggle true then show panel a if false then show panel b)