Tableau Conference is happening now. Tune in to activate your data superpowers with Tableau and Agentforce. Watch live on SF+ for exclusive digital content, new product demos, and key insights for data and analytics lovers.
I have a 6 digit number field that when it is filled in, I want to make sure its a 6 digit number and not zeros. Is there a way to validate this? I've tried OR(NOT(REGEX( CPI_Numbertext__c ,"^[a-zA-Z0-9]*$")),REGEX( CPI_Numbertext__c ,"^[0]*$")) but that doesn't take into effect that if its empty, I don't care. Only when its filled in and saved do I want it to validate the info in it.
