Skip to main content
BOOK A DEMO

Search

frequency of recalculation of calculated fiels using an expression

Christoph Käferböck
  • Discussion Created

Hi together,

I observed that calculated fields using an expression als calculation does not get recalculated automatically when a value of the calculation changes. That's pretty boring as this is the key-advantage of automatically calculated fields: I dont' have to monitor "manually" to update the value if integraded values do change. 
So - when and how often does calculated fields recalculate?

Best regards,

Christoph Käferböck

0

Comments

3 comments

Date Votes
  • Kilgore ServiceAccount
    • Edited

    This is a very good question! Funny this was posted just yesterday, as I just ran into this question.

    When and how often? Also: are there possibly better strategies for achieving this?

     

    In my Use Case: In my Dossier List, I have (6) Single Text fields for each Child List [DelaysToday, DeliveriesToday, etc]. They simply keep a count of the number of Child Items, related to the Dossier ID. These are utilized to control automations & visibility. 

    The issue is that my solution allows for Child Items to be added both within the Dossier Form & from ListView via Command Bar buttons.

    It is the Child Items added via Command Bar Actions that made me go to 'Things in the background', and attempt to set 'DelaysToday' with a Calculated Value.

    The Dossier Form is no issue at all.

    Within the Dossier Form, I simply have each of these 6 fields with Initial & Calculated values, along the lines of:

    =[[@Web.QueryList('Delays', '<View><Query><Where><Eq><FieldRef Name="DailyFieldReportID" /><Value Type="Text" ProviderType="FormInput">[[ID]]</Value></Eq></Where></Query></View>')]].length

    Visibility is controlled, similarly with: (to share knowledge)

    =[[@Web.QueryList('Delays', '<View><Query><Where><Eq><FieldRef Name="DailyFieldReportID" /><Value Type="Text" ProviderType="FormInput">[[ID]]</Value></Eq></Where></Query></View>')]].length >= "1"

     

    Curious to better understand this and potential strategies!

    Thanks,

    Taylor

    0
  • Kilgore ServiceAccount
    • Edited

    I guess, I found something that Calculated background Columns doesn't like...

    [Edit: I know realize that doing it this way is going to create an Array, whereas within the Dossier Form, it is only dealing with a single item. I am guessing I will have to split the IDs in someway if this method is actually viable...]

    I am using this as the Expression:

    =[[@Web.QueryList('Delays', '<View><Query><Where><Eq><FieldRef Name="DailyFieldReportID" /><Value Type="Text" ProviderType="FormInput">[[ID]]</Value></Eq></Where></Query></View>')]].length

     

     

     

    0
  • Christof

    Hi Christoph Käferböck
    To your initial question: The field's calculation should be triggered automatically as soon the value of a referenced field placeholder in your expression changes.
    If this is not the case, please contact our support with details about configuration to create a support ticket.

    0

Please sign in to leave a comment.