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 Jojo, thank you for contacting Caspio. Jojo Hello Jojo My chat timed out waiting for a response from you on attachements in the forum Me Welcome back. Jojo Thank you Me I have coordinated this with our internal team. And I'm sorry to inform you that we don't have the ability to increase the limit due to security reasons. I hope you understand. Jojo Can't some of the existing attachements be deleted? Me The other option will be creating a dummy account to post a new article. Jojo Seems pretty poor that I can no longer post any attachments for help or to help others.... And no I don't understantd "security" being used as a reason to be honest... Me I think it also won't let you to delete it because it will also remove from the previous post attachment. Jojo I could understand a limit of size per/item or post but not such a small limit of 2mb per account? Me As per our internal team, we highly recommend that you attached images only so it won't consume much space. Jojo I have only attached images just a lot of them as its the only way to explain with a visual interface most of the time Such as triggered actions Never mind I will just post I can't compete the thread or solution due to system restrictions of 2mb Me I'm afraid that there is nothing we can do about this limit in your account. What I can do is inform our product team and request to remove or extend the limit but I cannot promise you that they will implement it. For workaround, please create another account to post a new topic or article. Jojo Just seems a bit counterintuative you want people to discuss issues and help each other for solutions with your system then restrict them from doing so effectively... Me I understand your frustration but that is how the system is being designed due to security reasons. Jojo Fine as said will post the information you have given me so others are aware thanks for your help Me Okay, thank you for understanding. Is there anything else I can assist you with? Jojo No thats fine thanks have a good weekend Me Thank you for contacting us. Please do not hesitate to contact us again if there is anything further we can assist you with. You can also reach us at (650) 691-0900. Have a great day!
  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; # So say there are a total of 100 contacts in the contacts table but only 2 contacts for the selected customer those 2 contacts get the same email 100 times (not ideal!) so I am guessing some kind of counter is going to be needed to count the number of contacts for the selected customer and ensure the contact/s are only sent the email once. However, I am not very familiar with this particular function and the Caspio online help doesn't have a great deal of information on the loop function that I can find. I am hoping someone has used it for something similar and will be willing to share how they achieved that, thanks for reading and any help will be greatly appreciated. Kind regards, Roosta
  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-child(6)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'limegreen'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(8), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(8)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'gold'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(10), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(10)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(12), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(12)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'darkred'; }) </script> Which gives this in the PDF output; Not terribly efficient I know put I think the problem was using; document.querySelectorAll(`[action*="[@cbAppKey]"] Which didn't specifically target the columns/rows that I needed to alter the Style of , hopefully this will be of some use to anyone trying to do something similar in a pivot table! Cheers, Roosta.
  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 generator headers & Footers and can't display any of the search field criteria such as below; Datapage view; PDF Generator result; Have tried variations of getelementbyID such as; <html> <body> <p id="d1"></p> <script> function check() { var x = document.getElementById("Value6_1").value; document.getElementById("d1").innerHTML = x; } document.getElementById("searchID").onclick=check; </script> </body> </html> With "Value6_1" being the ID of the Date field "from" in a date search from/to criteria but without success and any help or suggestions that point me in the right direction would be appreciated! Kind regards, Roosta
  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.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(8)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(11)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(11)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(14)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(14)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) </script> Which gave me this in a preview of the pivot table: Great I thought should print on the PDF now but when printed got this; I have absolutely no idea why it doesn't print in the PDF but shows in the preview (which when using JS to manipulate it via CSS it doesn't) it would appear that pivot tables just don't behave in the same way as tabular results tables! Unfortunately as you can't inset HTML blocks in pivot tables the methods used in tabular reports for checnging colors using a unique row ID and a varible can't be used, also in the header/footer you can't select data fields only authentication fields so if [@field:xxxxxx] etc isn't an option either hence the hack above! Oh well back to the drawing board any suggestions gratefully recieved would be much esier if Caspio had conditional formatting as a native option for the data fields... Cheers, Roosta
  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-of-type(1) td:nth-of-type(9) {color: white;} #target table:nth-of-type(1) td:nth-of-type(9) {background: red;} #target table:nth-of-type(1) td:nth-of-type(11) {color: white;} #target table:nth-of-type(1) td:nth-of-type(11) {background: darkred;} </style> <div id="target"> and a closing </div> in the footer which gives me; Still working on somethin to replace the CSS manipulation with a style change if anyone has any ideas? Cheers, Roosta
  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.style.color = "white", elem.style.backgroundColor = 'red'; }) </script> Which gives; However it utileses innerHTML with spevified values and I cannot figure out how to apply to a single column where I could use just one color for a column or criteria for that column only such as 100 % else etc, etc. Thanks for responding, Roosta
  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 cells with a % in them and ended up doing it via the css when the page is deployed using on my website by inseting the following code in the footer; <script> $("table.cbResultSetTable tbody tr.cbResultSetOddRow, table.cbResultSetTable tbody tr.cbResultSetEvenRow").each( function (x) { $(this).children().each( function(){ if ($(this).text().indexOf("%") != -1){ if ($(this).text() == "100 %"){ $(this).css("color", "white").css("background","green") } else { $(this).css("color", "white").css("background","red") } } } ) } ) </script> Which gives this result; However the only problem is using this method is the actual background color is not altered so when using the Capios PDF function the CSS style changes are not printed would a similar soultion be possible using the methods above as well? The printed output to PDF comes out like this; Many thanks, Roosta
  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 questions; What are you trying to build How is it going to be deployed How familiar are you with relational databases and structure Do you have any coding skills such as JS/HTML/CSS Is the system you are building be integrated with other systems such as mobile applications using REST There are many more questions I could ask but these seem the most relevant to begin with, I am by no means a professional coder/programmer but have had extensive experience with MS Access and Visual Basic in the past and these skills helped. You need to set objectives e.g. what do I want this datapage to do and how am I going to deploy it, what user interactions will be required etc, then if you need help trawl the forums and see if anyone else has had similar problems and there are plenty of people here who are willing to help (I have only been using the forum a short time but found it invaluable as much for seeing what can't be done and looking at solving it in a different way!) You could always use Caspios "Expert Sessions" add-on; However its not cheap and I would advise if you go down that route you have a good idea of what it is your trying to accomplish before booking a session/s Failing that you can try Caspios "Professional Services" we have used them for a project that I didn't have time to learn how to implement myself, again not a cheap option but they are a good team of people and will get you where you need to be if its a business critical function that you need to implement reasonably quickly. Sorry for not having a definitive answer but you asked a pretty broad question with little to no information of what your trying to achieve, how you have tried to implement it and how far you need to go. Kind regards, Roosta.
  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 = 5) it will space them to overcome this I either used columns of 1 or 5 and if required less then 5 used 1 and had the elements continue on the same line. Your other option would be to build a full HTML table within the HTML block something similar to this; <style> .wrapper { background-color: lightgray; padding: 5px; } td { padding: 10px; } </style> <table border="0" cellpadding="1" cellspacing="1" style="width:100%;"> <tbody> <tr> <td><strong>Some Data 1</strong></td> <td><strong>Some Data 2</strong></td> <td><strong>Some Data 3</strong></td> </tr> <tr> <td class="wrapper">[@field:Some_Data_1]</td> <td class="wrapper">[@field:Some_Data_2]</td> <td class="wrapper">[@field:Some_Data_3]</td> </tr> <tr> <td><strong>Some Data 4</strong></td> <td><strong>Some Data 5</strong></td> <td><strong>Some Data 6</strong></td> </tr> <tr> <td class="wrapper">[@field:Some_Data_4]</td> <td class="wrapper">[@field:Some_Data_5]</td> <td class="wrapper">[@field:Some_Data_6]</td> </tr> </tbody> </table> Which would result in something like; Again you would have to experiment with layout to match the rest of your form/fields but may be a possible solution but without seeing exactly what you want as an end result its a bit hard to offer any further advise. Good luck, Roosta
  • Create New...