Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Posts posted by Barbara

  1. Hello,


    You can try using javascript for that matter.


    I am using a "Buy this item" button to connect my report with details page. If you have something similar you can add an HTML block to your report and use javascript. In your case it would be something like that:


    <script type="text/javascript">
    var cb_boolean = '[@calcfield:1]';
    if (cb_boolean != '0') 
    document.write("<input type='button' value='Details' Name='mybutton' onclick='myfunction()'> ");
    document.write("<input type='button' value='Home Page' Name='mybutton' disabled=true>"); 
    function myfunction()
    Replace url&paramToDetailspage with your url to Details page.
  2. An idea came to my mind which is worth to try:


    Disable the field label in the advanced tab

    Insert an HTML block before the field and enable "next element on the same line" in the advanced tab. This way the content of the HTML block appears before the field on the same line.

    Put the custom label in the HTML block like: Select [@InsertRecordFIELDNAME] submission

    Replace FIELDNAME with your submission type field name.

    Format the text the way you want it to display using HTML and Style tags.


    I think it should work but I haven't tried it myself!

  3. It seems like a one to many relational database where one creative can have many reimbursements and you need to stamp the reimbursement with the creative id in the reimbursement table as the foreign key.


    You can either achieve this by choosing the value of your dropdown as the ID field (there are Display and Value options in each dropdown that can be set separately for example Display to show the name of the creative and Value to store the id of the creative in the table).


    Another totally different approach is what is explained in this video: http://howto.caspio.com/getting-started/create-a-one-to-many-relationship/




  4. Hi, does your Caspio Bridge account include WS API feature? If you're not sure, contact your account admin to verify this. If you know your Caspio Bridge account has this feature then verify the web service profile information that you've created inside Caspio Bridge. This information should be provided in the codes accurately.

  5. 1. In your authenticated HTML DataPage write a script to define variables and values as you already did. For example:

    var type_admin = '[@authfield:admin]';
    var type_manager = '[@authfield:manager';
    var type_user = '[@authfield:user]';

    2. Embed the HTML DP in every protected web page and hide it. Example:

    <div id="htmldp" style="display:none">
    Deploy code of HTML DP…

    3. In your HTML web pages where you have the hidden HTML DataPage, write a JavaScript to show/hide content:

    if (type_admin =='yes') {
    //show or hide your content
    document.getElementById('YourContentID').style.display = 'none';
    document.getElementById('YourContentID').style.display = 'block';
    else if (type_manager='yes'){
  6. See an example of creating a View to join tables at http://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/. When you create a View you will join the tables on the related field (unique id of the parent table and the related field usually called foreign key in your child/related table). In your View you will choose any field you need to display in the Report. View only allows one of the tables to be editable so you need to choose which table you want to be editable in the View settings. Then you will create a Report based on the View where you can set the editable fields and display-only fields in the details page.


    On another note, creating a relationship will facilitate creating a View and also allow you to enforce referential integrity of your data. You can get more information about this at http://howto.caspio.com/tables-and-views/relationships/.


    Hope this information helps.




  7. You can also use the older version of Google which does not have geocoding limitation. This option is the quickest way to get your map up and running as you only need to take three steps to update the following items referring to the instruction at http://howto.caspio.com/extensions/maps/map-mashup-instructions/map-mashup-older-version.html:


    In the instruction 1.3, change map type “Y†for Yahoo to “G†for Google.

    In the instruction 1.4, change map type “Y†for Yahoo to “G†for Google (optional only if you have a Details Page).

    In the instruction 2.2, change Yahoo deploy code with Google deploy code (replace “YourKeyHere†with your API Key registered for your domain).

  8. You can create a Report DataPage. Caspio has different Report formats including Tabular, List, and Gallery. See instruction at http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/. Then if you need to export the report in PDF, you can request Caspio PS for a custom development. See info at http://www.caspio.com/extend/platform-extensions/pdf-reports.aspx




  9. Hi, as for the first one there is a techtip at http://howto.caspio.com/customization/limit-the-number-of-maximum-submissions.html which may help you with what you're trying to achieve.


    For the second one your logic is correct but you need to define a variable and assign today's value then use that in your comparison. You can capture today's value by using [@cbTimestamp]


    In either case JavaScript method is not a bullet proof way of limiting submissions. Because JavaScript can easily be manipulated by a technical user as it runs on the browser side. A recommended method is to write a server side program to achieve this. This can be done by Caspio PS team. If you are interested to get a quote you can submit the requirements at http://www.caspio.com/support/professional-services.aspx.




  10. It should work the same on an Update form since the submit button is the same in Submission and Update forms. Use Firebug to inspect the code while opening the page in Firefox browser then look for the submit button and also see if you get an error when script runs.


    One reason could be multi-form deployment on your webpage so the script is confused which "caspioform" it's referring to.


    Good luck!


  • Create New...