Jump to content

Search the Community

Showing results for tags 'self-join table'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • 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


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 1 result

  1. Using a self-joining table to enter part numbers and quantity required to view description, pricing, discount structure etc. When entering a part number that doesn't correspond with any part number on the stock list (part number and quantity table self-joining to stock list) it will obviously not show any other detail as there is no data to match, but I would like to set a default value for the description field when no match is found to display 'Invalid Part Number'. I've had some ideas on how to get it done but keep getting stuck as I also want to display this in the Table View with HTML. Only way I've managed to get near to what I want was to add a cascading autocomplete text field, but I can't hide this field from the table view where the part number and quantities are entered. I can't think anymore, surely there is an easier way. I don't know enough of JavaScript, but thought that could be an answer to use an HTML block with javascript to display what I need. Any suggestions?
  • Create New...