I cant seem to work out how to check that the first part of a postcode is in my “area”.
I have data type named “area” and a field “Postcode” which contains the postcodes i cover.
On sign up i want to check that the “Start of postcode” Input is in the list of my data Area/postcodes and if it is not then pop up appear stating “i dont cover that area etc”.
I have been trying to do it through Only When on the “sign the user up” workflow with no success.
It seems easy in my head, Check input against DB and continue or pause and popup if fails. I just cant seem to get it.
Thanks for your time in advance