I get it, but I need a little rope here.
I don’t want to get the reports run on schedule but on demand. That requires a certain value (preferably in a Yes/No Column) to change to some other that would trigger the workflow/report.
Now here I have a search form, with two input fields - ‘From date’ and ‘To date’. There’s a slice from the main table that shows data based on the values of the search form (A Date column in the main table should be between the from and to dates). The latest row is taken into account, for which I have used MAX([_ROWNUMBER]) in the expression. There’s an action to navigate to the table view of that slice, and that action has been set to trigger when the search form is saved.
Now how should I generate the report on demand? If I use an action to set a ‘No’ column in the search form to a ‘yes’ value, and use a select expression to define:
if that column in the search form becomes Yes, then trigger the report
will it do?
I mean will the select expression work in the trigger condition at all?
Even if it does, I will have to navigate to the Detail view of the search form and manually trigger the report. Or if I set the initial value of the ‘Yes/No’ column to ‘Yes’, does that mean the report will trigger because the column value here is ‘Yes’? Or triggers happen only when a ‘change’ is imminent?