Create mandatory field

(0) Share

Report

Posted on by Morten Steengaard

555

Hi experts,

I would like to create a mandatory field on the table "Shipping Agent". It is an integer.

If I write my validation code in the OnInsert trigger on the table extension, it is too soon. When the user leaves the first field, it is validating the field that the user hasn't come to yet. That doesn't work.

If I write my validation code in the OnModify trigger on the table extension, it is not executed if the user simply enter a value in the first field and then leave the record. That doesn't work either.

I have another table, that I have created in my app. That table has a page, where I have set "DelayedInsert = true". That works, but I cannot set this in a page extension, but only directly on the page.

How do I make a simple and secure mandatory field, so that it is impossible for the user to create a record with zero in my integer field?

I have the same question (0)

All responses (13)

Answers (1)

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

Go to that Page and write your code on OnQueryClosePage trigger, I hope it will solve your problem

Thanks.

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

Hi Nitin,

Thank you for your reply.

I think that would work if the page was a card page, but in this case it is a list page. So I can create a lot of bad records, before OnQueryClosePage is triggered.

(Of course, I can write some code in that trigger telling the user that one or more records are wrong and must be changed, before the page can be closed, but that is not a beautiful solution.)

Was this reply helpful? Yes No
Amit Baru 3,037 on at

Like (0)

Report

Hi,

Write code on "OnQueryClose" trigger.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Nitin Verma 21,698 Moderator on at

Like (0)

Report

Ok,

Try to subscribe the Event of that table "OnBeforeInsert" and then check

Thanks.

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

Now, I have made this in a codeunit:

[EventSubscriber(ObjectType::Table, Database::"Shipping Agent", 'OnBeforeInsertEvent', '', true, true)]

local procedure MyProcedure(var Rec: record "Shipping Agent"; RunTrigger: Boolean)

begin

Message('event...');

end;

It is called when the user leaves the first field ("Code"). That didn't do the trick.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

Do the yellow changes.

[EventSubscriber(ObjectType::Table, Database::"Shipping Agent", 'OnBeforeInsertEvent', '', true, true)]

local procedure MyProcedure(var Rec: record "Shipping Agent"; RunTrigger: Boolean)

begin

Error('event...');

end;

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

It is still called at the wrong time.

When the user enters something in the first field ("Code") and leaves that field, then it should not give an error telling the user that my field has no value. The user has not reached to my field yet.

The error message must come when the user has had the chance to enter a value in my field, but did not do it.

I have a feeling, that it is not possible in Business Central.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

try with event

[EventSubscriber(ObjectType::Table, Database::Yourtable, 'OnAfterModifyEvent', '', false, false)]

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

That didn't work either :-(

With this code I can create a record with a value in the field "Code" and no value in my mandatory field.

Was this reply helpful? Yes No
YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following helps as well.

https://yzhums.com/4940/

Thanks.

ZHU

Was this reply helpful? Yes No