Skip to main content
Question

Custom Field format string

  • February 1, 2021
  • 1 reply
  • 213 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 replies.

1 reply

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 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,