Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. 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
  2. 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
  3. 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
  4. Vitalikssssss

    data transfer

    Hi @Yolanda, You can find answer in this blog post: https://blog.caspio.com/update-on-caspios-data-transfer-policy/ Regards, vitalikssssss
  5. 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.
  6. Hi @valentid, Try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('input[id*="InlineAddWristbandID"]').focus(); }); </script> Regards, vitalikssssss
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. @GWBjr Try this expression: 'www.' + Substring([@field:Email], ((Charindex('@', [@field:Email]))+1), Len([@field:Email])) Regards, vitalikssssss
  14. Hi @alicecp, I am afraid that HTML block does not support interactive sorting. Regards, vitalikssssss
  15. 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
  16. 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
  17. Hi @the1gofer, Try use "Integer" datatype for personID in table B. Hope this helps. Regards, vitalikssssss
  18. 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
  19. 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
  20. 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
  21. Hi @Carioca, You may consider integration with Twilio if you would like to send SMS to phone number outside of US/Canada.
  22. 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
  23. Hi @Ed727, I am afraid that long text without HTML tags will be rendered as a single line string. Regards, vitalikssssss
  24. 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
  25. 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
  • Create New...