Hello,
I would like to ask if what will be my workflow for this using analytic apps:
a. Allow users to enter a cut off date (e.g. 2021-12-31)
b. Cutoff period: Enter number of days before and after the cutoff date
c. Generate journal entries within the cutoff period. Hence, all entries posted from 2021-12-26 to 2022-01-04 must be filtered.
Kindly see the attached app for the input.
Please see screenshot for the expected order of the interface:
Solved! Go to Solution.
Wow. Amazing! Thanks @Jean-Balteryx .
You're welcome @Gamaliel !
Hi @Gamaliel
I know this is already been amazingly solved by @Jean-Balteryx . I wanted to share another approach using action tool. I prefer this because I can actually run the workflow to check the data flow before running it as an app (where data flow gets hidden).
Workflow:
Numeric up-down i am directly replacing the numbers in action tool. For date since its used twice I am using formula in action tool to replace the date with interface tool data flow [#1]
Hope this helps : )
Thanks for this another tip @atcodedog05 .