Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by pmcfarlain

  1. That's great, thank you! Do you know a way to align the results? I want the numbers to be in a column like they would on a tabular report. These are calculated fields.
  2. I'd like to make the format of my list report look nicer, how can I do this? Specifically, I'd like to be able to highlight every other row of data (not data cell) and align the labels and the data so that they are directly underneath each other. Edit: Additionally, it would be nice if I could have conditional formatting on the data so that if it is below the goal, the text turns red and if it's at or above the goal the text turns green. The data cells are using calculated fields. Is there a way I can do this conditional formatting in an HTML block that references the calculated field?
  3. Great, thanks!
  4. I'd like to make the label on my datapage display the current month. Is there a way I can do that?
  5. That works on my end too. I do have another file called "Engineering Report [short date]" that works fine but with Customer Report it freaks out for some reason. Thanks for the help!
  6. Ok after rebuilding and testing, I've figured out that it's the short date I have tacked on to the end of the file name that is messing things up. No clue why. I have another report with the same name format that works fine...
  7. Yep, tried to duplicate it. I've got a support ticket open rn. Currently debating whether I should rebuild an identical datapage from scratch.
  8. Here is the deployed datapage link: https://c1dcs476.caspio.com/dp/66ca90000d1775aed9144fc79760 I am downloading the XML file to open in excel but it corrupts every time
  9. Ok in addition to that though the file that fully downloads on other computers is corrupting. On Mac I got the error above and on windows I got this error.
  10. I'm having issues downloading xml files from Caspio on some Windows computers. Once I go through the whole keep -> save as song and dance, it converts the file to a .crdownload and refuses to open with excel (corrupts or has other errors) 9 times out of 10. Any ideas on how to fix this? Edit: Having a similar error on Mac but without the .crdownload. This file specifically is coming up with this error when I try to open it.
  11. I want to change the layout of my pivot table. Right now it looks like the column headers are aligned to the left while the data fields are aligned to the right, which looks bad. how can I change this?
  12. This is the record index for a tabular report. I enabled it on the Results Page Options screen here.
  13. How can I change the color of the header for the record index?
  14. I want a calculated field formula that can return the date in MM/DD/YYYY format. How can I get this?
  15. Here's the code that I inserted for the vertical headers: <style> .cbResultSetLabel:nth-child(10)> .cbResultSetLabelLink { writing-mode:vertical-rl; -ms-transform: rotate(270deg); //Internet Explorer -webkit-transform: rotate(180deg); //Chromium -moz-transform: rotate(180deg) ; //mozilla transform: rotate(180deg); } .cbResultSetLabel:nth-child(11)> .cbResultSetLabelLink { writing-mode:vertical-rl; -ms-transform: rotate(270deg); //Internet Explorer -webkit-transform: rotate(180deg); //Chromium -moz-transform: rotate(180deg) ; //mozilla transform: rotate(180deg); } </style> And here's a link to the datapage with test data: https://c1dcs476.caspio.com/dp/66ca900009e81648775c46438abb
  16. Testing this on chrome with an ipad, for some reason it crushes the tab. Is there a way I could perhaps set the width so it doesn't do this? Here's what is looks like on the ipad: Also I'd like the words to face the opposite direction if possible but I couldn't figure out how to change it.
  17. Whoops my bad! That worked thanks a bunch!
  18. Same result from this: SELECT MAX(Clean_Serial_Number) FROM tbl_ggl_job_lines WHERE Job_ID = tbl_ggl_job_lines.[@field:Job_ID] This is a submission form datapage. The job ID passes as a parameter from a previous page. Job ID is displayed as a non-editable field. This calculated value is just meant to show the person submitting the form what the max serial number is so they can use the next one (if the max is 1, the user should input 2 into the Serial Number submission field).
  19. I have a calculated field in my datapage to find the biggest "Clean_Serial_Number" under a particular Job_ID. There are many serial numbers under each job so I want it to find the max serial number under JUST that job. Right now, this field is just displaying the max "Clean_Serial_Number" from all the data, not just from the Job_ID. SELECT MAX(Clean_Serial_Number) FROM tbl_ggl_job_lines WHERE Job_ID = [@field:Job_ID] What am I doing wrong?
  20. I want to set up a formula field that can check if a value is an int and if so convert it to an int. How can I verify if a value is an int in the formula is an int? Here's what I tried: CASE WHEN ISNUMERIC(RIGHT([@field:Serial_Number], 2)) THEN CONVERT(INT, (RIGHT([@field:Serial_Number], 2))) END Any help would be appreciated thanks!
  21. I have a page set to default grid edit and the users are editing a different field but I have a description field on-screen for reference. It takes up a lot of space so I'd like to be able to truncate it.
  22. I have some tables that go off of the screen on my website but no scroll bar pops up so there's no way to see the full table. This happens when I embed the table into my wordpress page. Anyone know how to fix this? Thanks!
  23. I have a field that is set to truncate at 50 characters but when I enter grid edit it no longer truncates. Caspio support told me this is the expected result. Anyone know of work-arounds for this?
  • Create New...