Jump to content

Search the Community

Showing results for tags 'zipcode'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 2 results

  1. 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 alphanumeric sense because they both begin with 9. Does anyone know of a way to make triggered actions work with this. I don't see a way in triggered actions to cast the zipcodes as numerical values for the comparison either. I have included a screenshot of the triggered action I am setting up. Hopefully it helps you see what I am doing wrong lol.
  2. 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.....
×
×
  • Create New...