Capture number of items in app automatically

Follow

Egil Rødevand

• August 01, 2022 14:36
• Edited

Hi,

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.     

0

• 

  Rainer Grabowski

  • August 01, 2022 15:38

  Hi Egil,

  that's possible.
  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)
  Then:
  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]
  Continue
  Create new Item in App Backlog
  number field = Value [(Variable) sum]
  
  

  0

  Comment actions Permalink
• 

  Bill Carovano

  • August 01, 2022 16:05

  Another option would be to use this function provided by the Procfu extension to PWA: 

  http://www.procfu.com/scripts/?s=app_get_view_total.pf

  0

  Comment actions Permalink
• 

  Egil Rødevand

  • August 02, 2022 14:24

  That works, thank you Rainer :) 
  
  I will check out this option as well, Bill. 

  0

  Comment actions Permalink

Please sign in to leave a comment.