Jump to content

Carlson

Caspio Guru
  • Content Count

    143
  • Joined

  • Last visited

  • Days Won

    7

Everything posted by Carlson

  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>
  14. Hello, I am using the following solution to conditionally highlight a calendar datapage. https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/ I would like to modify this script so that I can highlight only the actual calendar day number and not the calendar day block. I am already highlighting the actual calendar day with this script below. I need to highlight the actual calendar day based on certain condition (like end of fiscal month). Does anyone know how I can modify to text-highlight in color the calendar day? <script> if('[@Yes/No FieldName]' == 'No'){ var isi = document.getElementById("visi[@field:UniqueFieldName]"); isi.style.display = 'none'; isi.parentNode.parentNode.style.backgroundImage = 'url("ImageURL")'; } </script>
  15. Carlson

    Rule Help

    MiCro, I use this method for 2 rules for hiding and requiring a field: If you wrap the field in a section, then you can set the rule to hide the section (which will hide the field). Then next rule you can require the field (not the section). This way you can have both rules, you just cannot reference the same field for both hide and require. By referring to section for hide, you are not referring to the field twice.
  16. Geoffdude, You can create a formula field in your table, and concatenate all of your fields, then set the formula field as unique. That way when your scheduled import append runs, it will reject the duplicates and only bring in the new records. This only works if all of your fields are not expected to repeat in same value when you concatenate them. I have set this up on several of my tables as a method of preventing duplicates. It is also a great method to restrict user input of repeat same records.
  17. MayMusic, Is it possible to hide the delete button of inline insert, based on the value of authentication field?
  18. You can create a cascading dropdown to create the 2nd value, and then hide it by wrapping it in <table style="display:none;"></table>.
  19. roattw, Excel formulas will not work directly in Caspio. You can find a list of Caspio formulas below: https://howto.caspio.com/function-reference/
  20. Troubleshooter, You can get around the issue in rules not working due to no editable fields, by adding the fields as hidden type or wrap them in a table to hide them, then display the values using virtual fields. Also, you can set rules to receive an authentication parameter to use in the logic of the rule.
  21. Adam, It is possible, since Zapier does not pass actual file you can construct the file URL below. The only requirement is you need to create a datapage (not actively used, but to create/access the URLS). See constructor below. The downside is you would need the datapage to not be protected by authentications, so it is not a good method for sensitive files. [YOUR SUBDOMAIN].caspio.com/dpImages.aspx?appkey=[INSERT APPKEY OF DATAPAGE] + [@field:NAME_OF_FIELD_HOLDING_FILE] You can also create a formula field in your table to concatenate this. You will still need the datapage to allow URL to work.
  22. TsiBiRu, Thanks, that works well!
×
×
  • Create New...