Jump to content

Benades

Caspio Ninja
  • Posts

    32
  • Joined

  • Last visited

Everything posted by Benades

  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.
  14. Thanks for the reply @TellMeWhy, However not working on my side. The blocks should be much longer and not compressed. Is it because I am removing the classes out of it's environment thus it cannot call the appropriate classes for the correct display? When I only take the HTML that displays the actual number the whole structure of the card is displaying correctly.
  15. Hi, I am trying to embed multiple calculated fields in my HTML Block with the website raw HTML code, but it changes the structure and look which is not desirable. Could someone please troubleshoot for me where I'm going wrong? What it should look like: (This is with individual datapages embedded in each block) What it comes out as: (When I try to combine all of it in one datapage) Here is the original HTML: <div class="container-fluid"> <div class="d-sm-flex justify-content-between align-items-center mb-4"> <h3 class="text-dark mb-0">Dashboard</h3><a class="btn btn-primary btn-sm d-none d-sm-inline-block" role="button" href="#"><i class="fas fa-download fa-sm text-white-50"></i>&nbsp;Generate Report</a> </div> <div class="row"> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-primary py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-primary font-weight-bold text-xs mb-1"><span>Earnings (monthly)</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>$100,00</span></div> </div> <div class="col-auto"><i class="fas fa-calendar fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <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>$215,000</span></div> </div> <div class="col-auto"><i class="fas fa-dollar-sign fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-info py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-info font-weight-bold text-xs mb-1"><span>Tasks</span></div> <div class="row no-gutters align-items-center"> <div class="col-auto"> <div class="text-dark font-weight-bold h5 mb-0 mr-3"><span>50%</span></div> </div> <div class="col"> <div class="progress progress-sm"> <div class="progress-bar bg-info" aria-valuenow="50" aria-valuemin="0" aria-valuemax="100" style="width: 50%;"><span class="sr-only">50%</span></div> </div> </div> </div> </div> <div class="col-auto"><i class="fas fa-clipboard-list fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-warning py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-warning font-weight-bold text-xs mb-1"><span>Pending Requests</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>18</span></div> </div> <div class="col-auto"><i class="fas fa-comments fa-2x text-gray-300"></i></div> </div> </div> </div> </div> </div> </div> And here is the HTML in my HTML Block in a Datapage: (HTML Block 2 has 4x </div> to hide the calculated fields) <div class="container-fluid"> <div class="d-sm-flex justify-content-between align-items-center mb-4"> <h3 class="text-dark mb-0">Dashboard</h3> </div> <div class="row"> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-warning py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-warning font-weight-bold text-xs mb-1"><span>Trade Growth</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>[@calcfield:1#]%</span></div> </div> <div class="col-auto"><i class="fas fa-database fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-warning py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-warning font-weight-bold text-xs mb-1"><span>Average Growth</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>[@calcfield:2#]%</span></div> </div> <div class="col-auto"><i class="fas fa-wave-square fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-warning py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-warning font-weight-bold text-xs mb-1"><span>Last 7 days</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>[@calcfield:3#]%</span></div> </div> <div class="col-auto"><i class="fas fa-sort-amount-down fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-warning py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-warning font-weight-bold text-xs mb-1"><span>Previous Trade</span></div> <div class="text-dark font-weight-bold h5 mb-0"><span>[@calcfield:4#]%</span></div> </div> <div class="col-auto"><i class="fas fa-backward fa-2x text-gray-300"></i></div> </div> </div> </div> </div> <div style="display:none;"><div>
  16. Benades

    Referral Link

    Hi, I need to create a typical referral link when followed it would auto complete a field (Referrer ID) in a registration form. All the examples I've seen talk about passing parameters from one form to another without being seen where in my case I need it displayed as text (or URL). Thanks for the input
  17. At the end the above did not worked for me but what I did was to create a HTML Datapage to retrieve the numerical value and pass it through which worked for some reason.
  18. Thanks for your reply @TellMeWhy, However I have done exactly as your instructions but with no positive results. Please see screenshots below of code implementation and result: The code: <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-info py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-info font-weight-bold text-xs mb-1"><span>Return of Investment</span></div> <div class="row no-gutters align-items-center"> <div class="col-auto"> <div class="text-dark font-weight-bold h5 mb-0 mr-3"><span><script type="text/javascript" src="https://c1dcn529.caspio.com/dp/75db9000ce3b16e37cda43bca9b2/emb"></script></span></div> </div> <div class="col"> <script type="text/javascript" src="https://c1dcn529.caspio.com/dp/75db90006ceb67424966473c86ad/emb"></script> </div> </div> </div> <div class="col-auto"><i class="fas fa-exchange-alt fa-2x text-gray-300"></i></div> </div> </div> </div> </div> The result:
  19. I am trying to apply my caspio datapage to a website template which has a progress bar. I have successfully displayed the value (42%) via a HTML Block in a datapage but I'm stuck on how to change the width of the progress bar to the same value dynamically. <div class="col-md-6 col-xl-3 mb-4"> <div class="card shadow border-left-info py-2"> <div class="card-body"> <div class="row align-items-center no-gutters"> <div class="col mr-2"> <div class="text-uppercase text-info font-weight-bold text-xs mb-1"><span>Return of Investment</span></div> <div class="row no-gutters align-items-center"> <div class="col-auto"> <div class="text-dark font-weight-bold h5 mb-0 mr-3"><span><script type="text/javascript" src="https://c1dcn529.caspio.com/dp/75db9000ce3b16e37cda43bca9b2/emb"></script></span></div> </div> <div class="col"> <div class="progress progress-sm"> <div class="progress-bar bg-info" aria-valuenow="50" aria-valuemin="0" aria-valuemax="100" style="width: 90%;"><span class="sr-only">50%</span></div> </div> </div> </div> </div> <div class="col-auto"><i class="fas fa-clipboard-list fa-2x text-gray-300"></i></div> </div> </div> </div> </div> Above is the relevant code used. I have tried to simply paste the deployment code in 'width:' with no success. How can I pass the same value to the progress bar? Below is a screenshot of the HTML Block
  20. Hi @LittleMsGinger, How do I go about doing this? I have implemented the formula in a Calculated field in a Datapage but I also need it inside the table because it needs to be called from other tables. So how do I setup a trigger to fetch that result or even better to calculate itself?
  21. @KweenYasmin The QR code is above a submission form. The QR code should be generated from table entries. After the scanning of the QR code the user should perform the task and then provide the info in the submission form below the QR code.
  22. Ok so that is the question, can someone assist in this?
  23. @TellMeWhy That is exactly what I want to to. So which parameter should I pass? The Column name? also how do I Specify to choose the one not ticked / or ticked
×
×
  • Create New...