Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Posts posted by Mathilda

  1. 11 hours ago, tconnery said:

    I've created a few formulas and now require a field that uses some of the existing formula values in a calculation.

    Is there a way I can create a new formula similar to the following:


    [@field:Formula1] / [@field:Formula2]

    Reference: http://howto.caspio.com/tables-and-views/data-types/formula-fields/

    "Other Formula Fields Not Compatible"


    Hoping for a way around this....


    Yes, there is a workaround. You can perform this calculation in a calculated field on a report datapage

  2. 13 hours ago, mr21xm said:

    when I added the html and logged in this appears and it doesn't take me to the personal.html although I added the personal.html page on my website but it doesn't take me there.ddd.thumb.PNG.fa3d7037c0cd5cf5ba39035f8f3d503f.PNG

    It seems that you didn't hit the "Source" tab before inserting code. You can find more info here

  3. 20 hours ago, Brasovan said:

    I would appreciate any help you can provide on the following:

    I this java script on an input form where the parameter [@SU_Type] is passed into the page through a link.  THIS SCRIPT WORKS perfectly:

    <h5><span id="business2" style="color:#263C87;">Company Information:</span></h5>

    if(TypeC == 1) {document.getElementById("business2").style.display = "none"}



    I'm trying to do something very similar on the email/destinations page of another form and it is NOT working.  In this form the parameters [@Mailing_Addr_Type] and [@Mailing_Check] are being used in the form and should then be passed, which I am assuming makes them available for use on the Destinations page.  However, no matter how I format them in the Jave on the Destinations page of the form the Java does not seem to read the values.  I have tested the java itself on other sites and it works if a Value is assigned to md directly.  What am I missing?  This is my latest iteration, treating the variables as values on the same form as the Java.  It does not work.  I have tried the following parameter formats:

    [@field:Mailing_Addr_Type] (with and without the # at the end)


    Thanks for taking the time to look at this.

    CODE THAT IS NOT WORKING (with fake link info):

    <h4>Your submission was successful.</h4>

    <p id="answ3">If you wish to enter additional addresses:</p>

    <p id="answ2">It appears that the address you entered was not a mailing address (or was not marked as one). Please click the link below and enter a mailing address that can be used in the letter of authorization document. This is required by the utility, not us. Thank you.</p>
    <button onclick="location.href='https://www.GOOGLE.COM/'" type="button">Add another address</button>

    <p><span id="answ1">Or, if you are done entering addresses: </span></p>
    <span id="answ4"><button onclick="location.href='https://www.GOOGLE.COM/'" type="button">Proceed to the Letter of Agreement</button></span><br />
    <br />


    if(md==0) { document.getElementById("answ1").style.display="none";
    else { document.getElementById("answ2").style.display="none"; 



    What datatype those fields have? I have a few ideas, which I hope will be helpful.

    - Your variables A, A and MD are not defined (the syntax var= is missing).

    - "Insert record" syntax will not work since there is no form on the "show message" page, you can refer to fields using parameter picker, like var a = '[@Mailing_Addr_Type]';

    - try using style.visibility.hidden instead of display none.

    I have a simple example of the similar workflow.

    <p id="first">[@field:First_name]</p>
    <p id="second">[@field:Last_name]</p>
    var x = '[@field:Last_name]';
    var y= '[@field:First_name]';

    Hope that helps

  4. 10 hours ago, quanghieuci said:

    Hi all !


    Does anyone has a solution for this? 


    I need to hide some text on the details page, when AuthField' value is not equal value from the Field#2. 



     am looking for a way to disable a radio button. If I select one I can only switch to another one. I want to be able to leave all radio buttons blank. Is there any way to do that?


    Thank you all

    Hi, you an may rules  for your workflow. 

    1. Criteria will be like that: when auth parameter is not equal to field#2 Action: hide a section with text (you need to place html block with text in a separate secion)

    2. For example you have 4 radio buttons. Since we can use field in action section only once you need to define all the cases when a specific field should be disabled.

    - rule 1: criteria -  when field1 is blank OR field3 is blank OR field4 is blank. Action: make field2 disabled

    - rule 2: criteria -  when field1 is blank  OR field2 is blank OR field4 is blank. Action: make field3 disabled

    - rule 3: criteria -  when field1 is blank, OR field2 is blank OR field3 is blank. Action: make field4 disabled


  5. On 7/21/2017 at 10:50 PM, Student2017 said:

    I have a table of Universities and Courses linked together and I use this as a datasource for the University dropdown. Next, I made the Course field a Cascading Autocomplete based on the same table where the cascade is filtered by University Name and Autcomplete is filtered by Course Name.

    The problem I have is that the form still accepts any random value the user enters in the Course field.

    Is there a javascript code which I could use or something similar that displays an error if the user enters a Course that is not linked to the University he/she has chosen.

    I could but do not want to use a dropdown because there will be 100+ values

    You may create a relationship between tables and enable referential integrity. In this case, user will not be able to submit a value into the related table which doesn't exists in the parent table. You can find more info here

  6. 16 minutes ago, gbecker said:

    I have a DB that receives data from a zapier that feeds in Stripe payment data. I want to match the payment data to the customer data that is another table. If I was using sql I would select the new entry in the Stripe data table and find the match in the customer table and then read the data from table i and then modify the data in table 2. Is is possible to automate this in Caspio or do I need to develop something in zapier to do this?

    Have you tried creating a view? You can join two tables and allow editing data from the 2nd table.

    Hope that helps :) 

  7. 1 hour ago, mr21xm said:

    I did the same as the tutorial of the registration form but when I came to copy the html for the login screen html and paste it on weebly website builder and nothing showed on the page and it lags and never opens. This a picture of the html that I got.


    I have a few ideas:

    - your credentials are already cached in your browser - try opening in another browser

    - you specified incorrect designated entry page. You can find this setting in the time out and redirection section under  Advanced setting in  your authentication. You can read more here

  8. 46 minutes ago, humidor said:

    If I have fields setup to calculate based on a formula, is there a way to allow the field value to be overridden by a user? For example I may have a field where a default date is calculated by formula based on a submitted date. But I would like to allow users to be able to change that date if needed.

    Formula field cannot be edited because value is calculated using other fields. However you may use the following workaround.

    Add a separate field where customer will be able to enter preferable date and update your formula with additional condition, like 

    WHEN Len([@field:customer_date])>0
    THEN [@field:customer_date]
    ELSE write your formula

    Insert your current formula instead of "write your formula"

    Cheers :)

  9. 1 hour ago, Student2017 said:

    I have a dropdown where a student can select a University from a list of Universities.

    Based on the user's University selection he/she enters the Course name (Cascading Autocomplete) and suggestions are made.

    My question is how can I make sure that the user chooses a right suggestion and does not enter an incorrect value in the Course field? (Example: User types Nuclear Physics when that is not a Course option for his/her selected University)

    I would recommend using lookup table as  a datasource for form element, in this case, user will  be able to select only existing value from the list of available options.

  10. On 7/15/2017 at 4:01 PM, MusoChris said:

    Hello everyone,

    I have tried to use the Lokesh Dhakar version in the caspio 'how to' section http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-a-lightbox-view-for-images/ but it won't work.

    The image displays but when you click on it it goes to a new page, sizing remains the same and the image appears in the top middle of the screen with a white background. To be blunt, it looks ridiculous and on a functional basis is useless.

    I'm not sure whether it's outdated coding on the 'how to page' or whether it is a compatibility issue with Weebly, the later seems a bit odd.


    Anyone got this to work in Weebly and if so was there any troubleshooting you can guide me on?

    If not, does anyone have an alternative workable lightbox solution for caspio into a Weebly site?


    Any help would be greatly appreciated,







    Hi Chris,

    Do you pass parameters to/from the datapage? If no, I would deploy the datapage in iframe


  11. On 7/12/2017 at 3:22 PM, Mccrossen said:

    I am new to Caspio and need help. I created a data page that allows user to search a (or more than one) source. The results page lists the source(s) and for each their term number. User wants to select term numbers and pass those term numbers directly into second data page which I set up to search by term number. The solution I am being told is to use Java to creates a multiply select in data page 1 results page and pass selection to data page 2. 

    If anyone can help me, I would greatly appreciate your help.

    Hi, I found this post with the similar question. Hope that helps

  12. On 7/12/2017 at 7:53 AM, humidor said:

    I would like to have a form where a user submits a start date and a priority for a given customer. Based on what the user selects for the priority I want the table to generate a schedule (for customer service followups) from the given start date. For example a customer MARY and HIGH priority might generate followups 1 day, 5 days and 30 days after the start date. Alternately a customer JOHN with LOW priority might only generate followups 30 days, 60 days and 90 days after the start date. How best to set this up? I can see how to use formulae to create the folowup dates but how to vary the intervals based on priority setting?

    Hi, I would use CASE statement in formula field. Add 3 formula fields: 1st followup, 2nd followup, 3rd followup

    E.g. for the 1st followup date:

    WHEN [@field:priority]='HIGH' THEN  DATEADD (dd , 1 , [@field:date_submitted]) 
    WHEN  [@field:priority]='LOW' THEN  DATEADD (dd , 30 , [@field:date_submitted]) 

    You just need to change number in the Dateadd formula for two other followup fields. You can read more here and here


  13. 17 hours ago, yakisoba said:

    Hi Guys,


    Is it possible in Caspio to display my last 5 performances and compare it to my average? e.g. a chart showing the points I scored in the last 5 basketball games comparing it to my season average. Is this possible?


    Thank you!

    Hi, Yes, it's possible. You need to use combined chart and report datapage.

    Sort fields by performance field and return only 5 records, add a calculated field and use the sql query like:

    select avg(point_performance) from table name where user_id=target.[@field:user_id]

    The calculated field should return the average value.

    After that select combination charts and add two values there:

    value1 - columns - chart type use performance field 

    value2 - line - chart type - use calculated field 

    If you need to hide report and display only chart, you may use solution described here

    Hope that helps!


  14. 18 hours ago, rwoolf said:

    Is there a way to take the first letter from a FIRST_NAME field and combine it with the LAST_NAME field to create a new USER_NAME field?  If so, how? I have been searching for instructions on how to do this and cannot find anything. Any suggestions?


    it can be done using sql substing query in the formula field: SUBSTRING ([@field:First_name] ,1 , 1)  + SUBSTRING ([@field:Last_name] ,1, 1)

    However, in case of further using username field in authentication, this is not the best option since you can using only unique field as a username.

    Therefore, you may insert the following script in the footer of your submission form.

    <SCRIPT LANGUAGE="JavaScript">
    function concatenate()
    var position1 = document.getElementById("InsertRecordFirst_name").value;
    var position2 = document.getElementById("InsertRecordLast_name").value;
    document.getElementById("InsertRecordUsername").value = position1.substring(0, 1) + position2.substring(0, 1);


  15. On 6/27/2017 at 0:23 PM, CodeRedLLC said:

    I need to pass a date field parameter through a query string, but I have to provide the date in the format YYYY-MM-DD.  I know how to display a date in that way, but when I pass it it always passes as MM-DD-YYYY format.

    I would recommend checking that you have correct format for data/time input on the Localization of the receiving datapage

  16. On 6/2/2017 at 9:37 AM, roattw said:

    I might be over thinking this, as usual.  I would like to create a dashboard page where the user can click a button and run a static commonly requested report,  This page would contain 10 or so of the most commonly requested on reports.  People would just visit the page, click a report icon, be shown the results, and be done - without having to search, sort, or use other results page functions.

    Is this a built in option, or is really just a graphic button hyperlinked to a webpage that contains the embedded Caspio report datapage code?  Is there a better cooler way?  ;^)

    You may consider creating tabbed navigation interface. Please have a look at this article

  17. On 6/26/2017 at 0:07 PM, bbeshlian said:


    I have a Datapage where records are grouped by manager then subtotals are displayed for the Total Employee Evaluations, Completed Employee Evaluations and Remaining Employee Evaluations for each manager. When I preview the Datapage the subtotals are correct. However, when I export the Datapage the subtotals are not correct. For example, I have a manager who has 33 employee evaluations to complete, 15 are completed and 18 are remaining. When I export to Excel and lookup this manager I see 33 evaluations, 33 completed, 0 remaining. 



    Hello Bill, I would recommend checking settings for download data. Make sure that you selected all matching fields from results page.

    Hope that helps

  18. On 6/19/2017 at 10:39 PM, MyNameIsSean said:


    I have a datapage that has another datapage embedded, within a single column layout.

    However I want to instead, embed it on the side, such that I can see both datapages side by side.

    Is this possible to do without adding another datapage?

    Also, i have multiple sections within the parent datapage so I cannot use a 2 column section to resolve this, unless I can add a section into another section (as a subsection).

    Thanks in advance.

    You may try deploying data pages in table layout on  your hosting webpage. E.g.:

    <td valign="top">
       	deploy code of the first datapage
    <td valign="top">
    deploy code of the second datapage


  19. On 6/25/2017 at 2:43 PM, Heineperson said:


    I would like to use HTML blocks to organize my fields on a list report embedded in a Wordpress site:


    I would like to reduce the space between the HTML blocks and the data fields (see the words "nomenclature" and "Conservation Status" in top section under "Plant Profile"). I have tried to create a custom Caspio Style with altered the padding and margins, but I am unsure exactly what layout parameters I should be changing, and I also wonder if my wordpress theme might overwrite these changes.

    Any advice you have for a novice would be greatly appreciated.


    As far as I understand, you need to reduce space between the submit button and header of the record try using     padding: 0px 12px; instead of padding: 10px 12px; for the  .cbResultSetPanelDataContainer class


  • Create New...