Filter Journal Entries from the Cutoff Period

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:

Cutoff Testing.yxwz

Interface Tools

Accepted answers

Jean-Balteryx

Hi @Gamaliel ,

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

Cutoff Testing.yxwz

atcodedog05

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

Cutoff Testing (2).yxwz

All comments

Jean-Balteryx

Hi @Gamaliel ,

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

Cutoff Testing.yxwz

Gamaliel

Wow. Amazing! Thanks @Jean-Balteryx .

Jean-Balteryx

You're welcome @Gamaliel !

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335