Force / Trigger Calculation Fields to Update in a single item only



  • To combat this issue, I've used the following steps effectively with several client systems:

    1. Add a category field to the app template called something like "Refresh Field"
    2. Make it a drop down with a single selection of "Update Calcs"
    3. Just for OCD I build a quick globiflow that says anytime we select that drop down, instantly go unset that field so it's ready to use again next time. 
    4. Then in any Text result calc fields on that page you can add a var refresh = @Refresh Field

    That variable doesn't have to be used in the displayed result of that calc field at all, it will still prompt any/all calculated fields on that item to update themselves whenever the Refresh Field value is changed.

    Known limitation is that this doesn't work for numerical result calc fields, but it's generally simple to refresh numerical calcs by manipulating one of the input number fields.

    Hope this idea can work well for you as it has for me.

    Comment actions Permalink
  • Fritz Feger

    A workaround for number fields is to add some @refresh_number to all number calculation fields (not just as unused var as in the string example above, but really as part of the calculation of the return value), which is usually empty but when you put a number in it all fields are calculated anew.

    However, it's a shame that this is necessary. Fields not updating is a known bug since forever. Podio, find a solution!

    Maybe it will give you a motivational kick when you realize that both workarounds presented here might produce massive numbers of calculation eating up expensive resources on your server you will not be able to bill to the customer. I for one send such value from one place through many referenced apps with dozens of calc fields each.

    Comment actions Permalink
  • Asad Ali

    Good luck getting a response from Podio. Ive got 3 tickets outstanding and one has been from 6 days ago. Not a great service for $24 a month and when I am looking to upgrade to 50 users in the coming weeks. 

    I posted a questions regarding some calculations on the forum and had nothing back. Is podio on its way out?


    p.s. Sorry to hijack your post! 

    Comment actions Permalink
  • Carson,

    Thanks that is a very useful idea for me to implement where this is most often an issue. 

    Comment actions Permalink
  • Patrick Gilliland

    I have tried the above method and it will not work for me.  

    I have to save the record snd refresh the screen each time which is very cumbersome - any other tips.

    Sorry new and not a dev!





    Comment actions Permalink
  • Thank for the idea. My problem was to refresh the formula daily, to receive Days on Market of my properties when I look at my dashboard. I have added a @current date on my field formula and used globiflow to refresh it once day midnight.

    hope it helps someone in the future! btw google spreadsheet refreshes dates and formulas in real-time it would be a good addition to Podio.

    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk