75
Hi. In one of setup tables I created my new custom field. This field depends on value of five other fields - all these field must be 'true' if value of my custom field also can be 'true'.
So when user set 'false' value of one of these five fields - my custom field should change value to 'false'.
What is the most optimal way to achieve this?
Trigger OnModify() inside table? OnAfterModify Event Subcsriber in separate CodeUnit? Or maybe any other idea?
In addition to the codeunit mentioned by Mohana, you can also use tableextension directly.
For example,
If you want to change immediately, I recommend adding each field.
Or you consider enabling the following functions.
Business Central 2022 wave 2 (BC21) new features: Auto-save as you work -> Trigger timing of OnModify (Table) Trigger/OnModifyRecord (Page) Trigger has changed
Hope this helps.
Thanks.
ZHU
If you want that code to be executed after modifying all fields then OnAfterModify trigger.
Otherwise, you can create a function and call the function in each field OnAfterValidate trigger.
But in situation when I need check five fields - more optimal is create 5 subscribers to OnAfterValisate triggers or maybe one subscriber to OnAfterModify?
You have to subscribe to OnAfterValidate trigger of the field in a codeunit.
Than you for your reply.
But what if the fields are standard fields? And I cant use On Validate triggers?
Hi, If I understand correctly, it's simple to do with OnValidate Trigger.
For example,
Share
Report
All responses (
Answers (
table 50112 MyTable2
{
DataClassification = CustomerContent;
fields
{
field(1; MyField; Integer)
{
DataClassification = CustomerContent;
}
field(2; A; Boolean)
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
if A = false then
CustomField := false;
end;
}
field(3; B; Boolean)
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
if B = false then
CustomField := false;
end;
}
field(4; C; Boolean)
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
if C = false then
CustomField := false;
end;
}
field(5; D; Boolean)
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
if D = false then
CustomField := false;
end;
}
field(6; E; Boolean)
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
if E = false then
CustomField := false;
end;
}
field(7; CustomField; Boolean)
{
DataClassification = CustomerContent;
trigger OnValidate()
begin
if CustomField = true then begin
A := true;
B := true;
C := true;
D := true;
E := true;
end;
end;
}
}
}
PS: You can replace "If Boolean = true then" and "If Boolean = false then" with "If Boolean then" and "If not Boolean then".
Hope this helps.
Thanks.
ZHU
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,038
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
