Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi there, I need to create a trigger that sums different column values per user. I have multiple users on a table (below) and would like to on another table insert sum the number values of each a_user per column and insert it into another table as a combined history. ie user1: 106 | 60 | 73 user3: 96 | 45 | 71
  2. Thanks @TellMeWhy, Working nicely most of the time. Sometimes it doesn't fetch it but navigating away and back fixes the issue
  3. Hi there, Previously @TellMeWhy helped to display values in a span tag which worked great: <div class="col mr-2"> <div class="text-uppercase text-success font-weight-bold text-xs mb-1"><span>Second Level</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span id="secondlvl"></span></div> </div> <script> window.addEventListener('load', function() { document.querySelector("input[name='cbParamVirtual1']").addEventListener('change', function() { document.getElementById('secondlvl').innerHTML = document.querySelector("span[id^='cbParamVirtual7@Data']").innerHTML; }); }, false); </script> Now I need to do the same to fetch a Virtual field value but then add it to an img tag: <img alt="Virtual17" src="https://chart.googleapis.com/chart?chs=150x150&amp;cht=qr&amp;chl=[@cbParamVirtual17]"/>
  4. @TellMeWhy it works most of the time but there are instances where it does not change and I have to refresh the page multiple time for it to take effect. Any way to get around that?
  5. As always @TellMeWhy, thank you very much. It works as expected
  6. Hi, I managed to change a Stacked Column Chart colors by adding a header and setting a style to it: <style> rect.highcharts-point.highcharts-color-0{ fill: #006B3C; } rect.highcharts-point.highcharts-color-1{ fill: #682861; } rect.highcharts-point.highcharts-color-2{ fill: #CD9B06; } </style> Now I need to do the same with a Stacked Area Chart but cannot find the same heading to apply the color to (highcharts-color-0): When I use the same logic to style, it changes colors for all to the same color because there are no differentiating name: <style> path.highcharts-area{ fill: #CD9B06; } </style>
  7. You are magic! Thanks so much @TellMeWhy
  8. One last question @TellMeWhy if you don't mind; Why is there styling lost? I have set the formatting but none is applied. Is it fetching it before the styling takes place? I cannot style it on the table itself because it's a formula field.
  9. There it is!! Ah thanks!! Ok let me start testing!
  10. I did exactly like you did but still no joy. How did you give the Virtual1 field the value of "test" perhaps there I am messing up?
  11. Would you mind to give me an example on my application please? How do I call for instance the first hidden value of $225.21? This would be the HTML code of the card I'm using: <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-success py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-success font-weight-bold text-xs mb-1"><span>Earnings (annual)</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>$225.21</span></div> </div> <div class="col-auto"><i class="fas fa-dollar-sign fa-2x text-gray-300"></i></div> </div> </div> </div> </div>
  12. Hi @TellMeWhy, Not exactly what I'm looking for because I need to call the calculated from from the page source and not within caspio.
  13. Hi, I noticed that the hidden calculated fields on the Configure Details Page once deployed are visible in the inspect tool: So my question is; is it possible to call those values on the same page via HTML and display them? The reason why I want to do this is to have one big Datapage with all the values and calculations between a display:none div and then call each one in their own spot on the page HTML.
  • Create New...