Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by casyana

  1. I have a table where I am listing people associated with an event. When there are two people associated with the same event each name is entered into a separate field. Is there a way to create a data page to search if a certain person is listed in either of the fields?

    You may use the following steps to do this:

    1. Include two fields, that have people associated with the event in the Search Page (use OR logical operator between the search fields). Use text field form elements for both of them, later you need to hide them with help of HTML blocks.

    2. Add virtual field to the Search page. This field will be used for person name, that we want to search for.

    3. Add the following JavaScript in the Footer:

    function update_name()


    var name = document.getElementById('cbParamVirtual1').value;

    document.getElementById('Value1_1').value = name;

    document.getElementById('Value2_1').value = name;


    document.getElementById('caspioform').onsubmit = update_name;

    4. Open this DataPage in Firefox and check with help of firebug, that fields from the step 1 have correct ids: Value1_1 and Value1_2:

    Posted Image

    If ids are different, update script accordingly.

    5. Test that search performs correctly - you need to enter people name only into virtual field.

    6. Edit DataPage and hide fields from the step 1 with help of hidden table: http://howto.caspio.com/customization/h ... pages.html

    Hope this helps.

  2. You may read about report creating here: http://howto.caspio.com/datapages/creat ... -datapage/

    And about parameters here: http://howto.caspio.com/parameters/rece ... eters.html

    Looks like you need only equal criteria for your field.

    For your example: create predefined criteria, enable Bridge and external parameters, include Suppliers field to the Search. Select Receive parameters on Advanced tab, for instance, parameter name is [@suppliers]. Configure other DataPage options.

    Deploy the DataPage as Direct link

    Now to see only results for green apple suppliers you need pass parameter green apple. So URL will look like following:

    [DirectLinkDeployment]&suppliers=green apple

    To see results for orange suppliers:


    So, you may add links to your page and use these URL as link's source

    Green apple suppliers

  3. Hi Heather,

    You don't need to create 30 DataPages. All that you need is create one predefined criteria DataPage, allow Bridge and external parameters, include all fields into the search page, if you want use different comparison type for some fields, add new criteria to it (use AND logical operator between criteria), configure receiving parameters for all fields (for each criteria use unique parameter name), and select: If empty ignore criteria on the Advanced tab.

    Than you need to create correct URL for each search results you need, by passing and combining different parameters.

    Here is an example. You want two search:

    1) Name equal Jane, and Date - previous 10 days and

    2) Name starts from T and Date equal 12/10/2011.

    You need add two criteria to Name (first - equal, second - starts with) and Date (first previous X days and second - equal).

    Parameters options: for Name: first - [@n1], second [@n2] , Date: first - [@d1] and second - [@d2]

    So, you will need two links to the results page:

    1) [caspio direct URL link]&cbResetParam=1&n1=Jane&d1=10

    2) [caspio direct URL link]&cbResetParam=1&n2=T&d2=12/10/2011

    If you don't need some fields to be used in search, just do not pass any parameters.


  4. Hi Aukirk,

    It looks like GravityForms don't support any parameters and user may get submitted data only via the email. If it is so, it will not work with Caspio form.

    You may use HTML form on pages on your site (use method get and use web page with deployed Caspio form as action, parameters will be passed in URL). Caspio form has to receive parameters from the first form, make these fields hidden and configure receiving parameters options, configure remaining fields as you need. So it will be the same scenario as it was before: user may enter some information on the first page, and it will redirect to the second page with additional questions. But in this case, data will be submitted to the table only after Caspio form submission. So there will not be validation on the first page (unique fields and so on), and if incorrect information will be passed to the second page, form will not be submitted and user will see errors.


  5. Hi Lukesawyer,

    As I understand, you don't want to submit data to the first table, you only want to use data from the first table to select correct data for the second. Is it correct? if yes, you need to create one submission form (use the second table as data source). Use the first table as data source for dropdowns. If you don't need to submit data from parent dropdowns to the table, you may use virtual fields for them (I think you will need 4 virtual fields for your 4 dropdowns). Than you have to create cascading dropdown for all fields from the table 2 (table 1 is datasource, virtual field4 is parent field and filter by). And then you may hide fields using a table (http://howto.caspio.com/customization/h ... pages.html)

    Hope this helps.

  6. Hi Efpublishing,

    It is easy accomplish with Caspio. You need 2 tables: one for authentication with user names, emails, IDs, passwords, etc(http://howto.caspio.com/authentication/ ... ntication/); second for your questions, each field correspond to each question and one field for user identification (it may be unique email or user ID). And you need to create two DataPages:

    - Submission Form (for each question, configure radio buttons form element with possible answers. For authentication field, you may configure hidden field and receive information from the authentication table (for example, user ID) - in this case, the DataPage has to be authenticated, or just ask user to type her email address)

    - single record update (or Direct to Details) to show user her answers (use unique field in RLS).

    You may find information about record level security on how to site: http://howto.caspio.com/authentication/ ... -security/


  7. Does anyone have suggested tutorials for building a Quoting/Estimate page? In my case, the quote page will be for a printing company. The customer should be able to select the type of printing like Business Card. Then select paper type and quantity. After they get finished making the different selections then the price appears. Perhaps they could then place the order.

    I may propose you the following solution, but you need some java script here:

    Create table type_of_printing with two fields: type_name and price (number data type), type_name may contain price as well (like Business Card (0.5$)) and second table paper_type with two fields: paper_type and price (number data type). And table for order information, include all fields you need and type_price, paper_price, quantity, total_price. Create submission form, based on the order table. Use dropdown form element for type_price and paper_price, use tables you created as lookup source, field for display - type_name (paper_type), for value - price, use default value 1 for quantity. Add the following script to the header with function for price calculating:

    function calcsum()


    var total = (parseFloat( document.getElementById("InsertRecordtype_price").value ) + parseFloat( document.getElementById("InsertRecordpaper_price").value ))*(parseFloat(document.getElementById("InsertRecordquantity").value ));

    document.getElementById("InsertRecordtotal_price").value = total;

    document.getElementById("InsertRecordtotal_price").readOnly = true;


    Add HTML block below quantity field with button, that allows to calculate total price: . You may set options: continue next element on the same line and do not display label for total_price field.

    Add follwing script to the footer, that will calculate price by submit button:

    document.getElementById("caspioform").onsubmit = calcsum;

    And you may change you submit button name to "Place order" or whatever you need in localizations.

  • Create New...