Jump to content

Carlson

Caspio Guru
  • Content Count

    143
  • Joined

  • Last visited

  • Days Won

    7

Carlson last won the day on February 4

Carlson had the most liked content!

1 Follower

About Carlson

  • Rank
    Advanced Member

Recent Profile Visitors

1,062 profile views
  1. 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?
  2. 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 import is daily, you could add where clause to select statement that only runs task on today's records (use difference of days between import timestamp and system timestamp = 0). You would need import timestamp added to your table for this. I am using a similar process for a few apps of mine and found it works. If you want to go that route I can share some example task screens for how it would need to be setup. If you are running any aggregate values in your apps off of this field you will want it transformed into numeric, single value only.
  3. 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.
  4. 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.
  5. George43, Thanks, I was able to get it to work following those steps.
  6. 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 entered an invalid value in the Enter Checks Deposit field. Value cannot contain more than 2 decimal places."); this.value = ""; } } return this; //for chaining }); }); </script>
  7. 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 #
  8. 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.
  9. 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 include letters or symbols."); document.getElementById("EditRecorddeposit_cash").value=""; document.getElementById("EditRecorddeposit_cash").focus(); } else if((cash) < 0) { alert("You have entered an invalid value in the Enter Cash Deposit field. Value cannot be a negative amount."); document.getElementById("EditRecorddeposit_cash").value=""; document.getElementById("EditRecorddeposit_cash").focus(); } } document.getElementById("EditRecorddeposit_cash").onchange = numericValueValidation1; </script>
  10. 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 let you know if I am able to get it to work.
  11. 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.
  12. 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.
  13. George, Is there a way to modify this line below, so that it automatically points to that calendar day number? The line below automatically points to the calendar block, so I was hoping I could achieve similar without having to declare the calendar day #. isi.parentNode.parentNode.style.backgroundColor = '#FFFF99'; Here is my script: <script> if('[@calcfield:1]' == 'Over / Uncorrected'){ var isi = document.getElementById("visi[@field:record_id]"); isi.parentNode.parentNode.style.backgroundColor = '#FFFF99'; } else if('[@calcfield:1]' == 'Short / Uncorrected'){ var isi = document.getElementById("visi[@field:record_id]"); isi.parentNode.parentNode.style.backgroundColor = '#FFFF99'; } else if('[@calcfield:1]' == 'Not Completed'){ var isi = document.getElementById("visi[@field:record_id]"); isi.parentNode.parentNode.style.backgroundColor = '#B0C4DE'; } else if('[@calcfield:1]' == 'Past Due'){ var isi = document.getElementById("visi[@field:record_id]"); isi.parentNode.parentNode.style.backgroundColor = '#D8BFD8'; } </script>
×
×
  • Create New...