create a custom error message if a field's data already exists and prevent the record from being saved

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
fgazza
Veteran Member
Posts: 205
Joined: 2019-04-30 17:37

create a custom error message if a field's data already exists and prevent the record from being saved

Post by fgazza » 2019-08-16 13:44

Hello.
I have a table with the fields "name" and "surname"
I created a "name_surname" field in which the fields "name" and "surname" are automatically concatenated.
The "name_surname" field is set as unique.
I would like if an "name_surname" field already present in the table appears as an error message such as "this name is already present in the database - it is not possible to re-register an already present name. Cancel the creation of this record and modify the record related to the name already registered "
How can I do?
Thank you!!!
Fabiano

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: create a custom error message if a field's data already exists and prevent the record from being saved

Post by onoehring » 2019-08-17 06:32

Hi Fabiano,

I suggest you use a hook (before_insert). Just test if name_surename already exists, if not, show some JS error and cancel the insert.
BTW: Are you sure, that name_surename is unique?

Olaf


Post Reply