Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

Reputation Activity

  1. Like
    Leon13 reacted to SinJunYoung in Change color of the column in chart   
    Hello, you can also try getting the nth child but will be a static change of color display. But since the chart will always return the blank in the first line, we can always modify the 1st one to be set as orange. Try pasting this to the header as well:
    rect.highcharts-point.highcharts-color-0:nth-child(1) {
        fill: #ffd3a8;
    If you want  to also apply different colors to the other values, change the bold number to any desired  displayed number  and it should work as expected. 
  2. Like
    Leon13 reacted to Alison in Change color of the column in chart   

    Hi can I change the  color of the column in chart for the blank values. For example, I want the color of the first column (blank) to be color red
  3. Like
    Leon13 reacted to vanderLeest in Align field names and field values in an auto-email as in a table   
    I would like to format the auto-email on submit of an update form as neatly aligned table
    Vendor Number
    Invoice Number
    Current Date
    Total Amount
    (fixed “USD”)
    SES Number
    PO Number
    How can I make this happen?
  4. Like
    Leon13 reacted to LittleMsGinger in Hide entire datapage when report has no records found   
    Hi @Leon13,
    You may remove the open and close symbol "<>" and insert "&nbsp;" instead. 

  5. Like
    Leon13 reacted to kpcollier in Webpage refresh forced upon clicking "update" button in Tabular Report   
    I believe this is what you need:
    <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { location.reload(); }); </script>  
  6. Like
    Leon13 reacted to Hastur in Expand both options   
    I think that the best approach is to let your users to either expand all the groups or use the default option.
    To make it works, you need to add this code to the Footer of the Result set:
    <script type="text/javascript"> function customClick() { var elems = document.getElementsByClassName('cbResultSetShowHideGroupText'); for(let i = 0; i < elems.length; i++) { if(elems[i].children[0].alt === "expand icon") { elems[i].click(); } } } function assignEvent() { document.getElementById('expandAll').addEventListener('click', customClick); document.removeEventListener('DataPageReady', assignEvent); } document.addEventListener('DataPageReady', assignEvent); </script> And this code to the Header of the result set:
    <button id="expandAll">Expand All</button> Please note that you need to disable the HTML editor of the Header/Footer. You can make this in the Advanced section.
  7. Like
    Leon13 got a reaction from kpcollier in Webpage refresh forced upon clicking "update" button in Tabular Report   
    Thank you @kpcollier !!  :)   Worked like a charm.  Greatly appreciate your help!
  8. Like
    Leon13 reacted to BethShaffer in Different Header Information When Search Returns No Results   
    Ha! I got this working.  I missed the step of having to name the ID for the No Results Message in Localizations.  If someone else needs to change the header message when no results are found, this is how.  I found some clues using this online help page, https://howto.caspio.com/integration/map-mashup/hiding-the-map-when-no-results-are-found/
    Go to Localizations and choose the language you're using, and go to #351 No Records Found. Add a custom message if there isn't already one, and put a div tag around it with an ID, mine is "norecord" for this example. Then add another div tag around the header content you want to change and also give it an ID, ID="HOW" for this example. Then add this code to the footer of your Configure Results Page Fields: Match whatever names you give the respective fields to the IDs in the code below. <script type="text/javascript"> if (document.getElementById("norecord")) { document.getElementById("HOW").innerHTML = "THE NEW CONTENT YOU WANT DISPLAYED WHEN THERE ARE NO RECORDS"; } </script> This new content will overwrite whatever content is in the <div> named HOW when the search returns no results.  If you're adding HTML to the new content, you need to escape all your quotes or it won't work.  I made that mistake.  In a link example, it would be:
    <a href=\"http://mywebsite.com\">Visit my website!</a>  
  • Create New...