Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Roosta last won the day on December 20 2019

Roosta had the most liked content!

About Roosta

  • Rank

Recent Profile Visitors

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

  1. @astroboy Thanks for the suggestion but we have gone a different path using Caspios API to extract the data from the relevant tables and produce our own PDF reports outside of the Caspio system given its limitations. Kind regards, Roosta
  2. Hello all, I am using several datapages embedded using iFrames into a single datapage to produce an output for a customised PDF with has worked well when using a single parameter however I need to be able to use multiple parameters in a field, to explain. Say I have a column that contains engineers unique ID's in a format ENGID-4, ENGID-413, ENGID- 512 etc I am using a datatpage to search records with a multi-select list box which I want to pass the searched parameters to this datapage when a button is clicked. I have a hiddin virtual field which converts the output of the search fie
  3. Hi @Shiro No I have solved this but can't post a screenshot of the trigger solution due to attachement restrictions (2mb total for account) but thanks for asking much appreciated. Cheers, Roosta.
  4. Well I was going to post an image of the working solution but apprently I have now reached the 2mb limit of my account attachements and the only workaround according to Caspio support is to create another account... even if you delete attachments from old posts they remain in your profile and cannot be deleted . My apologies if anyone was looking for a similar solution! Cheers, Roosta Heres a transcript fro support for those who are interested; Hello I was just chatting with Jojo and the chat timed out while I was waiting for an answer? Me Hello, I'm
  5. Hi all, Nope this didn't work I was mistaken...! "Never mind got it to work was overthinking it solution is below;" Cheers, Roosta
  6. Hello all, I have been looking at the loop function in triggered actions and would like to use it for sending an email to all contacts for a specified customer, I have a submission form with a field where a customer can be selected and an option to email individual contacts (have that working fine) and another dropdown that can be selected to "Email all". I have tried to create a loop with limited success by that I mean it sends the email to the selected contacts ok but sends it multiple times to the same contacts for however many records there are in the contacts table example below;
  7. Hi all, Not to worry figured it out using pass vaule on exit in search field then inserting that into the header and works for my purposes wothout having to utilise javascript. Cheers, Roosta
  8. Hi all, Well came up with a solution (off sorts!) for the Pivot table not deisplaying colors in the PDF genrator using the code below; <script> document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(4), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(4)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(6), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-
  9. Hi @AllMight and @LittleMsGinger I am trying to do something similar to this only with the values from the search fields in a pivot table to be displayed in the header, unfortunately in pivot tables you can't use HTML blocks so are restricted to using the Header/Footer for any code. I want to do this so when a PDF of the results table is printed using the Caspio download options it gives some context to the results for the user e.g. Name of person searched for, date range searched etc, etc as currently you can only use Authetication Fields, APP and System parameters in the PDF genera
  10. hi @Nuke354 Well I thought I's solved it, not pretty but thought I had,,,, <script> document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(5)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green' }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(5)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(8)`).forEach(function(elem) { if(elem.i
  11. Hi @Nuke354 I found a partial solution which I modified slightly for the columns being the same color on the pivot table in an old post using this in the header; <style> #target table:nth-of-type(1) td:nth-of-type(3) {color: white;} #target table:nth-of-type(1) td:nth-of-type(3) {background: green;} #target table:nth-of-type(1) td:nth-of-type(5) {color: white;} #target table:nth-of-type(1) td:nth-of-type(5) {background: limegreen;} #target table:nth-of-type(1) td:nth-of-type(7) {color: white;} #target table:nth-of-type(1) td:nth-of-type(7) {background: gold;} #target table:nth-
  12. Hi @Nuke354 Unfortunately this method does not appear to work in pivot tables only tabular reports unless I am doing something wrong, I have tied inserting into the footer as you can't put html blocks in pivot tables to deploy code in this manner; I did have some limited success using the following in the footer; <script> document.querySelectorAll(`[action*="[@cbAppKey]"] .cbResultSetCalculatedField`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; else if(elem.innerHTML== "50 %") elem.
  13. Hi @Nuke354 Thank you for the reply its much appreciated but I don't quite understand how I can use that code alone for calculated fields without setting the "isi" variable as per the code above; var isi = document.getElementById('visi[@field:ID]').parentNode.parentNode; I am very unfamiliar with this type of syntax/use so any help would be appreciated, I have tried using just the line of code you suggested in the above and omitting the getElementById but it doesn't work. I ran into a similar problem with a different pivot table where I wanted to change the colors of certain
  14. Hi @Nuke354 Is it possible to do this with calulcated columns/fields in pivot tables doesn't necessarily have to have a value criteria just want certain columns to have a set background color and they are calculated fields? For example: Pass = Dark green Pass (advisory) = Light green Improvement = Yellow Fail (supervision) = Light red Fail (immediate) = Dark red Kind regards, Roosta
  15. Hi @NiceDuck Where did you get those figures from as it doesn't state this in the pricing schedule for basic plans https://www.caspio.com/pricing/basic-plans/ in fact Triggered actions doesn't state a monthly or daily limit at all only Notification Emails, SMS, Import Update, Scheduled Tasks and REST API have a stated monthly limit?
  • Create New...