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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148