Question

Unit code

  • 18 August 2023
  • 1 reply
  • 40 views

Userlevel 5
Badge +9

We have a unit code of ea which shouldn’t have been created but can’t delete it because it’s been used. 

 

Does anyone have a suggestion on how to ensure that the users cannot type ea instead of EA?


1 reply

Userlevel 2
Badge +6

If you want to add a validation, consider setting up an event that activates when a record is created or updated within the designated entity. Within this event setup, opt to use an event action of either 'Execute Online SQL' or 'Workflow' type. This choice will enable you to incorporate a validation step that assesses the letter case accuracy before the data is stored in the database.

Refer https://docs.ifs.com/techdocs/foundation1/040_administration/240_integration/320_events/default.htm

/Trewon

Reply