Jump to content

Search the Community

Showing results for tags 'table'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






  1. I'd like to set a default record limit of 1000 (or 999 if that's the limit) when I have user selectable enabled. Right now, it defaults to 25 and only lets users select up to 250. How can I change this?
  2. I have a VERY large table and after some number of columns, the vertical headers get out of alignment by a bit. (The date is supposed to be under "FAT Due" and the blank space under "Assembly Due") Here is the code I'm using: <style type="text/css"> [class*="cbResultSetHeaderCell"]{ text-align:center !important; vertical-align:center !important; } .cbResultSetLabel:nth-child(35),.cbResultSetLabel:nth-child(36),.cbResultSetLabel:nth-child(37),.cbResultSetLabel:nth-child(39),.cbResultSetLabel:nth-child(40),.cbResultSetLabel:nth-child(41),.cbResultSetLabel:nth-child(42),.cbResultSetLabel:nth-child(43),.cbResultSetLabel:nth-child(44),.cbResultSetLabel:nth-child(46),.cbResultSetLabel:nth-child(47),.cbResultSetLabel:nth-child(48),.cbResultSetLabel:nth-child(49),.cbResultSetLabel:nth-child(50),.cbResultSetLabel:nth-child(51),.cbResultSetLabel:nth-child(52),.cbResultSetLabel:nth-child(53),.cbResultSetLabel:nth-child(54),.cbResultSetLabel:nth-child(55),.cbResultSetLabel:nth-child(56),.cbResultSetLabel:nth-child(57),.cbResultSetLabel:nth-child(58),.cbResultSetLabel:nth-child(59),.cbResultSetLabel:nth-child(61),.cbResultSetLabel:nth-child(62),.cbResultSetLabel:nth-child(63),.cbResultSetLabel:nth-child(64),.cbResultSetLabel:nth-child(65),.cbResultSetLabel:nth-child(66),.cbResultSetLabel:nth-child(67),.cbResultSetLabel:nth-child(68),.cbResultSetLabel:nth-child(69),.cbResultSetLabel:nth-child(70),.cbResultSetLabel:nth-child(71),.cbResultSetLabel:nth-child(72),.cbResultSetLabel:nth-child(73),.cbResultSetLabel:nth-child(75),.cbResultSetLabel:nth-child(76),.cbResultSetLabel:nth-child(77),.cbResultSetLabel:nth-child(78),.cbResultSetLabel:nth-child(79),.cbResultSetLabel:nth-child(80),.cbResultSetLabel:nth-child(81),.cbResultSetLabel:nth-child(82),.cbResultSetLabel:nth-child(83),.cbResultSetLabel:nth-child(84),.cbResultSetLabel:nth-child(86),.cbResultSetLabel:nth-child(87),.cbResultSetLabel:nth-child(88),.cbResultSetLabel:nth-child(89),.cbResultSetLabel:nth-child(90),.cbResultSetLabel:nth-child(92),.cbResultSetLabel:nth-child(93),.cbResultSetLabel:nth-child(94),.cbResultSetLabel:nth-child(95),.cbResultSetLabel:nth-child(97),.cbResultSetLabel:nth-child(98),.cbResultSetLabel:nth-child(99),.cbResultSetLabel:nth-child(100) { writing-mode:vertical-rl; white-space: pre; transform: rotate(180deg); border:none; } </style> It transforms 60+ columns. Any ideas on how to fix this?
  3. Hello, I am quite new to Caspio and I am not sure if what I want to accomplish is possible. I have a table in which I want to add a new field/column. That new column is going to combine/concatenate few of the other columns in the same table, but I need to use an if logic to complete what I want. I did not see an IF option as a text formula. This is what I have written, but the formula is not correct:
  4. I'd like for file paths in my tabular report to be translated as links so that I can click them and see the related file. Is there a way to do this?
  5. I'm trying to enforce referential integrity with some tables in my app so that I can cascade update/delete records but I keep getting this error: The parent field is an autonumber and the related field is a unique integer. It's a one-to-one relationship with an inner join. Here's the relationship settings. Any ideas?
  6. I need help debugging a trigger. The whole trigger is very big because it's all the actions that need to happen when any data in the table is updated. Trying to avoid too much cascading. But here's what's relevant to my issue: So I have two tables, one for current notes and one for the history of all notes ever added to a job. In my job table, I have a Notes column and a New Notes column which is perpetually blank so that new notes can be added. What this trigger is supposed to do is insert the old note into my history table along with the Job ID and who submitted it. Then, the update should put the new note into the Notes column and empty out the New Notes column. What actually happens is the second part of the trigger works perfectly and adds the new note to the notes column but something goes awry with the first part and it adds 2 new rows to my history table with the note as completely blank and it also changes any pre-existing records with the same Job ID to be blank ???? I am at a loss. Please help!
  7. I'd like to change the height of my rows so that I can show more data on-screen at a time. Is this possible?
  8. I am trying to create a log sheet of sorts that shows the users transaction history. I have the table (as below) showing different transactions debit for income and credit for expenses but I want the balance column to show how the balance is increasing or decreasing as the transactions are coming in. ie User makes a deposit of 1000 and the balance also displays 1000, but next line he has an expense in the Credit column of 100 so balance should reflect 900. The table houses multiple users as seen above so that another users credit or debit doesn't influence other users balances.
  9. i have changed / added / renamed fields in some tables. i have checked the views which use those tables, and have ensured that the changes are reflected in the view (e.g. ensured that 'include all fields' is checked). however, whenever i use a VIEW for a datapage, the 'datasource' fields that are available for record-level security or for lookup tables in dropdown elements show only the old fields and the old field names. the only way to see the correct fields is to use the table as the datasource, but of course that shouldn't be the case. all this is to say, it seems that dropdowns in datapages for lookup tables and record -level security are using cached versions of the original view/table. a screenshot is tough to pull off, but perhaps this example will help: current table fields: field ABC (originally named field AB) field XYZ (not originally in table or view) current view fields (match table, as expected): field ABC field XYZ fields available for dropdowns and record-level security in datapages (does not match table; unexpected behavior): field AB (not field ABC, and not field XYZ)
  10. What I need to do: I have a table with a large amount of data per record. When the user goes to make their daily task (a form that makes a new record) I need them to see the blank form that has yesterdays submission pre-populated in it. The user then merely has to make todays edits and save it. Parameters: 126 x 3 fields need to be brought over to the new daily form, 2 checkboxes and 1 255 Text field. Known Issues: there is a 32k limit on passing external parameters from one datapage to another. What I have tried: Made a Report Details page that can find yesterdays submission and load it all as HIDDEN, then set the fields I want to move to the next Datapage as OnExit Parameters. Current issue is I need to automate the UPDATE button on the report page so users don't have to hit it to continue to the actual submission form. Second issue is that if there is a LOT of entries in that particular record, it can exceed the 32k limit and then a lot of fields get dropped. I would appreciate any ideas on a better method or how to fix the issues.... Steve Fraden
  11. Hello, Is there a way to convert a view into a table? Thanks.
  12. I have two tables. In the top table I have data pulling in to the table using API calls. It currently pulls in the ID number of the location and not the locations Name. I would like the ID number to change to the store location name as soon as it hits the table using the bottom left table that shows the Store name and the ID associated with the name. The bottom right table shows what I would like is to have the top table Page_ID field to be replaced by the ID in the bottom table. The final result would be what the bottom right table would like like. I tried a trigger but I couldn't figure out how to make it work.
  13. Perzival

    MS Plugin

    I integrated my Access DB in Caspio. I'm having an error message that state "Profile is disabled" in my access Database. Can you help?
  14. Hi, I want to create a converter from decimal to HEX format. All the values are saved in the table. So the form should take the decimal number from the table field 1, convert and save the HEX value to field 2. I did not find any SQL solution. I would appreciate any ideas regarding the solution.
  15. I'm struggling getting some CSS correct in a tabular datapage and could use some help. Aggregate rows do not respond to hiding columns in the same way that data rows do when deployed. (See screenshots) In this example, I'm trying to hide three extra cells in the aggregate row. When I preview the datapage it works. When I deploy the datapage, it does not. Note that the first 4 sets of table selectors all work. Here's the CSS in my header element: <style> <!-- WORKS: --> #dashtable table:nth-of-type(1) td:nth-of-type(9) {display: none;} #dashtable table:nth-of-type(1) th:nth-of-type(9) {display: none;} #dashtable table:nth-of-type(1) td:nth-of-type(7) {display: none;} #dashtable table:nth-of-type(1) th:nth-of-type(7) {display: none;} #dashtable table:nth-of-type(1) td:nth-of-type(8) {display: none;} #dashtable table:nth-of-type(1) th:nth-of-type(8) {display: none;} #dashtable table:nth-of-type(1) td:nth-of-type(6) {text-align:center;} #dashtable table:nth-of-type(1) th:nth-of-type(6) {text-align:center;} <!-- PREVIEW WORKS, DOES NOT WORK WHEN DEPLOYED: --> #dashtable .cbResultSetTotalsDataCell {display:none;} </style> <div id="dashtable"> (closing "div" is in footer element. ) Thoughts?
  16. Hi, i have a table. Which is contain 10 training centres. In each training centre there are 7/8 courses. Each course have 4/5 batches. Each batch contain 30 student. There are training_status column in the table where students have different values like pass, fail, not appeared and ongoing. I want to count how many pass, fail, not appeared and ongoing in each batch. It is coming in good way in pivot (since i dont know better reporting format for same) Now i want to add more field in row. Like after getting pass in training candidate got jobs/ placement. And after placement they used to submit proof of placement (Offer letter or Joining letter). They have submitted the proof of working (Payslips and bank statement) for continuous three months . Now i want to count how many candidates got placement out of pass, how many offer letter submitted. How many payslips for first month, second month and third month for batch-wise in a single report which is very easy in excel. But very difficult in caspio. I have shared the screenshot.
  17. Hi, I have a trigger that has been functioning for well close to two months without issue. Suddenly, the trigger is failing to validate or push/delete information to the specified table. Upon review I'm now receiving this error message 2031 "Datasource field is invalid because it's name is absent" is a where clause. This is strange since no changes have been made to the trigger or the tables. The datasource fields are present which is why they are able to be selected. I tried to research the error but it seems to be general in nature. Also, the same datasource fields are being used in a where clause elsewhere in the same trigger without issue. Any direction that can be provided would be much appreciated. This is a MASTER trigger that provides the backbone of my application for all intensive purposes. Thanks, Bre
  18. I have a yes/no field in one of my Tables that stores Completed Training Sessions that my Trainers perform. I use the "Sent to Payroll" yes/no checkbox field to gather the sessions for submittal to payroll.(I only count unchecked fields) After I submit payroll, I would like to do a bulk update of this Training Sessions table and check all the "sent to payroll" boxes to yes...so they will not be counted twice when I run payroll again. I have repeatedly tried to get some help from Caspio for this fairly simple update function...Ideally I would like to deploy a button on my website to be able to Update all the Training Sessions after Payroll. The SQL statement is fairly simple...but how and where to execute it in Caspio obviously is not....Any suggestions???
  19. i have a search page where i am searching using a view and i would like to hide columns that are totally empty
  20. Hi everyone, I'm trying to do a Bulk file Upload https://howto.caspio.com/files-and-images/bulk-file-import-and-export/ and when I tried to do it by every method mentioned there, it didn't work. I tried zipping the files and saving the folder as 'Files', I tried to upload several photos at once, and even when I tried to upload a single file I received the Invalid File message. Tried with both .png and .jpeg The reason I'm doing this is because I'm creating a resume access database and the main problem I'm having is getting the image url from an external website to be read by Caspio when its in the table. I'm not using a Caspio form (When I tried using a Caspio form, the photos uploaded by the sample users worked fine) but rather I have to use a form from a pre-existing site, download it to excel, and re-configure it manually to be uploaded as a table to caspio. The main problem I'm having is with the photos (candidate headshots). The table in caspio doesn't recognize the web link in the excel table I upload so I'm trying to upload photos by themselves (which is where I receive the 'Invalid File' error) and then I'd like to somehow connect the uploaded photo files to the appropriate entry in the table (which I don't know how to do). Is there a simpler way to do this? Ideally, if the table could read the web link and use that photo file, that'd solve my main problem. Thanks, Rineet
  21. I have raw data fields that contain many values that need to be extracted to their own columns on a table. In Excel, I was using a nested If(isnumber(search function to extract the various values to their respective columns. How do I do this in Caspio? The attached file shows a couple of examples of before and after. TIA! S. Help on Data Extraction.xls
  22. Hi, I was wondering how would I go about creating a school database in caspio that has an individual table for every class with the marks of the students. rather than having a single table with all 1000 sudents of the school . I need to work just so the students can see their results online. the results we stored in the table
  23. Hi there, I've built a page that has a grid of images, allowing users to click on these images to make a selection ... and then I want these selections to all be saved to a table as separate entries along with their user information. So far, I can get only 1 selection to pass to the table. If they click on one of the images, that is sent to the table, fine. I've set it up so that each selection is added to the string, separated by a comma, but then this passes to the table as a single entry with the comma separated string. This is my code: function SelDatasource1() { document.getElementById("Datasource1").className = "SELECTED"; document.getElementById("InsertRecordDatasource").value += "Datasource1,"; document.getElementById("InsertRecordProject").value += "[@authfield:User_info_Project],"; document.getElementById("InsertRecordDatasource").multiple = true; } function SelDatasource2() { document.getElementById("Datasource2").className = "SELECTED"; document.getElementById("InsertRecordDatasource").value += "Datasource2,"; document.getElementById("InsertRecordProject").value += "[@authfield:User_info_Project],"; document.getElementById("InsertRecordDatasource").multiple = true; } ...etc etc ... there are over 30 of these. If somebody selects Datasource1, Datasource5, Datasource12, it shows up in the table like this: PROJECT DATASOURCE Project1,Project1,Project1 Datasource1,Datasource5,Datasource12 I am using a Submission form datapage at present, and have added my code using html blocks and footer. 2 things I need help on: 1. I know there is a better way to add a comma to the string, other than putting it in like this (i.e. value +="Datasource1,"). This way, a comma is added for a single entry and at the end of a long string, which I don't want to do - can anybody help me with this? 2. Can I pass this comma separated string so that it shows up in my table like this: PROJECT DATASOURCE Project1 Datasource1 Project1 Datasource5 Project1 Datasource12 Any help would be greatly appreciated! Many thanks Nikki
  24. I have a combined chart and report datapage that I use to display a list of jobs and their status. I would like the list and chart to have dynamic colours according to their status. This is quite easily accomplished, and in fact I have already completed it. My issue comes in place with AJAX. I cannot disable AJAX on a combined chart/report datapage, therefore when I do a bulk edit on my report, the chart reverts back to the default colours. I am guessing this is because the chart loads without running the javascript in the datapage. Is there a way to execute javascript in a datapage not only on load, but also on an AJAX call? Thanks, Josh EDIT: I just realized that it's not because of the combined chart/report that I cannot turn off AJAX, but it is because of the grid edit.
  25. Hi I am a newbie to Caspio and am having a problem with my datapages that i cant seem to be able to fix. I created an update datapage which I then embedded into my website. The table shows with extra borders. I have tried modifying the style to no use. Im embedding the datapage into wordpress. Can someone tell me how to remove these unwanted borders.
  • Create New...