Skip to main content
Question

Custom Field format string

  • February 1, 2021
  • 1 reply
  • 204 views

Forum|alt.badge.img+18

We need to create a Custom Field for the EORI number and would like to know how to handle the fact that we require the following format:

 

First 2 characters (Alpha)

Next 12 characters (numeric)

 

Would I have to create the field as a text field and then run a custom event to check that the contents meet the format?

Can anyone please advise a better way?

Thank you.

This topic has been closed for comments

1 reply

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 181 replies
  • February 2, 2021

Hi @johnw66 ,

Unfortunately yes since we do not control alphanumeric in custom fields. You have to create a custom field in text and then write an event (PLSQL code) _CFT table to validate the format. 

Thanks,

Kind Regards,


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings