When adding rows to an automotive repair app, users should capture every vehicle's VIN via barcode scan for accuracy. Some auto manufacturers place VIN stickers in hard-to-reach locations that can only be scanned with laser barcode readers. In these cases, manual input is necessary and since VINs are 17 characters in length, there is high likelihood that typos will occur.
Knowing that typos are inevitable, when VIN barcodes cannot be scanned, employees are instructed to input only the last 8 characters and capture a photo of the VIN sticker in an image column. When the length of [VIN] is less than 17 characters, then [VIN PHOTO] is a required value. Some employees choose to ignore instructions and manually input the entire VIN because they figured out that the image capture is not required if 17 characters are present.
I realized this was occurring after noticing VINs containing lowercase letters in the backend spreadsheet. Is it possible to create a required_if expression for [VIN PHOTO] if the value of [VIN] contains lowercase letters?
LinkedIn
Twitter
