Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by Mathilda

  1. On 12/16/2017 at 4:46 AM, Scott said:

    On a Submission form I would like a button to validate all fields and records and run my imbedded HTML in my footer, similar to the checking of fields when the submit button is executed.

    When this checking button is executed and successful a confirmation of all details appears and the final execution button appears with the data and a submit button can be executed and insert the record in the table.

    The reasoning for this is I have some front of sales people who may at time enter incorrect information and I want them to check their entries prior to a final submission execution to the table.



    What kind of validation do you need to do? In case of checking that entered number is between a specific range or checking that date is not in the past, this can be done before record is inserted, however if you need to check that value is unique in the datapage, this can be done only when record is inserted. You may also conciser creating a two step registration - create a submission form with only main fields which control uniqueness  and  then entering other info on update form. 

    You may find more details here and here

    Hope that helps.

  2. On 12/15/2017 at 10:53 PM, pbullock said:

    I am trying to deploy on iframe on my website.  Iframe is the only deployment method available for me (for technical reasons).

    This is my deployment code:

    <iframe name="Add an Asset" title="Add an Asset" src="https://c0abf873.caspio.com/dp/896060006294dfe2bf154556bccc" width=100% height="100vh">Sorry, but your browser does not support frames.</iframe>

    The iframe works fine in the width (at 100%), but the height only seems to grow about 50% of what it needs.  I see a vertical scrollbar that is unnecessary.I have also tried height=100% but this doesn't work at all.

    I also tried this in the Custom CSS with no better results:

    iframe {
        width: 100vw;
        height: 100vh;

    Is there something I am missing here?



    You may check this post. I posted script for the similar inquiry there

  3. On 12/12/2017 at 9:42 AM, Holger said:

    After the user updated the Submit Form, I simply want to redirect to a new page and at the same time close the existing window.  I updated the URL in Destination Option "Destination after record submit - Go to new page". After I submit the page, the new page loads, but only appears in the size as the original submission form. I just want to see the redirected page in full view mode after the user submitted the form. Appreciate the communities help.

    Try to redirect user to another URL and close the window on submit, You may try using the following code in the footer of the datapage:


    Don't forget to specify your URL instead of URL.


  4. On 7/29/2017 at 11:21 PM, AndreCouturier said:


    I would like to change the beginning of the week to Sunday (dimanche in french canada) instead of Monday (lundi). It does so in localization in English, but I need it in French also.

    I looked in the Define Localization Settings, but there is no setting for the beginning of the week for the calendar.

    Any Ideas?



    André Couturier

    Hi Andre,

    I would recommend checking that French (Canada) region is selected in your localization. Week starts from Sunday for this region.

    Hope that helps :)

  5. On 12/9/2017 at 2:13 AM, JeremyMenefee said:

    I need to create a formula that will calculate a date based off of how many business days a number field is. Basically I need to mimic the WorkDay formula in excel. Does anyone know of a way to accomplish this in Caspio?

    This is a link explaining the workday formula: https://www.extendoffice.com/documents/excel/3445-excel-add-days-to-date-excluding-weekends-and-holidays.html



    Hi, this solution requires creating a sql function, which is not possible in formula or calculated field.

    I usually post my requests which fall out of standard behavior here, you may post your idea there as well

  6. 10 hours ago, shaferam said:

    I have a webpage with both a submission form and a report. Upon submission of a form, I would like the report to  automatically refresh.  Does anyone have script to refresh the entire page upon submission of a form?


    Hi, you may try specifying an URL where both datapages are deployed on the Destination and triggers screen of the submission form (select go to a new webpage option)

    Also you may insert a record directly on a report using inline insert feature. You may find more details here

  7. On 12/2/2017 at 7:48 PM, rookie said:

    On my data page, my label and field are not lined up.   Please see the below.   I've played around with the padding under the layout section but I still cant figure it out. 

    Thanks! Happy Holidays.   




    What type of the datapage you use? If it's a details, you may need to check padding for the .cbFormLabelCell and .cbFormDataCell classes

  8. On 11/26/2017 at 8:05 PM, wv02CASPIO said:

    Hi all, I am a newbie

    Trying to import an access 2016 db file I always end in a loop :   clicking 'NEXT' after the message box saying that the file successfuly is uploaded, I get the same message box asking the name of the file to upload.

    many thanks for any advice





    Hi, what is the size of the file? The limit is 150 mb for importing. Also, as far as I know, you can import tables only, macros  cannot be imported.

  9. On 11/16/2017 at 1:19 AM, tyinawyn said:

    Hi there,

    I have created a form that records incidents.  each incident can have one or more physical intervention techniques used.

    We are required to graph on the total number of times these techniques are used across all incidents.

    Easy to do if only one technique, graphing and reporting works well, however I am struggling with the multiples.

    Good advice from caspio has led me to adding a formula field within table but I am a bit stuck.


    So lets say I have four columns, each with drop downs of the 12 techniques we use, I need to formula field to account for the multiples that are assigned to each record.


    I suppose I have two questions!

    Is the formula field the best solution and if so can someone give me a pointer in how to set up the formula?


    Thanks so much :-)


    Can you give an example how you store data? Do you store each technique in a separate row?

    If yes, you could try using sql count function in a calculated field on a report datapage (formula field doesn't support sub-queries) E.g:

    FROM table_name 
    WHERE ID = target.[@field:incidentID]

    You may find more details here  and here

  10. 19 hours ago, niteowl2 said:

    I'm trying to to modify my column width (and keep it recorded) when in grid edit.  When I change the column width outside of grid edit, the width stays after I exit the screen but not so when in grid edit mode.

    Is there a way to modify the column width (or get the text to wrap) when in grid edit mode?  

    Try using the following code in the header of the datapage:

    .cbGridCtnr > .HeadCtnr > .Table, .cbGridCtnr > .BodyCtnr > .Table, .cbResultSetNavigationTableCellspacing.cbResultSetNavigationTable
    width: 100% !important; 


  11. 21 hours ago, Messy said:

    Say I have 3 tables; Users, accounts, assets.


    A user is completely unique and has a one to many relationship with Accounts.

    Accounts has a one to many relationship with Assets.


    I want to create a form for adding new assets. The person needs to select which account the asset belongs to. Given multiple users, each with numerous accounts - simply having a full drop down list of all the possible accounts is not feasible.

    How do I create a form with a "user" dropdown where the "accounts" dropdown only shows values linked to the selected "user"? Thus filtering the possible accounts to just the ones belonging to a specific user?



    I have played with rules but cant seem to find a way.

    Hi Messy,

    You may use cascading elements, this will let you filter accounts, associated with a user. Please find more details here

  12. On 11/11/2017 at 10:42 AM, Youssik said:

    Hi Everyone,

    I'm new to Caspio and I'm trying to figure out how to set an automated email system, with a manually updated table every day.

    So, I have a table that contains 4 columns : Contact Name, Contact Email, Order ID, Item Name.

    The mail template will contain in it's body 3 of the parameters ( Contact Name, Order ID, Item Name ) and should be sent to the list of emails from the table. 

    Can anyone help me with this task ?

    Thank you in advance


    This should be possible with zapier (e.g.:connection with mailchimp) or you may utilize caspio notification email.

    You should update all the records to run an email on update. Add a test field and update a field using bulk edit feature on report

    Hope that helps.

  13. On 11/14/2017 at 8:33 PM, NeoInJS said:

    I have a couple data formatting issue I’m trying to figure out the best way to deal with. 

    The most important issue is date formatting for non-USA users (like in Australia, UK, etc). Their date format is dd/mm/yyyy while ours is mm/dd/yyyy. I have to have the Localization set to USA mm/dd/yyyy because most users are here. However, a big part of our market is Australia/UK so I need the date format to work for them too. 

      So I need to figure out how to override Localization formatting on occasion on the existing data pages, based on the value of an Authentication field (the ‘Country’ field).

    I would create two datapages with different localization and redirect user to the correct one, depending on the authentication parameters, like in this solution

  14. 11 minutes ago, Messy said:



    Just got the free trial to play with to see if this will do everything I need. I've been looking around and I cant see how to create a data field that's just a basic drop down selection.


    I have tried looking for options around List -String but I can only get this to allow multiple options from a list. I want to be able to select one and only one option from a dropdown list of options.


     Can anyone explain how to do this?



    Hello Messy

    Drop-down form element can be selected for a field on a datapage. You can find more details here

  15. On 11/16/2017 at 3:53 PM, Clint said:

    Is it possible to change the sort order of a Y Axis of a chart (combination, bar etc) where one could use a Title field for display, but use the Date field for sort order?



    As far as I know, only fields which are being used for Value and Category can be selected for the chart sort order.

    You could also try using chart and report type of the datapage and count needed values in calculated field, then use that field for Value and default sort order.

  16. On 11/17/2017 at 2:42 PM, DavidKennett said:

    Following on from the below post 

     I have the same issue where i have implemented the below script but it is still allowing me to select a date in the future from the date/time.


    function pastDateValidation()
        var d=document.getElementById("InsertRecordClient_AML_Date").value;
            if(new Date(d) > new Date())
            alert("Select a date which is before now");

    document.getElementById('InsertRecordClient_AML_Date').onchange = pastDateValidation;


    Hi, I tried this code, it works for me.

    I would recommend checking that:

    - you specified correct fieldname in the code;

    - code is inserted into the footer of the datapage and your datapage is a submission form;

    - there is no errors in browser's console (hit F12 and select Console tab)

  17. On 11/17/2017 at 1:31 PM, agvereniging said:

    In our application the streetname en housenumber are stored in one field called Street. For a download we have to separate streetname en number in two fields (street and number). How can I do that using a datapage?

    I would use calculated or formula field for this case. Is there a separator (e.g. comma) between street name and number?

  18. On 11/17/2017 at 3:08 PM, telepet said:

    The above code works wonderfully, and enables a little more flexibility when it comes to layout.  I wonder, is it possible to do hide the default "Search" button?  I'm attempting to incorporate a search page where there is a "Reset Search" button next to a "Search" button.

    You may hide a standard button using the following code in  the header of the search page:



  19. On 11/10/2017 at 9:01 PM, thompson said:

    I am trying to Hide the submit button when a virtual field that is a cascading text field (non-editable) equals "0". I've tried different variants of code found here but I still can't seem to get it to work. I am posting it in the footer. This is what I currently have.

    if (document.getElementById("cbParamVirtual2").==0){

    Since this is cascading field, try to get a field value by name, please find an example here

  • Create New...