Automatic update of date field
Is it possible that a date field is automatically updated/renewed when the end date has been reached? I have a field called "expiry date" in my workspace and I want that it automatically switches from January 31 2017 to January 2018 e.g. when the date has come.
in Globiflow go to the app where the date field is in. Then create a new flow with trigger condition "Date Field".In the filter select the date field so that the filter is: IF [Your date field] is equal to [current date]
Then add the flow action "Update item", activate "Hook event" and select the date field
[Your date field] = Calc date("Y-m-d",strtotime([your date field]." + 1 year"))
"Calc" must be selected in the dropdown where you see "Value" ,
date("Y-m-d",strtotime([your date field]." + 1 year")) you must enter in the box behind Calc
[Your date field] must be the blue token which you select from the pane at the right side which opens when you click the little icon in the box.
In the head of the the flow you also can select at which time the flow should run (default = 00:15).
Thanks as always for your help Rainer.
I tried this and was able to get it to work with a Podio Date field, however I was unable to get it to work with a Podio Calculation field; when this Globiflow ran on a calculation field it reset the date to January 1 1970. Have you encountered this as well? It's completely possible I've done something wrong.
Please sign in to leave a comment.