Capture number of items in app automatically
Is it possible to use workflow automation to sum number of items in an app, and then store the value in a different app. For example, every Monday sum how many items there are in a given app with status "active" and then create a new item in an app called "Backlog", and store the value in a numbers field there.
First create a view in your given app: Status = Active
Then build a By Day or Date flow (at the top of the flows tree).
Set the filter to if weekday = Monday, set the time the flow should run (e.g: 00:15)
Get view from Given App, select the view where the Active items are in
Add a custom variable
sum = 0;
For Each Ref Item(s)
sum = [(Variable) sum] + 1]
Create new Item in App Backlog
number field = Value [(Variable) sum]
Another option would be to use this function provided by the Procfu extension to PWA:
Please sign in to leave a comment.