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. 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.
  2. 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
  3. Hi all, Nope this didn't work I was mistaken...! "Never mind got it to work was overthinking it solution is below;" Cheers, Roosta
  4. 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;
  5. 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
  6. 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-
  7. 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
  8. 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
  9. 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-
  10. 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.
  11. 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
  12. 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
  13. 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?
  14. Hi @hercules97 To be honest a lot of it is going to depend on your method of deployment, what your trying to accomplish, the end users skill levels (are they familiar with using databases or is this a general public facing application?) and your expectations given that Caspio is ultimately an online relational database for collecting, processing and displaying data/information. We are deploying our system via a self-built website which gives a lot more flexibility with layout and additional code JS/HTML/CSS than say using a website builder such as Weebly or Wordpress. So some qu
  15. Hi @roattw If this is a submission form I assume you mean something like this; Where you can have headings over each section? If so you can split the form up into sections with columns to suit and have HTML block in-between their own sections set at 1 column to span the page like this; This is one column proceeded by the HTML block with the next section containing the submission form fields; You will have to experiment (a lot!) to get decent results and spacing for your whole form as if you start mixing section columns other then 1 and X (in my case X
  • Create New...