Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

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

pmcfarlain's Achievements

  1. This is the record index for a tabular report. I enabled it on the Results Page Options screen here.
  2. How can I change the color of the header for the record index?
  3. I want a calculated field formula that can return the date in MM/DD/YYYY format. How can I get this?
  4. 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
  5. 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.
  6. Whoops my bad! That worked thanks a bunch!
  7. 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).
  8. 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?
  9. 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!
  10. 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.
  11. 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!
  12. 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?
  13. I want to set the default search value for one of my Tabular reports to be today's date + 7 days. When I set the default value today, I usually tell it to receive [@cbTimestamp*] on load but I don't see how I would make it today + 7 days. Any ideas?
  • Create New...