Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by TellMeWhy

  1. try this one inside the for loop, it seems that !important does not work there elems[i].style.setProperty("background-color", "yellow", "important");
  2. I tried putting the Script in the WebPage instead, and this is what I got
  3. Not sure if you can do it directly on Caspio, but there are third party integrations you can try https://zapier.com/apps/caspio-cloud-database/integrations/stripe https://www.integromat.com/en/integrations/caspio/stripe
  4. Try "yellow !important" , also try the loop one, that's what goes through all the td, that one is for a single td (column)
  5. Does that not work? That's how you add AND operator, seems correct.
  6. does "yellow !important" not work? It probably wont, I guess, since that's applying background color to tr instead of td, try the method I gave you on the other post where all font colors become red, try changing style.color to backgroundColor and see if it prioritizes the script's color
  7. Oh, then it's much simpler, just replace 1 to what number of column that is, add another line if you want to set font color for another one, then set the column number isi.parentNode.parentNode.querySelector("td:nth-child(1)").style.color="red";
  8. Ah, I see, it seems that changing the row's font color does not work, you woul have to change each cell individually, try adding this, just below the backgroundcolor code, still inside the if (or else if you're putting it there) var elems = isi.parentNode.parentNode.querySelectorAll("td"); for (var i=0;i < elems.length;i++){ elems[i].style.color="red"; } What this does is select all the td in that specific row, then apply red font color to each one
  9. The others are putting the embedded websites in an iframe container, this prevents the forms from passing the parameters. You can deploy it as iframe, however, it will act independently from the webpage, it will redirect on the iframe only and not the page. Weebly and WordPress does not use these iframe container, I believe Weebly CMS does, but Weebly Website Builder doesn't, I'm not sure. For the Phone Formatting, Caspio's form are extremely simple, but, I guess this is a good feature to do since there are a lot of sources that has the phone formatting for each country anyway. You can create one yourself, tho, through Virtual Fields, your users would just have to input their numbers part by part, and then you can append everything, add the special characters, etc., on the actual field (set it to Calculated Value) OR use JavaScript
  10. I think you're just missing quotation? This worked perfectly on mine even on different dates if('[@field:Date*]' < '[@cbTimestamp*]'){
  11. You can convert it to TEXT 'CC'+CONVERT(VARCHAR, (SELECT MAX(Clean_Job) FROM tbl_ggl_job WHERE Job_Letter = 'CC') + 1)) Double check the parenthesis if it's the correct amount
  12. Here's a sample Child Table MUST HAVE a unique ID, you'll see why. First Part of the Trigger This is for inserting to PARENT Table Names that DO NOT EXIST yet on the Parent Table 1.) Set a VARIABLE, Select from the Child Table, and Inner Join with the #inserted, or vice versa so we can use both fields in the WHERE. Important here is to select Expression on the fields, then append the aggregation block (COUNT/SUM, ETC) use WHERE so you'll only SUM the Name in the Child Table that is the same as the #inserted 2.) Select From WHERE NOT EXISTS, select the field you want to check, in this case I want to check the Parent Table's Name Field, and then I'll check for values that are equal to #inserted.Name If it does not exist, it will proceed with inserting the values I've set 3.) For Total Allowance, I'll check first if it's not a number (because the sum can be a NULL), if it's not, I will output 0, else, the SUM. Then, you'll add the #inserted.Allowance, that's only named Allowance because you're already Selecting From #inserted in the Insert Into Block. Check if it's not blank, if it's not, get the value, else 0. 2nd Part just below the Insert Into Block What this does is UPDATE the values that are in the Parent Table. 1.) Inner Join with #inserted.Name then parent.Name 2.) Use Case When, same concept as the one in the INSERT INTO. In this case, the WHERE checks if the Child.Name that is getting summed up is equal to the Parent.Name. We're also excluding the Child ID that's being updated from that SUM (#inserted.Child_ID not equal to Child.Child_ID) because we're ADDING the NEW VALUE instead This looks complicated, but, it's actually not.
  13. It's pretty easy, just add ELSE on the code and use auto submit <script type="text/javascript"> document.addEventListener("DataPageReady", function tester(){ if(document.getElementById("errormessage")){ window.location.href = "https://www.google.com"; } else{ setTimeout('document.forms["caspioform"].submit()',1000); } }); </script> In my code I removed the display none, but, you can include that since you wouldn't want your users to be seeing that anyway, you can also reduce the 1000 delay to a faster one, but I think that's fast enough and if you have display none, it will be alright.
  14. Yeah, you actually can, but, I found that it's better to create your own element with a unique ID so you can reference the ID instead of the class I have then added an HTML Block in the authentication fields, and NOT the footer because footer and header code gets removed when the Failure Message appears, apparently. <script type="text/javascript"> document.addEventListener("DataPageReady", function tester(){ if(document.getElementById("errormessage")){ window.location.href = "https://www.google.com"; } }); </script>
  15. It might be better to use Dropdown or Radio button for the On Hold Field so you get Yes, No, and Any option. If you want to use checkbox, you'll have to use this option There would be no way to display all records regardless if it's On Hold or Not, though.
  16. I've tested this and it should work, it thought it was the datediff formula, but it's still working on mine. I've refreshed your page and it seems to be working now, try changing the color for the ELSE part
  17. Hmm, can you screenshot your HTML Block code? Screenshot your calculated field as well
  18. You only need 1 HTML Block <div id="visi[@field:Report_ID]"> [@calcfield:1]</div> <script> var isi = document.getElementById("visi[@field:Report_ID]"); if([@calcfield:1#] > 47){ isi.parentNode.parentNode.style.backgroundColor = 'red'; //background color isi.style.color="yellow"; //font color } else{ isi.parentNode.parentNode.style.backgroundColor = '#NoColor'; } </script> You need to use UNIQUE Field for the id, my unique field is Report_ID You can also insert the calc field in the div already, and then just change the font color base on the conditions.
  19. You need to follow the steps (The last one), it should be in an HTML block instead of including the actual field
  20. Weirdly enough, I checked the value for Virtual Checkbox and it always comes up as "Y" that's probably why the two statements are working. Maybe try just a text field instead since this is gonna be hidden anyway, I suppose?
  21. Well, you can still use that, and use this howto workflow https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ you can have a virtual field that is set to On Load the domain of the page they're in so example facebook, then, they should be redirected to the facebook page where the results page is deployed. If google, then they'll get redirected to google page where the results are deployed
  22. instantaneously means it should be an API setup, and this will consume A LOT of API calls if you want to push through with the real time notification since it should check/get data from the table if a new message is created or not
  23. You can also use F12 > click on the cursor thingy > click on the element that you want to change the style and you should be able to see what class it belongs to Go to Styles > Source > All, press ctrl + f and input the class there
  24. Hmm, have you tried other browsers? You can also check F12 > Console if there are any errors when it encounters issues, it only changes values, so it should not come across issues that often
  25. Ah, it's Calendar, so it should work the same as this https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/ You need to use a unique field for the ID, just append different text for different elements Here's an example:
  • Create New...