Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @ChristopherNORD, Please send the screenshot of the updated design of Triggered Action. Regards, vitalikssssss
  2. Hi @maramedinan, I have found that the snippet of code on your Datapage has a syntax error. You should put opening bracket "{"after (element.innerHTML > 7) Regards, Vitalikssssss
  3. Hi @maramedinan, It looks like for report with grouping additional <tr> added in HTML, so you need to use: nth-child(15) let arr = document.querySelectorAll('td:nth-child(15).cbResultSetCalculatedField'); Regards, vitalikssssss
  4. Hi @maramedinan, Solution provided above will not work unless the code placed in HTML block (row element). I have created a different snippet for highlighting some particular cell that you can try. Please make sure that you replace number that refer to the column number in below code. Column count starts with "1". The following code should go into DataPage Footer. <script> document.addEventListener('DataPageReady', function(event){ let arr = document.querySelectorAll('td:nth-child(4).cbResultSetCalculatedField'); //change number of the column in "nth-child(4)
  5. Hi @JanineB, It looks like the "$" currency sign added by formatting is the reason for element value not been recognized as a number. You may add a replace function with regex to remove unwanted characters from value formatted as currency. So, your JavaScript would look like this: <script> var elems = document.getElementsByTagName("td"); for (var i=0, m=elems.length; i<m; i++) { if (elems[i].innerHTML.replace(/[^0-9\.-]+/g,"") > 0) { elems[i].style.textDecoration = "line-through"; } } </script> Regards, vitalikssssss
  6. Hi @ChristopherNORD, I would not recommend using IF/THEN block for this case. I would rather recommend using a WHERE clause in Update block to check the status field. Regards, vitalikssssss
  7. Hi @KamAB, I did not find an attribute within the Styles section of Caspio Bridge, so you may add the following snippet in DataPage Header: <style> div > span { font-size: x-large !important; font-weight: 700 !important; } </style> Regards, vitalikssssss
  8. Hi @jazmichaelking, It looks like G Suite supports SAML 2.0 (Security Assertion Markup Language) that also used by Caspio SAML, however G Suite is not listed as one of the Idp provider that has been verified by Caspio. I haven`t done this type of integration yet but overall it should be possible. The only challenge I see is to understand how to store usernames in Caspio table. I guess it is possible to find out the format of user_name returned by Idp from G Suite support. Here are some links that should help: https://howto.caspio.com/authentications-and-connections/single-sign-
  9. Hi @ChristopherNORD, Perhaps it would be a good idea to add a checkbox field to table to distinguish when field Date_Added can be editable (e.g. Editable: Yes/No). You may add an additional condition in WHERE clause to filter-out records that has "Editable" field set to "No" (unchecked). Hope this helps. Regards, Vitalikssssss
  10. Hi @DDNex, You may check the following topic that explains how to hide a column in the tabulart report: Hope this helps. Regards, vitalikssssss
  11. Hi @BillW, Please share with us a package of your DP with dependencies. No data required. I will take a closer look at the settings you have applied. Regards, vitalikssssss
  12. Hi @JKSGT, What Datapage type do you use? Screenshot from a browser console (Windows: Ctrl+Shift+I | Mac: Cmd + Shift + I) would help to understand your case better. Regards, vitalikssssss
  13. Hi @BillW, There is a small error in this part of your code. There is no "value" attribute available for element Calculated value because value is rendered within a <span> tags. You would need to use "InnerHTML" property to get the text value of Calculated field. So, above line of code should look like this: let fan = document.getElementById("InsertRecordODE_Fan_TIR").innerHTML; Hope this helps. Regards, Vitalikssssss
  14. Hi @Mik271828, It looks like the Datapage has been deployed within a container which has width <1024 px, hence responsive CSS has been applied on styling. You may disable a responsive option if you do not use Datapages on tablet/mobile devices or go into the Style section -->Source and change the HTML properties related to tablet/phone CSS. Hope this helps. Regards, vitalikssssss
  15. Hi @Elderberg, I would like to share a different approach, so instead of using a submit() function I have used the click() function on Submit button to mimic submit event. Also, it is possible to use AppKey of the Datapage in order to submit the particular Datapage if more than one is deployed. <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { if (event.detail.appKey == 'XXXXXXXXXXXX') { event.preventDefault(); //do smth before Submit document.querySelector(`#Submit${event.detail.uniqueSuffix}`).click(); } })
  16. Hi @asesores, That is very interesting question. I come up with a workaround which would allow to create a cross join between 2 tables in Caspio. Basically, you would need to add an additional field in both tables and specify the identical values for all records. Table #1 Table #2 Create a View with Full Outer Join by the Join Field: Here is a result which you shall have: Hope this helps. Regards, vitalikssssss
  17. Hi @Josh1425, Triggered Action settings looks inline with the desired output. Do you have a Triggered Action on table "Entity_Information"? Do you see data in table New_Intake_Information_Form within fields used in Triggered action? Regards, vitalikssssss
  18. Hi @jorgeorbit, Perhaps you did not follow the correct syntax while specifying the values of the fields. It would be easier to narrow down the issue if you send a Body of the request and specify datatypes of fields which you use to create a record. Regards, vitalikssssss
  19. Hi there, I have some check boxes, for example 5 and I want the form to not being submitted if at least one of them is checked. How can I do that? Thank you for looking into my question.
  20. Hi @Joanne, the way how you reference fields is incorrect for Inline Edit action of Tabular report and also you need to use a special event to capture the moment then user clicked on Edit/Update button/link. You may try to use the following snippet, however make sure that name of the fields are correct and have prefix "InlineEdit". <script> document.addEventListener('DOMSubtreeModified', function(){ let element = document.querySelector('[id*="InlineEdit"]'); if (element) { let regExp = /^[0-9]+$/; //Change the name of the fields let arr
  21. Hi @Shamir, It is possible to use External parameters within SQL query in Calculated field, so you would need to pass the parameter "on exit" from Virtual field and add it in WHERE clause of your SQL query. Hope this helps. Regards, vitaliksssss
  22. Hi @JMR21, You would need to add a line of code which would click on Search/Submit button after user clicks Clear Form, so it could pass empty string parameters to other Datapages. So, the JS snippet could look like this: <button type="button" onclick="resetForm()">Clear Form</button> <script> function resetForm() { var myForm = document.querySelector('form[action*="[@cbAppKey]"]').querySelectorAll('input:not([type=submit]):not([type=hidden]), textarea, select'); myForm.forEach(function(elem) { elem.value=""; }); var searchBtn = document.q
  23. Hi @Dallin, It looks like the issue is specific to your account and it is better to reach out to Support Team of Caspio. https://www.caspio.com/support They usually unavailable by phone on weekends, however LiveChat should be available. Regards, vitalikssssss
  24. Hi, I have recently tried to do something similar and came across the issue that custom button cannot serve delete event, so I have modified a script slightly. Here is my button in HTML block: <input class="cbDeleteButton" id="Mod0DeleteRecord1" name="Mod0DeleteRecord" type="submit" value="Delete" /> and here is my code from the DataPage Footer: <script> document.addEventListener('DataPageReady', assignEvent); function assignEvent(event){ //assign click event to custom button document.querySelector('#Mod0DeleteRecord1').addEventListener('click', ()=>{
  25. Hi @jrifkin, Glad that heard that solution has helped. Here is updated version which would also capture the file extension. Please note that you should use the following naming convention for your fields which would store extension: File_1_ext File_2_ext File_3_ext etc <script type="text/javascript"> document.addEventListener('DataPageReady', fileInputEvent) function fileInputEvent() { const fileFields = ['File_1', 'File_2']; fileFields.forEach(el=>{ document.querySelector(`#InsertRecord${el}`).addEventListener('change', fileInputHandler); }); doc
  • Create New...