* Title
* Media
* Dimensions (height x width x depth)
* Price
I've gotten validation on Price that I am happy with but could use help with the others:
* Title - cannot be na, n/a, NA, N/A, not applicable
* Media - cannot be na, n/a, NA, N/A, not applicable or more than 30 characters in length
* Dimensions - want to make sure it is [1-99] X [1-99] X [0-99] where it allows decimal places and is checking for three numeric dimensions separated by X or x
I know that dimensions might be more easily achieved by breaking it into 3 text boxes. However, I would either have to glue it back together to the format above (which I am blanking on how to do) or make the respondents write it that way. My clients are not computer savvy and cannot handle the three dimensions being in separate columns in the data they view - most are not even comfortable opening an Excel file.
Any help you can give is appreciated. I feel like I shouldn't be struggling with this but it is throwing me for a loop.
Thank you!
Best answer by TomG
View original