Workflow based on value in calculation field
Hi,
I'm trying to create a workflow based on a value in a calculation field.
The calculation field is a calculation of number of days between a start date and end date. When the calculation field reaches 365 days, it should trigger a new item in another app.
When I'm trying to create a flow based on field has changed, I can't seem to select my calculation field. Should I make this value a text value instead or why isn't it working?
Thanks!
-
Hi Wendy, as per my experience, you cannot trigger a flow in Podio Workflow Automation PWA (formerly known as Globiflow) based on a calculation field in Podio.
However there is a tricky workaround to do this in Globiflow:
Suppose the field is named as Inspection Period on which you're trying to do this:
- Assuming we should only do this for start date, create a date flow based on that Inspection Date field as show in the screenshot.
Trick here is to create a date flow and trigger it on the basis of 365 days, meaning, it will say as in the screenshot that start date (of Inspection Period) is now 365 days less than current date.
This will trigger your date flow and you can do anything with your item which triggered the date, maybe create a new item in another app to let you know that this item has passed its 365 days criteria from start date.
Note: if Start date and end date is fixed, there is no way the difference would be increased or decreased, so that's why I'm assuming that you need a flow to be triggered 365 days from the starting date of Inspection Date as compared to current date which always changes.
Let me know if you have any questions!
Thanks!
Please sign in to leave a comment.
Comments
1 comment