Strange behavior with calculation field - data cache?

Answered

Follow

Ansar Muhammad (Anz)

• October 14, 2015 06:06

We have a calculation field in one app which uses unix timestamp in the calculation to compare with current time and do the logic.
The result of this calculation field is used in another calculation field in a referenced app.
The calculation works fine and display the data properly - for few days and then it starts failing. It works again if we make the first calculation field dirty (by adding a space or line) and save it.

Is this because of Podio data caching? Any idea how to fix this?

0

• 

  Hamid

  • October 14, 2015 10:04

  Hi Anz,
  The problem with this is that podio do not refresh items only if some chage happend on it.
  you can add in your app a related date field in an app witn one date field wich you can update mannualy every day.

  sorry for my bad english :)

  0

  Comment actions Permalink
• 

  Ansar Muhammad (Anz)

  • October 14, 2015 11:55

  Thanks Hamid. I understand the problem now :)

  0

  Comment actions Permalink
• 

  Andreas Forstinger

  • October 14, 2015 13:20

  that is one of the pitfalls in calculations. please consider reading this and maybe have a vote on it...

  https://help.podio.com/hc/communities/public/questions/204569657-Definite-solution-for-today-handling-in-calculated-fields-days-since-days-until-countdown-incl-possible-solution?locale=en-us

  when doing workarounds like manual updating to force recalculations keep in mind that there is a limit on how many revisions an item can have. currently it is 5k IIRC.

  0

  Comment actions Permalink
• 

  Ansar Muhammad (Anz)

  • October 14, 2015 15:09

  Thanks Andreas. It makes sense :)

  0

  Comment actions Permalink

Please sign in to leave a comment.