Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Carlson last won the day on February 4 2019

Carlson had the most liked content!

About Carlson

  • Rank
    Advanced Member

Recent Profile Visitors

1,280 profile views
  1. Hello, I have a details datapage with an iframe in it. The iframe is a tabular report with inline add enabled. When user adds the inline add record, I would like to update the value of a field on the parent datapage without reloading the parent page. How can I achieve this? Thanks, Chris
  2. I am using two fields in a tabular report details page: a dropdown field and a Multi-select listbox with Select All option enabled. I would like to automatically unselect all multi-select listbox items that are currently checked when a value is selected in the dropdown field. Any recommendations on how I can achieve this?
  3. Chato, You could achieve it through tasks: - create a table that acts as the staging area for transforming the records - create a table that receives the transformed records - create a task that checks the position of the ; in column c and substrings the first part into the final table as a new record and substrings the second part into the final table This process would require a case statement in tasks where it checks position of ; and transforms the value accordingly. You would need multiple if statements to check position of ; and transform accordingly. If imp
  4. You could use triggered actions to look for a string that replaces fields contents bases on contains. This method would update the value in the table which you could display on the confirmation page. KEYWORD_1 = @tippytv value KEYWORD_2 = Replaced error message value If you need the value to be displayed to user on the datapage, you could create a rule that runs when field contains the keyword, by hiding a section with HTML block message when field does not contain keyword.
  5. jnordsrand, I have created several apps successfully that score a test or quiz. Before the advent of calculated fields in update datapages, I had to rely on javascript to achieve this. But now with the recent Caspio release you can make use of the calculated values in virtual fields to calculate a score. Or you can score it directly in the table by creating formulas in your table that have case statements checking each answer and returning a count of 1 for Yes and 0 for No. Just string your case statement together to create a total score. I can explain in more detail if needed.
  6. George43, Thanks, I was able to get it to work following those steps.
  7. George43 I am using this script below on a details page (in the header) to check if numeric value entered exceeds 2 decimal places. How would I translate this script to work in the validation script you provided above? It work on the details page but not tabular inline edit. <script> $( function() { $('#EditRecorddeposit_checks').keyup(function(){ if($(this).val().indexOf('.')!=-1){ if($(this).val().split(".")[1].length > 2){ if( isNaN( parseFloat( this.value ) ) ) return; alert("You have en
  8. table[data-cb-name^="cbTable"] tr td:nth-child(10) { border-left-color: #000; border-left-style: solid; border-left-width: thin; } child() indicates the column #
  9. Hello, Is there a way to style only specific columns in a tabular report? For example, I would want only left and right borders on column #2.
  10. Hello, I am using the following script on a details page for form validation, but I would like to modify it to use for edit fields in a tabular inline edit. I noticed that the id is unique in tabular inline view and was wondering if anyone knows how to modify this to work or has an existing script that works. <script> function numericValueValidation1() { var cash=document.getElementById("EditRecorddeposit_cash").value; if(isNaN(cash)) { alert("You have entered an invalid value in the Enter Cash Deposit field. Value must be numeric. Do not inc
  11. Vanellope, Currently it will only send one record at a time. I have been thinking about this issue as well since I am used to manually triggering email summaries (a single email with multiple records) using the bulk edit option on a tabular report to generate the email manually. I have a few ideas in mind that I have not tested yet, such as running a task to append the record as HTML to a central field which would build the table of records, then once completed generate a summary trigger that would send the email with the table of records. This of course is just an idea for now, I will le
  12. JckDY, I have been able to store 3M records, but I believe now with recent system upgrades it can store more. The main factor is the table file size (not records). When the table file size reaches 1GB it can cause it to freeze up. Caspio recommends number of columns to be no more than 255, but I have reached 365 before. That was my experience prior to recent upgrades so it may have increased since.
  13. JckDY, Make sure you click the first cell of the column you want to replace before using this function, then click the replace function. Put the dropdown "search range" on "current column" and dropdown "direction" on "down". Then click replace all. Then check match case and match entire field. Make sure you are selected on the right column so it does not change values in a column you do not want to change.
  • Create New...