Automatic update of date field

Follow

Isabel Lissner

• January 15, 2018 11:56

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.

Best regards,

Isabel

0

• 

  Rainer Grabowski

  • January 16, 2018 20:42

  Hi Isabel,

  you can't update a "normal" field by a calculation. You need a flow for that (Globiflow).

  Rainer 

  1

  Comment actions Permalink
• 

  Isabel Lissner

  • January 17, 2018 12:24

  Hi Rainer, thanks a lot for your answer. Unfortunately, I have no clue how to do that. Are there any instructions somewhere?

  Thanks,

  Isabel

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • January 17, 2018 15:58

  Hi Isabel,
  do you have a Globiflow-Account? It's available only for Podio customers with a Podio Premium Licence.

  0

  Comment actions Permalink
• 

  Isabel Lissner

  • January 18, 2018 08:00

  No, I don't have a Globiflow-Account and I have a non-profit sponsorship account, not the premium. 

  0

  Comment actions Permalink
• 

  Darius

  • February 11, 2020 23:16

  Hi Isabel,

  Did you figure out how to update a date field to the current filed?

  I have globiflow but still not sure how to go about it.

   

  Thank

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • February 13, 2020 13:09

  Hi Darius, 

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

  Rainer

  0

  Comment actions Permalink
• 

  Matt Angell

  • March 28, 2022 20:39

  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.

  0

  Comment actions Permalink

Please sign in to leave a comment.