Search the Community
Showing results for tags 'zipcode'.
Hello, I am trying to make a triggered action that inserts records that have certain zip codes into a different table. The zip codes are stored as the Text 255 data type. The records that I want to send to the new table are ones with the zipcodes 00001 - 29999; 32000 - 34999; 40000 to 71599; and 73000 - 99999. I have been trying to use "SELECT WHERE #inserted.zip is greater than/less than" to filter the data, but I am getting weird results. For example, a zip code of 90210 gets shot to the other table, but 99876 does not, even though they both should be "greater than" 73000 in an alphanum
Is there a way to grab the local zipcode from wherever someone is accessing the datapage and autofill it into the zip code field in a search form? An example is https://www.autotrader.com/ where they insert the zipcode into the zipcode search field, but still allow it to be changed. Thanks for all the help, new to Caspio.....