Vitalikssssss

Hi @GWBjr, I assume that you would like to populate the table "MSA_Lender_Offering" with all possible combination of ID`s from "Lenders" and MSAs_ tables. If my assumption is correct than you can use Tasks to achieve this. Here is an example of Tasks which populates all possible combination of ID`s from Table_A and Table_B. Hope this helps. Regards, vitalikssssss

Hi @Ras2019, Recently, I have came across the web-site of Caspio Technical Evangelist Ned: https://someapp.com/np/apps/workflow/index.html He has an article which explains how to create a Tool Tip in Caspio: https://someapp.com/np/apps/workflow/tooltip_popup.html Hope it helps. Regards, vitalikssssss

Hi @RickManolo, Well, for me the easiest way to do this is to use a Virtual field to display "Notes" and make an actual field "Notes" as hidden. I assume that you use Single Record Update or Details Datapage. If the answer for above is yes, you can use the following JS code to concat existing Note with AddNote input after Update of the record. <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { let target = document.querySelector('[id*="EditRecordNotes"]'); let n_notes = document.querySelector('input[id*="EditRecordAdd_Note"]').value; let o_notes = document.querySelector('input[name*="cbParamVirtual1"]').value; target.value = o_notes + n_notes; }); </script> Change the name of the fields if necessary, and also make sure you disable HTML editor prior to pasting the code. Hope this helps. Regards, vitalikssssss

Hi @Yolanda, You can find answer in this blog post: https://blog.caspio.com/update-on-caspios-data-transfer-policy/ Regards, vitalikssssss

Hi @mgredmond, Well, it is better to bring your concerns through Caspio Support. Here is a Style attribute which controls width of the Tabular Report.

Hi @valentid, Try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('input[id*="InlineAddWristbandID"]').focus(); }); </script> Regards, vitalikssssss

Hi @Mikey, I am afraid that this feature is not available in Caspio and I doubt that you will be able to find and easy workaround. I have found a feature request in Caspio Ideabox where you can give your vote for this feature. Alternatively, you may consider using shareable Google Sheet where users can copy/past the data and Zapier to sync this spreadsheet with Caspio. Please note that only Premium account in Zapier allows to have near real time sync with Caspio. Free account has 5 minutes interval to perform a Zap. Hope this helps. Regards, vitalikssssss

Hi @eventshd, You are doing correct steps in the email setup, however you trying to render field name as Email link i.o. field email. Hope this helps. Regards, vitalikssssss

Hi @mgredmond, Caspio Style has a default settings for the width of the Datapage set to 100% which overrides the field width settings. You need to check the width of the container where you placed in your CMS and adjust width of the Datapage accordingly. Hope this helps. Regards, vitalikssssss

Hi @mgredmond, If you don`t have any sensative data, can you share with us a link to this Datapage or web-page? You can restrict the width of the Datapage as explained in this article: https://howto.caspio.com/styles/fix-the-width-of-the-datapage/ Regards, vitalikssssss

Hi @LoriM, I think this is possible. Authentication with a User groups explained in this tutorial: https://www.youtube.com/watch?v=X8HZC3mBSPg You may consider using Triggered action for assign the roles to the client. Basic Triggers explained in this tutorial: https://www.youtube.com/watch?v=wA7KR9dygh4 Hope this helps. Regards, vitalikssssss

Hi @Ras2019, That is true, you cannot pass parameters via Bridge session from Result page. I think this is the best option for your case. Regards, vitalikssssss

@GWBjr Try this expression: 'www.' + Substring([@field:Email], ((Charindex('@', [@field:Email]))+1), Len([@field:Email])) Regards, vitalikssssss

Hi @alicecp, I am afraid that HTML block does not support interactive sorting. Regards, vitalikssssss

Hi @DonateGoodStuff, I believe you have used legacy format embed code for deploying your Datapages. Caspio has introduced Asynchronous loading of their Datapage a year or so ago and they also changed the format of embed code. Async loading gives a better performance for Datapage loading. Some Javascript events such as document.write(), onload() is not supported with Async loading. I assume that you have some Javascript (perhaps from TechTips section in HowTo) in either Header, Footer, HTML blocks which has described Javascript event handlers. I can suggest contacting Caspio Support who can help you to resolve this type of issues. Regards, vitalikssssss

Hi @Mikey, I believe that it won`t be possible to track logging if the user close the browser. This type of behavior requires server side programming which is not available in Caspio. Perhaps you will be satisfied with standard feature called User Logs. Regards, vitalikssssss

