Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Mathilda last won the day on May 25

Mathilda had the most liked content!


About Mathilda

  • Rank
    Advanced Member

Recent Profile Visitors

2,053 profile views
  1. Mathilda

    Two Step Submission

    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. Mathilda

    How to permanently delete files from my database?

    Hi, Go to All assets->Files select all the files using a checkbox in the left top corner and delete files using bulk actions. Hope that helps
  3. Mathilda

    Resizing an Iframe

    You may check this post. I posted script for the similar inquiry there
  4. 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: <script> document.getElementById("caspioform").onsubmit=function() { window.open("URL"); window.close(); } </script> Don't forget to specify your URL instead of URL. Cheers!
  5. Mathilda

    How to change start of weekday in calendar

    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
  6. Mathilda

    Adding Business Days to a Date Field

    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
  7. 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
  8. Mathilda

    Label and Field not aligned

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

    I Am Getting File Not Found

    Do you use login page with redirection? I would check the correctness of the URL. If you use relative path, try specifying the complete URL
  10. Mathilda

    failing to import *.accdb files

    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.
  11. Mathilda

    Column Width on Grid Edit

    You're welcome
  12. Mathilda

    Formula field to count text entries

    Hi, 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: SELECT COUNT(ID) FROM table_name WHERE ID = target.[@field:incidentID] You may find more details here and here
  13. Mathilda

    Parameters Reset

    Hi, you may find a few examples here If you prefer reset button, check this article
  14. Mathilda

    Column Width on Grid Edit

    Try using the following code in the header of the datapage: <style> .cbGridCtnr > .HeadCtnr > .Table, .cbGridCtnr > .BodyCtnr > .Table, .cbResultSetNavigationTableCellspacing.cbResultSetNavigationTable { width: 100% !important; } </style>
  15. Mathilda

    filtered dropdown options

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