Skip to main content

Search

Dynamic values on a Calculated Sublist Field using Actions Builder

Comments

2 comments

  • Christof Nussbaumer

    Hi Andreas Teixeira

    Your approach will not work because: with [[@Sublist.Addresses. ...]] placeholders you will get back always all related adresses. but this is anyway not the way to build that case.

    In your structure of the masterlist "Companies" and the sublist "Adressen" you can react on changes of the masterlist values that are used for calculations in your sublist by Metadata Inheritance.

    1. Create a column "CompanyName" on your "Adressen" list and configure an "Inherit" calculation for the company's Title column in "Things in background". Result: Every address item will get it's parents company title in this column and this will get updated when it changes on parent list.

    2. Now you can use this calculated column "Company Name" to calculate your title of "Adresse" item. As well as field calculation in "Things in background"

    This configuration will keep always the titles of all your "Adresse" items up-to-date when the "Company" name will change.

    Since this calculations are automatically done "in the background" it takes some seconds until it changed on each item. Probably you want to calculate it as well on the forms when users are working with it and want see the calculated title immediately. Therefore add the same title calculation on the new- and editform of the "Adresse" list:

    1
  • Andreas Teixeira

    Great explanation Christof!
    It worked perfectly as you have described. Thanks for the help, its very much appreciated.
    Best regards
    Andreas

    0

Please sign in to leave a comment.