Hi @the1gofer, Try use "Integer" datatype for personID in table B. Hope this helps. Regards, vitalikssssss

Hi @GWBjr, You may need to utilize Formula field in table where you store user information (auth. table) in order to sub struct domain name and add global domain. You can use the following expression in the Formula field: 'www.' + Substring([@field:Email], (Charindex('@', [@field:Email])), Len([@field:Email])) Finally, you can use this field in Record-Level-Security in order to accomplish your workflow. Regards, vitalikssssss

Hi @Theof, Your data should reside on Caspio in order to create a Front-end part (Datapages). You can easily import your data (.csv, .xml, and others) into the Caspio account and create a relational database. Regards, vitalikssssss

Hi @ManonG, You can use the following script in Datapage Footer: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('[id*=InsertRecord*YOUR_DROPDOWN_FIELD*]').addEventListener('change', function() { let item = document.querySelector("select[id='InsertRecord*YOUR_DROPDOWN_FIELD*']").value; document.querySelector("input[id='InsertRecord*YOUR_TEXT_FIELD*']").value = item; }); }); </script> Please note that this JS code designed for Submission Form Datapage. Also, make sure you disable HTML editor and change *YOUR_DROPDOWN_FIELD* & *YOUR_TEXT_FIELD* to your actual field names. Hope this helps. Regards, vitalikssssss

Hi @Carioca, You may consider integration with Twilio if you would like to send SMS to phone number outside of US/Canada.

Hi @Ras2019, The way you trying to refer to Virtual fields is incorrect. I would recommend using query selectors with contains type of match. This code should work fine: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { var Input1 = document.querySelector("span[id^='cbParamVirtual1']").innerHTML; var Input2 = document.querySelector("span[id^='cbParamVirtual2']").innerHTML; if (Input1 === 'WARNING' || Input2 === 'WARNING') { event.preventDefault(); alert('Enter acceptable volume!'); } else { document.forms["caspioform"].submit(); } }); </script> Regards, vitalikssssss

Hi @Ed727, I am afraid that long text without HTML tags will be rendered as a single line string. Regards, vitalikssssss

Hi @rgiljohann, My previous solution is a bit outdated because Caspio introduced their built-in event handlers. Please try the following updated script: 1. Datapage Header: <style> #doublescroll { overflow: auto; overflow-y: hidden; } #doublescroll p { margin: 0; padding: 1em; white-space: nowrap; } </style> <div id="doublescroll"> 2. Datapage Footer: </div> <script type="text/javascript"> function DoubleScroll(element) { var scrollbar = document.createElement('div'); scrollbar.appendChild(document.createElement('div')); scrollbar.style.overflow = 'auto'; scrollbar.style.overflowY = 'hidden'; scrollbar.firstChild.style.width = element.scrollWidth+'px'; scrollbar.firstChild.style.paddingTop = '1px'; scrollbar.firstChild.appendChild(document.createTextNode('\xA0')); scrollbar.onscroll = function() { element.scrollLeft = scrollbar.scrollLeft; }; element.onscroll = function() { scrollbar.scrollLeft = element.scrollLeft; }; element.parentNode.insertBefore(scrollbar, element); } document.addEventListener('DataPageReady', DoubleScroll(document.getElementById('doublescroll'))); </script> This should help. Regards, vitalikssssss

Hi @kpcollier, Well, the easiest way which came through my mind is to apply record expiration concept described in HowTo article. You can customize "No records found" message in Localization. Hope this helps. Regards, vitalikssssss