Conditional: Do a search for ITEM where SKU = inputs’ value :first item ‘is not empty’
If the above conditional is true then the SKU already exists. If you change ‘is not empty’ to ‘is empty’ then you will know it does not exist and is a valid input
Under that condition use the dropdown ‘Select a property to change when true’ and give the input a red border and a red background. You could also put a group next to the input that only shows when the condition is true and have some text that says ‘This SKU already exists’. Also on whatever button you use to submit you can add for it to only work if that conditional is true or false depending on your needs. If you are using auto-binding then it would be much more difficult.
Right. So that’s what I thought. There’s no way to just say “this input is wrong” and I need to do the work of blocking save and warning etc. too bad
Thanks though @williamtisdale
I must say this is a mind boggling omission. Why have an invalid condition that you cannot set using logic. I get it probably works when you try to enter text into a numeric (i.e. bog standard stuff) but that is very limited.