-
Content Count
464 -
Joined
-
Last visited
-
Days Won
49
Mathilda last won the day on May 25 2018
Mathilda had the most liked content!
About Mathilda
-
Rank
Advanced Member
Recent Profile Visitors
-
hctrr reacted to an answer to a question: Redirect user if not logged in
-
KenColcreate reacted to a post in a topic: Store only date, month and year instead of timestamp
-
Mylene reacted to a post in a topic: Increment value in one field based on status in another field
-
MayMusic reacted to an answer to a question: Current day of the week in an App Parameter
-
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.
-
How to permanently delete files from my database?
Mathilda replied to jason1323's question in General Questions
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 -
You may check this post. I posted script for the similar inquiry there
-
bookish reacted to an answer to a question: PLugin error with Caspio deploy
-
Destination after record submit - Go to new page
Mathilda replied to Holger's question in General Questions
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! -
How to change start of weekday in calendar
Mathilda replied to AndreCouturier's question in DataPages
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 -
Adding Business Days to a Date Field
Mathilda replied to JeremyMenefee's question in Calculations and aggregations
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 -
Reload browser upon form submission
Mathilda replied to shaferam's topic in User JavaScript and CSS Discussions
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 -
What type of the datapage you use? If it's a details, you may need to check padding for the .cbFormLabelCell and .cbFormDataCell classes
-
Mathilda reacted to an answer to a question: Overwrite Localization Date Format on datapage
-
I Am Getting File Not Found
Mathilda replied to sriharsha's question in Security, Authentications, Roles, SAML
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 -
failing to import *.accdb files
Mathilda replied to wv02CASPIO's question in Import/Export and DataHub
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. -
Column Width on Grid Edit
Mathilda replied to niteowl2's question in Tables, Views and Relationships
You're welcome -
Formula field to count text entries
Mathilda replied to tyinawyn's question in Calculations and aggregations
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 -
Hi, you may find a few examples here If you prefer reset button, check this article
-
Column Width on Grid Edit
Mathilda replied to niteowl2's question in Tables, Views and Relationships
Try using the following code in the header of the datapage: <style> .cbGridCtnr > .HeadCtnr > .Table, .cbGridCtnr > .BodyCtnr > .Table, .cbResultSetNavigationTableCellspacing.cbResultSetNavigationTable { width: 100% !important; } </style>