Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 11/27/2021 in Posts

  1. sfraden

    Seriously? Why.....

    Why would they (Caspio) spend all that time updating to 3.0 and completely refresh the web interface with a much cleaner look, but FAIL to actually move the damn chat bubble to the other side, out of the way? We have been asking for that for nearly two years now and it has been voted up several times in the IdeaBox, but for some reason is being ignored by Caspio.... Seems like when they were re-working the entire GUI web interface they could have spent the 5 minutes to move the chat bubble too.....
    2 points
  2. Alison

    Seriously? Why.....

    Hello @sfraden, @kpcollier Thank you for providing valuable feedback. We apologize for the inconvenience caused due to the placement of the chat bubble. Our team is working on a solution to address the concern and we understand that chat function is very beneficial to users to conveniently reach out to Caspio Support team for assistance with inquiries. In Release 30, Caspio user interface has been refreshed to improve the navigation and usability. We value your feedback and are committed to continually improving our product.
    2 points
  3. Hello @JenKri, I think this Forum post suits better for your workflow https://forums.caspio.com/topic/19337-multiple-customers-unique-ticket-number-starting-at-000/ You may check the steps I described in that Forum post. And if to modify the Trigger and Formula for your case: 1) For example, I have the table like this: 2) We are going to insert the Chapter_Number and Year. The Project_Number will be populated with the following Trigger: 3) Formula (the ProjectNumberFinal field) is the following: CASE WHEN [@field:Project_Number] < 10 THEN CAST([@field:Chapter_Number] as nvarchar) + '-' + [@field:Year] + '-' + '00' + CAST([@field:Project_Number] as nvarchar) WHEN [@field:Project_Number] >= 10 AND [@field:Project_Number] < 100 THEN CAST([@field:Chapter_Number] as nvarchar) + '-' + [@field:Year] + '-' + '0' + CAST([@field:Project_Number] as nvarchar) WHEN [@field:Project_Number] >= 100 AND [@field:Project_Number] < 999 THEN CAST([@field:Chapter_Number] as nvarchar) + '-' + [@field:Year] + '-' + CAST([@field:Project_Number] as nvarchar) END 4) The result:
    1 point
  4. wow, thanks so much! Truly appreciate it. It's been great learning JS and building out our caspio platform - really appreciate the sample code and will give it a try!
    1 point
  5. @peewee hi, I guess this should help:
    1 point
  6. @autonumber - I deleted it and it worked perfectly. Thank you so much! Thank you for your reply too @Meekeee!
    1 point
  7. Hi! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery). It is available in R30 version you may check this link: https://howto.caspio.com/release-notes/caspio-30-0/
    1 point
  8. Thanks @KlisaN137! That works.
    1 point
  9. 1 point
  10. @jbloome for implementing it on Details, instead of 'InsertRecordFIELDNAME', you must use 'EditRecordFIELDNAME', and place the code not in the Footer of the page, but add a new HTML block element just after all other elements, and put the code there. Also, additional event listener is needed, here is the entire code: <script> document.addEventListener('DataPageReady', function (event) { const fields = ['EditRecordPhone1','EditRecordPhone2', 'EditRecordPhone3']; const inputs = []; for (let f of fields){ inputs.push(document.querySelector('#' + f)); } for(let i of inputs){ i.maxLength = 14; i.onkeyup = telephize; i.onkeydown = telephize; } function telephize(v_e) { // this.value = this.value.replace( /\D+/g, "" ).replace( /([0-9]{1,3})([0-9]{3})([0-9]{4}$)/gi, "($1) $2-$3" ); //mask numbers (xxx) xxx-xxxx v_e = v_e || window.event; if (v_e.keyCode >= 65 && v_e.keyCode <= 90) { this.value = this.value.substr(0, this.value.length - 1); return false; } else if (v_e.keyCode >= 37 && v_e.keyCode <= 40) { return true; } var v_value = (this.value.replace(/[^\d]/g, '')); if (v_value.length == 7) { this.value = (v_value.substring(0, 3) + "-" + v_value.substring(3, 7)); } else if (v_value.length == 10) { this.value = ("(" + v_value.substring(0, 3) + ") " + v_value.substring(3, 6) + "-" + v_value.substring(6, 10)); }; } document.querySelector('#caspioform').onsubmit = function(e) { e.preventDefault(); if (input.value.length >= 14){ this.submit(); } else { alert('Please input a valid phone number'); input.focus(); } } }); </script>
    1 point
  11. Hi @telepet If it is a Tabular Report, I'm guessing you want this on Details Page? Yes, you need to adjust Element ID, in this case, where you see 'EditRecord' and 'Remove', just follow the same logic. Also, add another part to get rid of the label 'remove': <script> var UploadA='[@field:FIELDNAME]'; if (UploadA.length>0) { document.getElementById("EditRecordFIELDNAME").style.visibility = 'hidden'; document.getElementById("EditRecordFIELDNAMERemove").style.visibility = 'hidden'; document.querySelector('label[for="EditRecordFIELDNAMERemove"]').style.visibility = 'hidden'; } </script> Please instead of using the code in the Footer of the page, add another HTML block element just after the last element, and put the code in it, this will execute code again when the file is uploaded after using Update button.
    1 point
  12. Hello @MeralomaFC, I have one idea and it requires using only Caspio standard features. Maybe someone can share another idea. I don`t think that we can display the Prefixed Autonumber(Ticket_No ) in the popup right after clicking the Submit button since this is an auto-generated value. It appears in the table only after submitting the new record. So, you may try these steps: 1) Add the Number_Of_Tickets field to your table (data type is Integer) 2) Create a second table with the same design, just change the DataType for the Ticket_No field to Text(255) 3) In the first table you may create a Triggered Action(if this option is included in your plan). The Trigger works on data insert and inserts the number of records that is equal to the Number_Of_Tickets into the second table. For example: And these are the records that are inserted by the Trigger into the second table: 4) To display this data to the user we need 2 DataPages: * For example, Details DataPage that is based on the second table, on the 'Search and Report Wizard - Search Type' you need to select the 'Filter data based on your pre-defined criteria' option and receive the Ticket_No value as an External parameter. Since this is Prefixed Autonumber you need to add manually the 'InsertRecord' before the field name: * Submission Form that you mentioned based on the first table. On the 'Web Form Wizard - Select Fields' you need to check this checkbox to pass the Ticket_No value as a parameter: This article regarding the Passing Parameters can be helpful https://howto.caspio.com/parameters/passing-parameters/ And on the 'Web Form Wizard - Destination and Messaging' you need to select the second DataPage as the destination As a result, once the Submission form is submitted, the user is redirected to the Details DataPage where all the records are displayed. It can be a Tabular Report DataPage instead of the Details, for example: Hope this helps.
    1 point
  13. Hello @Amirf, As far as I understood from your description, you have a field in the table with the List-String data type. And on the Submission form it is set to the Multiselect Listbox: If so, List data types have a list of restrictions and it is better to avoid using them in case you need more than just submitting and displaying the values. This article can be helpful https://howto.caspio.com/tables-and-views/data-types/list/ 1) You may use Text(255) data type instead and apply this solution to allow multiselection https://forums.caspio.com/topic/3148-js-select-multiple-values-from-a-listbox-in-a-webform/ 2) Since selected values are added to the table as comma-separated values, it is possible to count them in the Formula field: CASE WHEN LEN([@field:Text_field]) = 0 THEN 0 ELSE LEN([@field:Text_field]) - LEN(REPLACE([@field:Text_field], ',', '')) + 1 END Replace the field name with your local field name. Here is the result: I am hot sure that this is the case for you but hope this helps.
    1 point
  14. the answer is this: in rules for datapages based on virtual calculated field queries of Yes/No variables, the values are Y and N.
    1 point
  15. Hi @IamBlossom, For File DataTypes, you need to use SQL's "DATALENGTH" to measure if the field has content or not. It is a behavior that NOT NULL or IS NULL will not work for File Datatype. Use this instead: CASE WHEN DATALENGTH([@field:Images]) = 0 THEN 'No image attached' ELSE 'Image available' END Hope this helps!
    1 point
×
×
  • Create New...