Vitalikssssss

Hi @ChrisJackson, I would suggest using a bit different approach. QR code will lead users to the 2nd Datapage first and in case if there is no records under the Warranty_ID the user gets redirected to the 1st Datapage that is the Submission Form. The concept of re-direction if no records found explained in this topic: Hope this helps. Regards, vitalikssssss

Hi @Mitch, Perhaps you will find below tutorial useful. Also, in order to start using REST API you need to have a solid knowledge of any back-end language. I would recommend learning the PHP since in my opinion it is the easiest to learn. There a lot of training materials on PHP available in the web. There is a post with PHP code samples that you may find useful too: Hope this helps. Regards, vitalikssssss

Hi @achatwani, Please try the following JavaScript: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var suffix = event.detail.uniqueSuffix; document.querySelector(".cbFormSelect").addEventListener("change", myFunction); function myFunction(){ var button = document.querySelector(`#searchID${suffix}`); if(button) { button.click(); } } }); </script> Place it in the Footer of Search Form and make sure that you have disabled HTML editor prior to inserting the code. Hop

Hi @MaraMara, Try the following CSS snippet: <style> .cbSearchSpa { display:none !important; } </style> This should hide the Search Form. Regards, vitalikssssss

Hi @Paolo, You may use timeout setting of authentication in order to log-out the user. Time out and redirection – Configure session expiration after user inactivity and provide a page or URL to redirect timed out users. You can set the interval when authentication session will expire, however the log-out will happen only after session expires and user tries to do some action on a form. It will not be possible to terminate the session of the user simply closes a browser tab or browser. If you are looking for automatic log out even if user left the page open, then you ca

Hi @achatwani, Can you elaborate if you use List-String (datatype) or Listbox (form element)? Regards, vitalikssssss

Hi @mclarkdata, It is not possible to use dynamic fields in Reports like Tabular/List/Gallery because they intended to show more than one record, hence it is not possible to identify from which record the field value should be taken. I guess for your case it is better to set the dynamic labels in authentication table. Regards, vitalikssssss

Hi @Paolo, Caspio offers custom events if you have AJAX enabled. The one that you need to use called "BeforeFormSubmit" it occurs after user clicks on "Submit" button, but unfortunately before the default form validation checks(*required) happens. I can suggest to write all validation needed in JavaScript and use "BeforeFormSubmit" event. Here is documentation: https://howto.caspio.com/datapages/ajax-loading/ Hope this helps. Regards, vitalikssssss

Hi @DesiLogi, It is possible with JavaScript to disable Cascading dropdown, however I would recommend using a Cascading TextField that has an option to disable the input field if only one option returned. If my suggestion does not fit your workflow than you can use the following JavaScript: <script> document.addEventListener('DataPageReady', function (event) { const el = document.querySelector('select[id^="InsertRecordYOUR_FIELD"]'); el.addEventListener('change', ()=>el.disabled="true"); }); </script> Regards, vitalikssssss

Hi @JayDub, Do you have an element with ID "norecord" or you trying to reference the message of Caspio Form? Do you see any errors in browser console? Regards, vitalikssssss

Hi @MaraMara, Well, it might be easier for you just to simple disable the Search form and use Predefined filtering criteria, however if you still need to use a Search form please send me a link to web-page where you have Datapage deployed in PM and I will take a look. Regards, vitalikssssss

Hi @MaraMara, It looks like it is specific to your page because I have tried to create a similar one and JavaScript worked fine. Perhaps you can export the Datapage along with dependencies (no need for data), so I could take a closer look. You can send it as PM. Regards, vitalikssssss

Hi @ChristopherNORD, Please send the screenshot of the updated design of Triggered Action. Regards, vitalikssssss

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

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

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)

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

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

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

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-

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

Hi @DDNex, You may check the following topic that explains how to hide a column in the tabulart report: Hope this helps. Regards, vitalikssssss

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

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

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