Caspio

Introduction

Caspio is a no-code platform designed to help businesses quickly build and deploy custom web applications without writing code.

  • Although it specializes in database-driven application development, organizations requiring highly advanced features or extensive customization may find its capabilities limited.




Plans

However, Caspio’s existing Free Plan - which offers unlimited users and app usage with up to 50,000 data records - will end on October 1, 2025. It will be replaced by a $100/month Lite Plan.

Caspio Plans

Users can still trial a fully-featured account for 14 days, but all data will be deleted after the trial period unless the account is upgraded.



Keyword Searching Across Multiple Fields

To enable keyword searching across multiple fields, you need to create two DataPages; a Submission Form and a Report.

  • The values from the first form will be passed to the second using virtual fields.

Submission Form

Caspio Submission Form

  • In the Select Fields page, move any available fields into the selected field section.
Caspio Select Fields
  • In the Configure Fields page, insert a virtual field for the keyword search and delete the previously selected field.
Caspio Insert Virtual Field
  • Customize the virtual field's Label in the General Options tab and enable "pass field value as parameter" in the Advanced tab (e.g. [@Virtual1].
Caspio Modify Virtual Field
  • In the Destination and Messaging page, you can either choose
    • Go to a new page - where the page url contains the Report DataPage
    • Go to a DataPage - select the Report DataPage

Caspio Set Destination Page

Reports

Caspio Reports
  • Change the Search Type to Filter data based on your pre-defined criteria.
Caspio Set Search To Filter Based on Criteria

  • Select the fields that need to be filtered against the keyword.

Caspio Filtering Fields

  • In the Configure Filtering Fields, set the DataPage Elements' comparison to "Contains" and set the receiving parameter (e.g. [@Virtual1]). Also, change the logical operator between keyword search fields from "And" to "Or" in the Logic tab.

Caspio Configuring Filtering Field

  • Customise the results page as desired.
    • Consider enabling "Link to Search Form" for both the Results Page and Details Page.

DataPages Deployment

Make sure to deploy both the created DataPages to make them accessible.

Caspio DataPage Deployment



External Links

Comments

Post a Comment