Announcements
Hey everyone,
I have created a custom field into an existing table. I want that whenever a value is inserted to the custom field, the same value should be inserted into one of the specified existing field. Like for example in the figure below, for a specific "No." when "Net change" is 749259.10 then "Budgeted Amount" should also become 749259.10. Remember, I don't want it for the entire column but for a specific "No.". Kindly address my concern. Thank you.
Ok. Thanks all for the answers.
Hello,
You Modify "Net Change" field
Try below code,
Modify("Net Change")
{
trigger OnAfterValidate()
var
begin
rec."Budgeted Amount" := Rec."Net Change";
End;
}
Thanks
No, this is not possible.
FlowFields are not physical fields that are stored in the database.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfields
Is there any way to add a custom value in a flow field?
Hi,
You can not assign any value to or from of those fields as those fields are Flowfields in the table. Also if you want to you can introduce your custom field and do the following
Rec.calcfields("net Change");
Custfield := Rec."Net Change";
This is an idea but use calcfields for fields.
Thanks.
it is not working. I have attached the screenshots. You can validate whether it is correct or not and if not then provide me with your code. The EventSubscriber must be in code that's why I have created one. Thank you.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156