Validate field to UDT

SOLVED

Created a UDT for customer type and now trying to set validation on CustomerType field in AR_Customer to my UDT for customer type. It will only let me do this if I choose all users, all companies in advanced field settings. I don't want this validation in other companies only one company. Is there a way around this?

Parents
  • 0

    Sounds like you might have to script it.  You should be able to find some examples of using oScript.SetError on a pre-validate event and how to read UDTs using the BOI.  I have an example on here on how to add a lookup to a field too, although I don't think I have ever tried it with a UDT but if an ALE record is created in the User Lookup Wizard for you UDT then you should be able to use it with my script example.

Reply
  • 0

    Sounds like you might have to script it.  You should be able to find some examples of using oScript.SetError on a pre-validate event and how to read UDTs using the BOI.  I have an example on here on how to add a lookup to a field too, although I don't think I have ever tried it with a UDT but if an ALE record is created in the User Lookup Wizard for you UDT then you should be able to use it with my script example.

Children