Filter Journal Entries from the Cutoff Period

[Gamaliel]

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:

[Jean-Balteryx · Accepted solution]

Hi @Gamaliel ,

Here is a workflow that I think do what you want ! 

[Gamaliel]

Wow. Amazing! Thanks @Jean-Balteryx .

[Jean-Balteryx]

You're welcome @Gamaliel !

[atcodedog05 · Accepted solution]

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 : )

[Gamaliel]

Thanks for this another tip @atcodedog05 .