Jump to content


Popular Content

Showing content with the highest reputation since 06/08/2020 in all areas

  1. 2 points
    An Agent from Chat support gave me this doc. Its not official but I hope it helps quack: Table Variables .pdf
  2. 1 point
    Hi @CoopperBackpack Hope you are well. Here is the code that would let you to achieve the result. You should insert it in your HTML block. And I will explain the code below. Please be aware, that I used Virtual Field for this example with name "cbParamVirtual1" as a Calculated Value, since in Caspio virtual field has syntax [@cbParamVirtual1]. You can put there your own field name if needed instead of "cbParamVirtual1" <div class="message"></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('input[id*="cbParamVirtual1"]').addEventListener("change", myFunction); function myFunction(event) { let virField = event.target.value; document.querySelector('.message').innerHTML = "your text should be here " + virField; document.removeEventListener('DataPageReady', myFunction); } }); </script> This is the part where you insert text, added by JS code:: <div class="message"></div> The JS code has place, where you should enter the text you want to have in HTML block. Here is this part, replace "your text should be here " for the one you need. document.querySelector('.message').innerHTML = "your text should be here " + virField; Hope it helps. Regards, Johnny
  3. 1 point
    Hello @vanderLeest, Please try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let title = document.querySelector('#cbParamVirtual2').value; let title1 = document.querySelector('#cbParamVirtual3').value; if (title == title1) { document.querySelector('h4').innerHTML="Add your Invoice"; } else { document.querySelector('h4').innerHTML="Add your Invoice and the Financial Statement Report"; } }); </script> The code should work properly if: 1) you have only one <h4> tag on the DataPage 2) Virtual2 and Virtual3 values are present on the DataPage once it is loaded. Feel free to write back in case you have additional questions.
  4. 1 point

    Importing Excel Files To Table

    You may want to try checking the Web Services Integration (API) thingy. https://howto.caspio.com/web-services-api/ However, its kind of complicated. Cant use it myself so I stick with multiple scheduled import and rely on the best practices they suggested: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/#:~:text=Best Practices,of high-speed data transfer. Quack
  5. 1 point
    Hi @telly, You can use this code to prevent a submission form if a certain condition is not met. <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function () { event.preventDefault(); var a = document.getElementById("InsertRecordFIELDNAME").value; if (a > 100) { alert('Please enter number less than 100.'); } else { document.forms["caspioform"].submit(); } }); </script> Cheers!
  6. 1 point
    I have done this in the past by duplicating my app. I then make the changes in the duplicated app for testing purposes. After everything is done, what you could do is export the new app as Caspio XML format, and then import and replace it to your existing app provided all of the naming conventions are the same. The alternative to importing would be to change your datapages to the new ones.
  7. 1 point

    Datapage Tabular Report Row Click Event

    The rows in a tabular datapage report display colors when they are clicked to highlight the chosen row. Is the event for this exposed so I can attach a javascript event listener and extract data from the selected row ?
  8. 1 point
    Why not use a Details Report? Then show search form with results below it.
  9. 1 point
    You may use the code below to hide fields in the new responsive feature <table style = "display:none;"> <tr> <td> FieldA FieldB </td> </tr> </table>
  10. 1 point

    Redirect user if not logged in

    For anyone trying to accomplish this it is really easy. No need to use the method on the link posted above. Just open your authentication object in Caspio Bridge and expand the Advanced settings. Then set the Timeout option to Other Webpage and enter your standalone login page location. Then once your dashboard/main app page has at least one datapage that requires authentication and the user is not logged in they will be redirected to your standalone login page.
  11. 1 point

    Autocomplete/dropdown Hybrid

    I figured this out. I just needed to create a relationship manually between the lookup table and the child table and enforce referential integrity. Seems like referential integrity should be enforced by default when you use the autocomplete feature but it isn't. The only hiccup I had was that I had sample data in the child table which would not, at first, allow me to to enforce referential integrity. I deleted that data in the table and voila. Now, if you type something that isn't in the lookup table, it gives you an error! For a lawyer-turned-pizza operator working on a medical billing database, it made me happy to find this solution so I hope it helps someone else
  • Create New...