-
Content Count
176 -
Joined
-
Last visited
-
Days Won
14
JolliBeng last won the day on October 2
JolliBeng had the most liked content!
About JolliBeng
-
Rank
Advanced Member
Recent Profile Visitors
427 profile views
-
Hi all, This article might also be helpful: https://stackoverflow.com/questions/14676613/how-to-import-google-web-font-in-css-file ~JolliBeng
-
-
H @DTINVN, If I understand you correctly, you want to reduce the display size of your label or some sort of rounding off the record value. That can be configured under the 'Configure Chart Options' of your DataPage. You can refer to this screenshot: If this does not help, I suggest that you provide detailed information of what are you trying to achieve. ~JolliBeng
-
-
Hi, For future reference, you may check this video on how to build a Job Posting application: ~JolliBeng
-
Hi, Just to update this post, after the release 19.0, the IsNull() Function in your formula might not work. Using IsNull() in Formula Fields, Calculated Values and Calculated Fields will only accept date/time values for the replacement value. Please see the link below for more details: https://howto.caspio.com/release-notes/caspio-bridge-19-0/19-0-impacted-areas/ ~JolliBeng
-
Can I add a general search box to my report?
JolliBeng replied to ctfdevourer's question in DataPages
The submission form will serve as your search page. You will just need to add virtual fields so that the entered data will not be saved to the table. You may also refer to this article. ~JolliBeng -
Hi, I'm assuming that you're unable to sort your report by date because the data type of your field is Text. If that is the case, you'll need to convert it first to a datetime field. Here's a formula that you may use: CONVERT(DATETIME, [@field:], 101) You'll need to add a Formula field first where you can insert the formula provided above. After that, you can now select that Formula field from the Sorting options on your report. ~JolliBeng
-
Hi, Just to add on @AtayBalunbalunan's comment, if you have a copy of your layout saved as a Word document, you can use the Paste from Word option on your HTML block. In that way, you'll be able to print the details with your desired layout. Here's a screenshot: Also, here's the DataPage I created using that workaround. Click this link. ~JolliBeng
-
Sql Empty Values In Calculation Returning Error In Formula
JolliBeng replied to TroyPurdue's question in Calculations and aggregations
Hi, Just to update this post, after the release 19.0, the IsNull() Function in your formula might not work. Using IsNull() in Formula Fields, Calculated Values and Calculated Fields will only accept date/time values for the replacement value. Please see the link below for more details: https://howto.caspio.com/release-notes/caspio-bridge-19-0/19-0-impacted-areas/ ~JolliBeng -
Next Field Record for html block?
JolliBeng replied to Jorozcorosado's question in General Questions
Hi @Jorozcorosado, Can you provide some screenshots of your expected output? ~JolliBeng -
Change data entered into form fields to Uppercase
JolliBeng replied to Kristy1's topic in User JavaScript and CSS Discussions
Hi, You can also add a simple CSS code on your Style to enforce Uppercase in the input fields of your Submission form. You just need to follow these steps: Edit the Style that you are using. On the DataPage Elements, go to Form Details -> Fields Click Source tab, Look for .cbFormTextField and add this code: text-transform: uppercase; ~JolliBeng -
Hi, Just to add on @Barbie's comment, here's a useful guideline on SQL functions that are accepted in Caspio: ~JolliBeng
-
-
Task to send email with multiple records
JolliBeng replied to matstein's question in Tables, Views and Relationships
Hi @matstein, If you want to send email to multiple users who meet a certain criteria, yes that is possible. You can add the criteria under your WHERE clause. You may refer to this sample Task: For further information regarding Task, you may click this link. ~JolliBeng -
Accepted SQL commands? Endless calculated field syntax errors
JolliBeng replied to roattw's question in Calculations and aggregations
Hi JamesMobiloo, Yes, that is correct. You can use Calculated Fields on Report DataPages. Aside from that, you can also use SQL functions on Calculated values on Submission forms and Triggered Actions on the table level. You may also check the Function Reference document to see the functions that are accepted in Caspio. ~JolliBeng -
-
Hi @SteveT, If you want to add filters, you can add search fields on your Search page and you can also set your form to have the search and results on the same page so you can see the filtered records right-away upon searching. Also, make sure that the logic that you are using is "AND". You may refer to the screenshots below: -JolliBeng