Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Reputation Activity

  1. Like
    Wernon got a reaction from ManokNaPula in About Triggers   
    Hi, Vanellope!
    as far as I know, it is still not possible to concatenate or somehow add several results to a single email.
    The only solution I found is to create a task, which calculates the number of records that fulfill the conditions and send the email with the number and search criteria.  After just filter the data on the Report and change with "bulk edit" from Caspio Bridge.
    Not sure if it helps you, but here is a short Task for my case:

    Hope it will help you somehow.
  2. Thanks
    Wernon reacted to DefinitelyNot31337 in Generate geolocation from input fields   
    I'm so excited. I found a way to make it work even if AJAX Loading is enabled.
    Luckily, I came across Caspio 13 Impacted Areas and kudos to good guy Caspio making this AJAX Implementation customizable.
    previous post TL:DR? Follow this instead.
    To make this work:
    1.) Gey an API key here. Enable access to your domains (Website, Caspio URL and Integration URL) (You can see the last two in your Caspio Bridge > Account > Account Settings).
    2.) Create/Edit your Submission Form DataPage
    3.) Make sure 'Disable AJAX loading' remains UNCHECKED in the DataPage Data Source Section. (If you want otherwise, refer to my previous post instead.  This is not cross-compatible as of the moment).
    4.) In the Configure Fields section, Add a Header and Footer.
    4.1) Select your header, disable the HTML Editor, paste the code block below, replace y0uR_4P1_k3y_H3r3 with your API Key.
    <script type="text/javascript" src="https://lib.caspio.com/pub/jquery/jquery.js"></script> <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=y0uR_4P1_k3y_H3r3"></script> <div id="cbwrapper">  
    4.2) Select your footer, disable the HTML Editor, paste the code block below, edit the variables to correspond to your table fields.
    </div> <span id="error_message"> </span> <script type='text/javascript'> var lat_id = 'InsertRecordlat'; var lng_id = 'InsertRecordlng'; var address_id = 'InsertRecordAddress'; var city_id = 'InsertRecordCity'; var state_id = 'InsertRecordState'; var zip_id = 'InsertRecordZip'; var wrapper_id = 'cbwrapper'; var msg1 = 'Please input a valid address'; if(typeof jQuery != 'undefined'){ var cb_geocoder = cb_geocoder = new google.maps.Geocoder(); document.addEventListener('BeforeFormSubmit', function (event) { event.preventDefault(); var add = $('#'+address_id).val(); var city = $('#'+city_id).val(); var state = $('#'+state_id).val(); var zip = $('#'+zip_id).val(); if(!add || !city || !state || !zip){ alert(msg1); }else{ var full = add +','+city+','+state+' '+zip; cb_geocoder.geocode({address: full}, cbCallBack); } }); }else{ document.getElementById("error_message").innerHTML = "This Datapage require Standard Caspio Deployment for full functionality." ; } function cbCallBack(locResult){ if(locResult != "" && locResult.length>0){ var lat1 = locResult[0].geometry.location.lat(); var lng1 = locResult[0].geometry.location.lng(); lat1 = Number(lat1); lng1 = Number(lng1); $('#'+lat_id).val(lat1); $('#'+lng_id).val(lng1); $('#'+wrapper_id+' form').submit(); }else{ alert(msg1); } } </script>  
    5.) After saving this, you should be able to make this work.
    Basic Troubleshooting:
    > Check your Console by doing a Right-Click > Inspect in your browser.
    NoApiKeys: You forgot to add your key in the script tag. Google documentation here ReferrerNotAllowed: Check if the domain of your webpage is listed in your Maps API Console (Maps JavaScript API > Credentials > (Key) > Details) There's a bunch of other warnings/errors but I think the first two are the most common and critical. > Feel free to reply to this thread if you encounter problems.
    Note: This is not a full-fledged fix. I know I skipped adding the WebForm AppKey.  Let's just wait for the official Caspio documentation updates.
  • Create New...