I have created a new “GUID field” with a text data type due to an integration. I need to VALIDATE it. Now i know how to use the validation function. But i need to validate so when the GUID is manually entered through a form in NAV, I need to check if the format is correct or not. If it has an incorrect format. It has to throw an error.
Example correct GUID: “CDEF7890-ABCD-1234-ABCD-1234567890AB”
Incorrect GUID: “CDEF7890-ABCD-1234-ABCD-234567890AB” (‘This has wrong format with a digit missing’)
I have checked into Evaluate and Format function in NAV, but i dont have an idea on how to use them with GUID field. Can anyone please guide me on what should i do to Validate the format of the GUID field?