Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Posts posted by Mathilda

  1. 54 minutes ago, Paul2vey said:

    Hi Mathilda,

    I'm new to Caspio and your solution to coloured fonts for a column is just what I want.  I am not a techie and copied and pasted your solution into HTML Block, inserted field names, pressed <>Source and the preview shows a new column but with the code for each row.  What am I doing wrong please

    Hi, You need to hit source tab before inserting code. You may also disable html editor.

    Hope it helps

  2. Hi everyone,

    I just want to share this solution. If you need to define color for the whole column, you may use the following script in an HTML block:

    <div id="mydiv[@field:id]"> </div>
    <SCRIPT LANGUAGE="JavaScript">
    document.getElementById("mydiv[@field:id]").innerHTML ="<span style='color:blue;'> [@field:FieldName]</span>";

    replace [@field:id] with unique field and [@field:FieldName] with name of your field


  3. On 2/3/2017 at 9:08 PM, Nehme said:

    Thanks a lot for your help.

    If fact, I have set the time to 2 hours. So this would not be the problem.

    I tried also to set the Enable cross app login, but it doesn't work.


    After a successful login, if they press on search (the only button there), they are redirected to the login page again!

    And only on iPhone.

    This is really frustrating.


    Thank you again for your help. Do you have another suggestion?

    It's hard to suggest something else without checking. I can check the datapage, you may send me an URL and credentials in personal message.  

  4. 11 hours ago, TarDy929 said:

    I have a simple data base. It has 7 fields. I have not found a method of sorting the fields. I have looked at this  link... http://howto.caspio.com/datapages/reports/interactive-reporting-options/  . It looks very easy, except I have not been able to get to the page that is illustrated  as the first example of sorting.

    Do I need to deploy this data base to a web site or E-mail it to myself before being able to sort the data base?

    Sorting on a datapage available even on a preview. You need to select "by a drop-down" radio button, then include needed fields and preview the datapage or use URL deployment method to check the datapage. 

  5. On 1/27/2017 at 4:10 AM, JohnJ said:

    Just getting started with Caspio and am stumped. I have 2 DataPages that I am using on the same webpage that creates a 'Game'. A Game consists of a team, players and various statistics. One of the forms allows the user to create a new game and select a team from a dropdown that is populated from a view consisting of player names with various info like the team they are on and their player number. The second DataPage is were the stats get entered. On there is a drop down to display player numbers. I use the player number to link the stats to the player.

    What I need it to do is update the player number dropdown with all the numbers that are linked to the team that is selected in other DataPage. Hopefully that makes sense.



    You need to pass Team ID from the first datapage to the second one. On the second datapage create a virtual field and receive parameter. Then you may use that virtual field as a parent field for the player field. You may find more info here and here

  6. 11 hours ago, Pulford said:

    Does anyone have a solution for displaying a dynamic image on a submission page? My customers can choose an image using the file selector to pick an image in my caspio datapage. I would like a thumbnail to appear when they pick an image from the dropdown, and then change if they make a different selection. 




    Hi Mark,

    You may try using solution from this post.

    Hope that helps

  7. On 1/31/2017 at 5:56 AM, EDG28 said:

    Hi All,


    i am working with a project where in i need to display it in a monthly calendar view but i can edit it each day to update the records is this possible? I know other options like i can include details page but i want it to be editable on the first page without clicking the details page.


    Records are not editable on the calendar. If you don't want to edit record on details page, you may deploy details datapage or update form in a popup window.

    Hope that helps

  8. 14 hours ago, JohnJ said:

    I am trying to setup a cascading dropdown that has a parent on a previously accessed datapage.

    So 2 datapages (A & B ).....When A is completed it goes to B. A has a dropdown that selects a team name (based on a view) . B has a dropdown that should list player numbers that are on the team selected in the dropdown on datapage A.   

    This works just fine if I have both dropdowns on the same datapage, but I need it to work over 2 datapages. Is there a way to set a Cascading element's parent to something from a different datapage? Perhaps by a parameter? 


    Sure it's possible.you need to pass a parameter from the datapage A to a virtual field on a datapage B. Then use the virtual field as a parent field on the datapage B. You may pass parameter in query string or on exit from the datapage.

  9. On 12/30/2016 at 5:45 PM, bensminger said:

    I have a field called LockStatus that I do not display on the form (it gets checked somewhere else).  If it is checked then I want to hide the update button.  This is the code I'm using, however the update button refuses to hide.


    if (document.getElementById("EditRecordLockStatus").checked){

     Am I doing something wrong?


    I tried your code, it works on my datapage. Make sure that the LockStatus field is editable. If you don't need to display the field, you may hide a field using html blocks

  10. On 1/30/2017 at 8:37 PM, Nehme said:


    I am having a problem for users trying to log-in using iPhone (and sometimes Mac).
    After logging in to their account, they must perform a search.
    When they click "Search", they are redirected to the log-in page again.

    This doesn't happens at all on windows

    Any help?

    Thank you


    I would recommend checking that you the "Enable cross app login" setting is enabled for your authentications.

    This setting can be found in the Advance settings tab in the authentication.

    Another idea - perhaps, you specified too short period in the setting, which controls time range when user is logged. Maybe they got redirected to the login screen in 15 minutes? You can find this setting in the Advance settings tab as well.

    Hope it helps.

  11. Hi Aurora,

    You may try using the following code in the footer of your details page. I wrapped text in a div with ID "Text"

    <div id="text">Custom text</div>
    <SCRIPT LANGUAGE="JavaScript">
    function hide()
    var x = '[@authfield:FIELNAME]';
    var y = document.getElementById("EditRecordFIELDNAME#2").value;
    if (x!=y){

    Insert your authentication parameter instead of '[@authfield:FIELDNAME]'

    also use your field name instead of "FIELDNAME#2"


  12. 23 hours ago, ronbrumbarger said:

    Hello.  I have a large application comprised of several Caspio applications.  I'd rather not maintain the application parameters found in Caspio application A and Caspio application B, C, D, etc...  I'd rather maintain the application parameters values in once place.  Any way in Caspio to do this?

    Hello, as far as I know, this is not possible. App parameters can't be shared between applications. Perhaps, you may combine two applications in one?

  13. 20 hours ago, Cherif said:

    Hello everybody,


    A simple question which is haunting me for a couple of days now.


    I have a table MEMBERS (where all my members are listed with different info. Most importantly there is one field: MemberUntil (Date Time Value)


    How is it possible for me to NOT allow a member to log in if the date is greater than the date under the field: MemberUntil?



    I have tried on VIEWS but the whole logic doesn't work. AND >> Members_MemberUntil >> Greater >> (then I have to manually input a date).


    I would like to be able to say: IF MemberUntil is greater than the date stated in the field MemberUntil, then this specific member will not be able to use his login details.



    Thank you so much for your time and consideration



    Hi Cherif,

    Sure, it's possible. You need to specify 2 criteria in the view. I attached a screenshot.

    Hope that helps!


  14. On 1/30/2017 at 8:42 PM, Kennylj24 said:

    Is there a way to create a report to see what times a user logs in?

    There is a feature called user logs, which allows to see this info. You may check here if your plan has this feature. Another option, you may create a separate table for history of logs and then create a submission form and receive user's ID and other datapa from authentication fields, then add auto-submit script. After that, you may specify in authentication to redirect user to that datapage and then after form is submitted, redirect user to the user's dashboard.

    It may sound a little bit complex, however it's easy to do.

    Please feel free to ask if something is not clear enough. 

  15. 19 hours ago, keneastman5 said:

    I'm sure I'm missing something obvious but...I have a dropdown field that has about 10 values in it and it automatically defaults to the top value.  I want the user to have to select something from the list and not just accept the default value.  So, I made the field "Required" and inserted a default value of "Please Select".  So when the form is displayed, that value shows and there's a red asterisk showing that the field is required, but the user never has to select anything in that field because the app is accepting the default value. 

    How do I make the user have to inspect that field and select a legitimate value?

    You need to remove "Please select" in the "Value" field. You may find more details here

  16. On 1/25/2017 at 10:08 AM, Pulford said:

    Good Morning,


    Can anyone help me out. I'm trying to combine fields and then auto submit. It works fine until I add in the auto submit code in the footer. It'll auto submit fine, but no longer combines the fields 



    <SCRIPT LANGUAGE="JavaScript">

    function concatenate()
    var teammembers = document.getElementById("EditRecordteammembers").value;
    var lastadd= document.getElementById("EditRecordlastadd").value;

    var teammembers = teammembers + " (" + lastadd + ")";

    document.getElementById("EditRecordteammembers").value = teammembers;



    if(document.getElementById("caspioform")) {   document.getElementById("caspioform").style.display = 'none';   setTimeout('document.forms["caspioform"].submit()',1500); }  </script>


    I modified script a little bit, now it calls function, which concatenates and submits the form:

    <SCRIPT LANGUAGE="JavaScript">
    function concatenate()
    var teammembers = document.getElementById("EditRecordteammembers").value;
    var lastadd= document.getElementById("EditRecordlastadd").value;
    var teammembers = teammembers + " (" + lastadd + ")";
    document.getElementById("EditRecordteammembers").value = teammembers;
     if(document.getElementById("caspioform")) {
      document.getElementById("caspioform").style.display = 'none';
      setTimeout(concatenate,1000); } 


  17. 16 hours ago, hcdcspider said:

    How to set an APP PARAMETER inside a Java Scrip block.


    I have defined an APP PARAMETER on the OVERVIEW on my APP and now I would like to set the value wishing a data page on an html block inside a JS


    Help Please!

    It seems that you need to get value of application parameter using java script. You can refer to the app parameter using parameter picker.

    For example:

    var x='[@app:email]';

    In the example above I take value of the app parameter, named email.

  18. On 1/8/2017 at 4:50 AM, TMeyer said:

    I have a chart that is filtered by a submission page passing virtual parameters. Depending on the parameters, the 'count' may be zero for a certain value. Is there a way to display a count of zero on a bar chart (or any type of chart for that matter)? 


    When the chart automatically adjust to the number of bars displayed it messes up their width, size and color scheme. I want the colors representing the people to stay the same, not change just because a person who is usually represented in the middle of the bar chart has a count of zero for that chart.



    dashboard1 partial.png

    dasboard1 full.png

    I would recommend selecting the  same field with is used for "Value" for the "default sort order" setting. This setting can be found on the last screen of the chart wizard. Please note, you need to select a field with aggregation, e.g. Count(field_name)

  19. On 1/19/2017 at 7:29 PM, UltraSrc said:

    The code below works fine when someone changes the default value from No to Yes in my 'DispoToday' field. My challenge is when the record already has a value of Yes and someone updates another field then the script will update the date again. I only want the date to write out the first time someone changes the 'DispoToday' from No to Yes.

    <script type= "text/javascript">
    function getT() {
      if(document.getElementById("EditRecordDispoToday").value == 'Yes') {
        document.getElementById("EditRecordTimeofView").value = '[@cb:Timestamp]';

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


    Try changing the last line of code. Use:

    document.getElementById("EditRecordDispoToday").onchange = getT;

    instead of:

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

    Another option is to create a rule. The rule will be: when DispoToday field equal to Yes - make TimeofView field display only

    Hope that helps :)


  20. 16 hours ago, BugDebug said:

    Most of my input forms includes a small report in a iframe where the last 10 entries are shown. After the platform upgrade, the subreports (iframes) no longer show up. Nothing is changed on the pages for years. It seems to be related to the browsers now considering the script as unsafe and hence not executing it. The frame can be made visible, accepting a browser security warning, shown in the URL input bar (Chrome).

    This is the code in use, can anyone assist with getting it working again, it's inserted in the footer of the page:

    <iframe allowtransparency=true frameborder=0 id=rf sandbox="allow-same-origin allow-forms allow-scripts" scrolling=auto src="http://b6.caspio.com/dp.asp?AppKey=[The appkey is here]" style="width:100%;height:100%"></iframe>

    Thanks in advance.


    Try using https protocol instead of http in the URL of the datapage: 


    It should fix the issue. 

  21. Just now, Mylene said:

    Hi Everyone,

    I'm looking for a way to combine calculation and auto-submit script. I need to increment value in one field (integer datatype) and auto-submit update form.

    Thanks in advance!

    Hi Mylene,

    try using my script. You need to insert script in an html block and put that block below the fields on a form.

    <script type="text/javascript">
    document.getElementById("EditRecordField_name").value = y;
     if(document.getElementById("caspioform")) {
      document.getElementById("caspioform").style.display = 'none';
      setTimeout('document.forms["caspioform"].submit()',1000); } 

    Add your field name instead of Field_name in the script.


  22. On 1/9/2017 at 6:59 PM, secny1 said:

    Up until recently I could upload excel spreadsheets that I have created with formulas and import them and update them as need be.

    I would format the cells to currency or number etc.

    All of a sudden the formatting isnt staying when I upload if I have formatted a cell as number with 2 decimal places (ie 324.85). 

    Once uploaded the number when imported may change to 324.8536

    I can find no place in Caspio for an answer to this,or anyway to format to TWO (2) decimal places in the table view, and I have been doing this for 3 years without an issue. I need 2 decimal places only.

    Why does it seem like the importing is ignoring my formatting now, and using the formula calculation.

    I have over 8500 entries in 4 or 5 spreadsheets and had to manually change them all in the table view window!

    I dont want to that that every week!


    Thank you

    You may apply custom formatting on a datapage and show only 2 decimal places. 

  • Create New...