Use variables in flowfield calcformula

Answers

• AlexeyShamin Member Posts: 80

  2020-11-06 Answer ✓

  Hello!
  In this case you cannot use 'if' in flowfield.
  You can use some code for update Description filed in OnValidate trigger field 1 and field 2

  5
• Ale Member Posts: 7

  2020-11-06

  field(1; "Code"; Code[20])
  {
  Caption = 'Code';
  DataClassification = ToBeClassified;
  TableRelation =
  if ("Status Object" = const(Customer)) Customer
  else
  if ("Status Object" = const(Item)) Item
  else
  if ("Status Object" = const(Vendor)) Vendor;
  trigger OnValidate()
  var
  Customer: Record Customer;
  Item: Record Item;
  Vendor: Record Vendor;
  begin
  case "Status Object" of
  "Status Object"::Customer:
  begin
  Customer.Get("Code");
  Description := Customer.Name;
  end;
  "Status Object"::Vendor:
  begin
  Vendor.Get("Code");
  Description := Vendor.Name;
  end;
  "Status Object"::Item:
  begin
  Item.Get("Code");
  Description := Item.Description;
  end;
  end;
  end;
  }
  
  Did it like this

  0
• Slawek_Guzek Member Posts: 1,690

  2020-11-15 Answer ✓

  It's the way to go about this sort of problems, however the Description field becomes static and won't be updated if Customer, or Vendor or Item name changes, unlike in a 'normal' flowfield case.
  
  If you need the Description to be updated you'd have to create a code, 3 separate functions subscribing to OnAfterModify in Customer, Vendor and Item and keep your Description field updated when the name changes in any of these.
  
  As an alternative (albeit also far from perfect) you could create 3 'regular' flow fields, one for Customer, one for Vendor and one for Item respectively and control their visibility on pages.

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  5