sorry for opening this many requests but I just had to dive into Podio and Podio API for a current project and although I like the idea a lot and see the potential Podio offers, I hit walls every now and then and have to find solutions for trivial stuff. The worst thing in my opinion is that many problems feel "unnecessary" ie. could easily be fixed in my understanding.
One such thing which seems that many many users here are facing is the fact that calculated fields are not recalculated unless a variable changes. This is a big problem for every use case having to handle anything like e.g. "days since x" and "days until x". So it is a much requested feature and there are many posts about it. Sadly many of them are answered, although answers are wrong (do not take into account that formula is not recalculated) or recommend to use third party tools or some hacky workarounds which are not only dirty but also not guaranteed to be future-proof and safe for production use like use fake apps that you reference from every item, update calculation formula with fake timestamps, switch to number fields that are daily updated via API,...
I would really appreciate an official answer what is considered the best way of doing this and which way is also the "official" one, meaning it can be safely used in client projects.
So to not only bring up questions, I also want to share what I feel should be a viable solution (coming from database and software development myself).
Why not simply introduce an implicit variable like @currentdate in calculated field formulars and update all calculations that use this on a daily basis? If you are brave (and users could need it) you could also add @currentyear, @currentmonth, @currenthour,... I understand this recalculations eat server resources, but be honest - now we also have some workarounds out there which do the same and cause the load but are at least to say "dirty" and make Podio feel weak. So I think this would be a very good improvement which could help lots of (potential) Podio users and make such a trivial thing like calculate "days until next weekend" a no-brainer.
Please sign in to leave a comment.