Is there a way to check if a field has more characters than a specific amount?
I am trying to set up a beast mode function that checks if fields are correctly filled out in our asset tracking software, and lists out any asset that does not meet all requirements (ie fields not filled out or have been auto-generated by the software itself).
One thing I am curious about is, I'd like to be able to include a function that can see if either one field (Serial Number) is empty OR has more than 7 characters included. I am fairly new to beast mode calculations, and we have most everything working properly to check all empty (NULL) fields and one field if it is either empty or auto generated (LIKE 'EXAMPLE-%'), but I'm not totally sure if or how to check if the character count is more than 7 characters in a field.
I hope I'm making some sort of sense here. And thank you for any advice!