
LittleMsGinger
Caspio Rockstar-
Content Count
285 -
Joined
-
Last visited
-
Days Won
17
LittleMsGinger last won the day on April 6
LittleMsGinger had the most liked content!
About LittleMsGinger
-
Rank
Advanced Member
- Birthday June 8
Recent Profile Visitors
-
Vvillie reacted to a post in a topic: Search Records - Phone Number Formatting JS not working
-
How to receive ID from "On exit, pass ID and formula fields as parameters" checkbox
LittleMsGinger replied to hctrr's question in Parameters
Hello @hctrr, What you currently have in the configuration is already correct. You just need to add 'InsertRecord' prefix in your Parameter Name since you are receiving an ID. It should be [@InsertRecordTransaction_Id]. For more details, you may refer to this article: https://howto.caspio.com/parameters/passing-parameters/ Hope this helps! -
Hi @kpcollier, The reason why the parent page refreshes every time you open the popup is because of the behavior of button tag. It looks like this tag <button> </button> is acting like a Submit Button. To solve this issue, you can use input tag instead: <input type = "button" value ="Open Details" onclick="OpenPopupCenter('URL', 'test', 500, 500);"></input> Hope this helps!
-
Trigger Action to update child table
LittleMsGinger replied to CesarG's question in Tables, Views and Relationships
Hi @CesarG, Here is a sample Triggered Action for reference: Here is the link to the howto article: https://howto.caspio.com/tables-and-views/triggered-actions/ -
How to save an aggregate value in a table
LittleMsGinger replied to ServiceBreez's question in Calculations and aggregations
You can also check this howto document for more details about Trigger: https://howto.caspio.com/tables-and-views/triggered-actions/ -
Custome Messages In Calculated Fields
LittleMsGinger replied to esisov's question in Calculations and aggregations
If it is on the reports, you can use calculated fields. See articles for reference: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/#ConditionalCasesInCalculatedFields https://howto.caspio.com/function-reference/ -
Graphics In Calculated Field
LittleMsGinger replied to Elena's question in Calculations and aggregations
Hello, You can display the image via HTML Block. You may use this formula in the Calculated Field: CASE WHEN [@calcfield:3]=[@field:Grade] THEN '' ELSE '<img src="https://mysource.com/images/redflag.jpg">' END Then, insert an HTML block and display the result of the calculated field. Render it as an HTML. To hide the calculated value, please see this post:- 2 replies
-
- graphics
- calculated field
-
(and 1 more)
Tagged with:
-
Sql Insert Into Statement
LittleMsGinger replied to WillJennings's question in Calculations and aggregations
Hi all, With the current version of Caspio, there is now Triggered Action. You can use Triggered Action to perform calculation and to insert into a Table. Here is the link for reference: https://howto.caspio.com/tables-and-views/triggered-actions/ -
Calculated fields and turning rounding off
LittleMsGinger replied to David52's question in Calculations and aggregations
I know it's too late to answer this post but for other users that may go over this, here's my take to this question: Upon checking the formula, the result is not rounding off. Make sure that the formatting is set to none. -
This Youtube video discuss more details about Application Architecture.
-
Dropdown menu with 2 display fields
LittleMsGinger replied to maicolgalante's question in General Questions
Hi all, In addition to previous responses, make sure that when you concatenate fields, convert it to Text(255) as well if you would like to use this Formula Field in Field for Value. Concatenating two Text(255) fields, makes the Formula Field as Text(64000). Refer to this formula: Convert(nvarchar(255), [@field:First_name] + ' ' + [@field:Last_name]) Hope this helps. -
Hi @DesiLogi, As I understand, you would like to display the results or records for the current week upon loading. You don't need to calculate for the Start Date to be Sunday and End Date to be Saturday. You may use Current Week for the Comparison Type: Then, if you still need to have search form, you can add new criteria. The Logic will be: Hope this helps.
-
Form field "on focus" formatting
LittleMsGinger replied to ta33ik's question in Styles and Localizations
Hi @ta33ik, You can add this CSS Code to change the border color of a Text field when it's on focus: <style> input:focus { outline-color: red !important; } </style> If there is a Text area, add this inside the style tag: textarea:focus{ outline-color: red !important; } Then, this code if there are dropdowns: select:focus{ outline-color: red !important; } Hope this helps! -
Show last 4 digits only
LittleMsGinger replied to Master's topic in User JavaScript and CSS Discussions
Hello, Sharing with you my solution to display only the last 4 digits of the credit card information in Details Page. Paste this in the Footer: <script> var account = document.getElementById('EditRecordCCNumber'); account.value = new Array(account.value.length-3).join('x') + account.value.substr(account.value.length-4, 4); </script> Replace CCNumber in EditRecordCCNumber depending on the correct field name in the Table. Using this code, you can directly change the value of the field without using Virtual fields and Rule. -
Hello, Sharing with you my solution to display only the last 4 digits of the credit card information in Details Page. Paste this in the Footer: <script> var account = document.getElementById('EditRecordCCNumber'); account.value = new Array(account.value.length-3).join('x') + account.value.substr(account.value.length-4, 4); </script> Replace CCNumber in EditRecordCCNumber depending on the correct field name in the Table.
-
Input Mask Ssn Social Security Number
LittleMsGinger replied to Master's topic in User JavaScript and CSS Discussions
Hello, I also have a short script that will mask SSN value in a Details Page. <script> var account = document.getElementById('EditRecordSSN'); account.value = new Array(account.value.length-3).join('x') + account.value.substr(account.value.length-4, 4); </script> Replace SSN in EditRecordSSN depending on the correct field name in the Table. Cheers!- 2 replies
-
- input mask
- SSN
-
(and 2 more)
Tagged with: