LittleMsGinger

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!

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/

You can also check this howto document for more details about Trigger: https://howto.caspio.com/tables-and-views/triggered-actions/

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/

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:

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/

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.

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.

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!

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.

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!