Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


LWSChad last won the day on June 4

LWSChad had the most liked content!

About LWSChad

  • Rank
    Advanced Member

Recent Profile Visitors

2,566 profile views
  1. Hello, I am trying to let a 3rd party edit a specific DataPage. I have created a group with "Edit DataPage" permission for the single DP. The issue I am running into is that the user only was able to edit or access the DataPage on the 1st login. After that, they can't navigate to it, search for it using the app key, nor use a link to the dp edit page (https://acctID.caspio.com/ui/apps/app/datapages/dpName/appKey/folder/folderName). They are presented with the following error on any Caspio Bridge action. "Permission denied. Contact your in
  2. Great topic! I'll share my process and am would be eager to learn about some other ideas. Also, this approach may not work in all deployments - I use unique html files for every datapage, and use iframes on the main interface for multiple datapages per user interface page. Caspio DataPage folders: FolderName [5-14] // current dev folder for the current project, monthly update, weekly update, feature addition, patch, etc. FolderName [LIVE] FolderName [old-versions] DataPage updates : Revision history! This is a utilized tool when iterations ar
  3. Want to talk about a Caspio project? Schedule a meeting at https://lightbulb.as.me/new-project

  4. Hi @kpcollier, Choosing a specific value from a dropdown can be achieve with a bit of javascript. First, identify the dropdown element and create an array the represents the dropdown choices: const dropdownEle = document.querySelector('[name*=field_name]'); const dropdownChoices = dropdownEle.options; Next, create the makeSelection function: function makeSelection(selectionID) { // loop all the dropdown options for(let i = 0; i < dropdownChoices.length; i++) { // if the dropdownChoice matches the selectionID... i
  5. To expand to all forms document.querySelector('[name*=Recordfield_name]').type = 'number'; Caspio names inputs according to the following syntax. Submission forms: <input type="text" name="InsertRecordfield_name" id="InsertRecordfield_name_includes_textstring_if_cascading" value="" class="cbFormTextField"> Edit and detail forms: <input type="text" name="EditRecordfield_name" id="EditRecordfield_name_includes_textstring_if_cascading" value="" class="cbFormTextField"> Virtual fields in all forms: <input type="text" name="cbParamVirtual2" id="cbParamVirtu
  6. Hi @fundy, Temporary API tokens generated on login would be pretty cool indeed! One approach that successfully allows one to get an API access token while keeping API keys secure is to use an AWS Lamba function. Using a lambda means API keys are used in a server-side function, so the keys stay out of the browser, where they're vulnerable. Call this function with an endpoint exposed using an AWS API Gateway (for example). Successful requests respond with temporary access tokens (and errant calls return a descriptive error message). Lambda Function: var XMLHttpRequest =
  7. I just double checked https://acctid.caspio.com/rest/swagger#/Tables and total records returned in not included in API responses. Try running loops until a response with no results is returned. For example if you have 950 records... https://acctid.caspio.com/rest/v2/tables/tbl_customer/records?q.select=PK_ID&q.pageNumber=1&q.pageSize=1000 may return { "Result": [ { "PK_ID": 1 }, * 949 more results ] } then https://acctid.caspio.com/rest/v2/tables/tbl_customer/records?q.select=PK_ID&q.pageNumber=2&q.pageSize=1000 would
  8. I have bumped into long query string limits as well. This forum post provides some context: https://stackoverflow.com/questions/812925/what-is-the-maximum-possible-length-of-a-query-string Another approach would be to use fields to pass the data. Set the fields to text field or text area so you can pass the data on exit (fig.1). Then set the destination and messaging options to load the new page (fig.2). Lastly, capture the parameters in the submission DataPage with the ID field as a text field for editing (fig.3). fig.1 fig.2 fig.3
  9. Hi @kpcollier Then a bit of javascript to check for the parameter. <script> var p = '[@your_parameter]'; if(p !== '') { console.log('parameter present - auto search'); yourAutoSubmitFunction(); } else { console.log('no parameter - behave normally'); } </script> Pair this with the AutoSubmit described here (and that you mentioned) To prevent a loop, reset Caspio parameters with (cbResetParam=1 on the link back to search. Search form URL: /your-search-page.html?cbResetParam=1 I hope this helps
  10. Hi @CRamsey, I also think your first approach is the best solution. It looks like your authentication source is a view (PRM_User_Table_ preceding each option leads me to that conclusion). Check to make sure the Org_ID is in that view to have it show up there. If that doesn't do the trick, and the parameter approach is also not working (I am a bit confused why the Org_ID wouldn't be the same for all users the admin adds, but alas) you can get the Ord_ID with another approach. Set up a hidden virtual field to load PRM_User_Table_User_ID (from auth fields). Then set Org_ID as a
  11. I Chad.

    Are you still using Tinymce  Rich Text editor.  If so, is it complicated to set up?

    Thank you





    1. LWSChad


      I do. I have also tried a Quill, but TinyMCE is my choice. It's pretty straightforward.

      Here is a recent deployment:

      <script src="https://cdn.tiny.cloud/1/your_api_key/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
            selector: 'textarea',
            plugins: 'lists image imagetools table tinymcespellchecker fullscreen insertdatetime hr nonbreaking paste code',
            toolbar: 'fullscreen undo redo paste pastetext formatselect bold italic underline forecolor backcolor image table code',
            menubar: 'edit view insert format tools',
            menu: {
                edit: {title: 'Edit', items: 'undo redo | cut copy paste pastetext | selectall'},
                view: {title: 'View', items: 'visualaid fullscreen | code'},
                insert: {title: 'Insert', items: 'image inserttable | hr nonbreaking | charmap | insertdatetime'},
                format: {title: 'Format', items: 'bold italic underline strikethrough superscript subscript | formats fontformats fontsizes align lineheight | forecolor backcolor | removeformat'},
                tools: {title: 'Tools', items: 'spellchecker spellcheckerlanguage'}
            font_formats: 'Arial=arial,sans-serif; Times New Roman="Times New Roman", georgia, serif',
            block_formats: 'Header 1=h1; Header 2=h2; Header 3=h3; Paragraph=p',
            style_formats: [
                { title: 'Heading 1', format: 'h1' },
                { title: 'Heading 2', format: 'h2' },
                { title: 'Heading 3', format: 'h3' },
                { title: 'Paragraph', format: 'p' },
            spellchecker_language: 'en_GB'

      I just added that code to an HTML block below the textarea to format. If you have more than one textarea on your page, change the selector to something like

      selector: '#EditRecordfield_name',


      Sorry about the delay, I didn't get notified of this question

  12. Unsure, but I wonder if the authenticated DataPage has not had a chance to load yet so the test will always fail as it runs too early. Try an iframe deployment and run the check onload. <iframe name="dp_name" title="dp_name" src="https://123.caspio.com/dp/123">Sorry, but your browser does not support frames.</iframe> <script> var loggedInTestIfr = document.getElementsByName('dp_name')[0]; loggedInTestIfr.onload = function(){ checkLoggedIn(); }; function checkLoggedIn(){ var myTestElem = document.getElementById('loggedInTestDiv'); if (myTestElem == n
  13. Hi,

    I am trying to create a Caspio submission form with multiple signature fields - all of which send the signature images to my table.

    I have tried the multiple signature code on the forum and it doesn't work - it is probably my understanding.

    Here is the code i have used:

    Header code:

    <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
    <script src="[@app:SignaturePad/]"></script>
    <div id="cb_sign_wrapper">

    Signature Fields (Hidden):




    HTML Block Code:

    <div class="sigPad">
        <div class="sig sigWrapper">
            <canvas class="pad" width="218" height="55" style="margin: 0px 0px 0px 100px;  border-style: solid; border-width: 1px; border-color: #bbbbbb #dbdfe6 #e3e9ef #e2e3ea; -webkit-border-radius: 1px; -moz-border-radius: 1px; -o-border-radius: 1px; border-radius: 1px; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; box-sizing: border-box; background-color: #FFFFFF;"></canvas></br>
            <span style="margin: 0px 0px 0px 264px;">
                <input type="reset" class="clearButton" value="Clear">
            <input type="hidden" name="output" class="output">

    Virtual1 Field (Hidden), Virtual2 Field (Hidden) etc

    Footer Code:

    <script type="text/javascript">
            function ()
                // TODO: Add your signature fields here in the order they appear on the form -->
                var signatureFields = [
                    ['Safety_comm_attendee_1_sig', [@field:Safety_comm_attendee_1_sig], 'cbParamVirtual1'],
                    ['Safety_comm_attendee_2_sig', [@field:Safety_comm_attendee_2_sig], 'cbParamVirtual2'],

                for (var i = 0; i < signatureFields.length; i++)
                    var api = $($('#cb_sign_wrapper_edit .sigPad')).signaturePad({ drawOnly: true });
                    if (api)

                document.addEventListener('BeforeFormSubmit', function(event) {
                    for (var i = 0; i < signatureFields.length; i++)
                            // Dump signature JSON data into hidden signature field
                            var newSignature = $('#cb_sign_wrapper_edit .output').value;
                            if( $('#EditRecord' + signatureFields[0])[0]){
                                $('#EditRecord' + signatureFields[0])[0].value = newSignature;
                            if( $('#InsertRecord' + signatureFields[0])[0]){
                                $('#InsertRecord' + signatureFields[0])[0].value = newSignature;

                            // Capture each signature image into its corresponding [hidden] VIRTUAL field
                            var api = $($('#cb_sign_wrapper_edit .sigPad')).signaturePad({ drawOnly: true });
                            if (api)
                                $('#' + signatureFields[2]).val(api.getSignatureImage());

    <!-- Footer code end -->




  14. If you have updated your DataPages to use the subdomain for your account in the deploy code, the logout link now uses the account subdomain for your account. Rather than b5.caspio.com/folderlogout try ******.caspio.com/folderlogout where ****** is your Also, see: https://howto.caspio.com/deployment/caspio-site-vs-account-subdomain-deployment/ Hope this helps
  15. Chad did an amazing job helping us get the Auto Tab accurate. He was quick, professional and precise. He even helped us with a work around for our barcode scanning needs.

    1. LWSChad


      Thanks Jay, It was a pleasure working with you.

  • Create New...