Show if column is not valid

[Laura_Hong]

I have two columns named “UPC” and “UPC check”.

When “UPC” is keyed in wrongly, “UPC check” will be shown for users to check why was it not valid.

Is this possible?

[Lynn]

@Laura_Hong
How do you know when it is keyed in wrongly?

[Laura_Hong]

i’ll look up to a master table where all the data will be stored.

[Steve]

Laura_Hong:

Is this possible?

Probably.

[MultiTech]

This might be of help:

How To Show a Custom Valid If Error Message Tips & Tricks 💡

You’ve been working long and hard to get your Valid If formula correct, and finally it’s doing what it’s supposed to - preventing duplicates, wrong info, bad dates, etc. from being entered by your users. But now you want to go a step further and provide the user with some info about WHY the data they entered is invalid. This is where the “Invalid value error” field comes into play. [Shared with CloudApp] Utilizing this features is extremely easy, due to the fact that most the hard work has …