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: 70
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

onoehring
Veteran Member
Posts: 263
Joined: 2019-05-21 22:42
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

onoehring
Veteran Member
Posts: 263
Joined: 2019-05-21 22:42
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-30 08:13

Hi fgazza,

please see my solution here: viewtopic.php?f=7&t=1740&p=10906#p10906
Does this fir your needs?

Olaf

Post Reply