How to calculate field for each record in the page without creating a new field in the table?

zaidtariqzaidtariq Member Posts: 52
I want to have a new field "Source Name" added on the page. This field must be "calculated" for each record in the Page using "Source Type" and "Source No.":
While "Source Name" must only exist in the Page - do not create a new field in table
Best Regards:
Zaid Tariq
Dynamics NAV/365 BC Developer at Dynamics 360

please like / agree / verify my answer, if was helpful.


  • Options
    krikikriki Member, Moderator Posts: 9,096
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    KishormKishorm Member Posts: 921
    Create a variable, add to the page, add code in OnAfterGetRecored trigger to calculate and set the value of the new variable.
  • Options
    bbrownbbrown Member Posts: 3,268
    Alternate solution: Add function(s) to the source table that calculate and return the needed values.

    Advantage: Functions are reusable elsewhere.

    There are no bugs - only undocumented features.
Sign In or Register to comment.