I am using the in_valid method of creating a dropdown in a field for a list of serial numbers. However, I would still like to accept inputs that matches (say the first 5 numbers of a serial number are valid, but the entire number does not match a list defined). ** something like this accepts inputs but the field is no longer a dropdown ** =OR(FIND(“9781”, [Lookup1])>0, IN([Lookup1],ItemSerialNumber[LookupNumber]))
You could probably do this with the ref field because then the validation would happen in a different place. If you need to read the dropdown values from a different table dynamically, you can’t add an extra validation. If you do, it will filter the existing list.
Another possible process method I thought of is to see if the “show if invalid” setting can do more than just show a message. Can any of the expressions trigger an action? That way, the use can be prompted to go ADD the new entry that’s not already in the validated list.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |