Jump to content

Search the Community

Showing results for tags 'table'.

More search options

  • 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






Found 39 results

  1. Hi, I need to save history of changes of the fields in my table. For example, if a user changes his address I'd like to save his old address as well. Thanks in advance!
  2. I recently set up a virtual field so that my search bar would search across multiple fields. Now, I want to add some drop down boxes to help eliminate some results. For instance, this database includes scholarship information for students. I want them to be able to type a keyword that will be searched across the entire table. Let's say they type "Astronaut." The Astronaut Scholarship will appear. But let's say this student is not a US Citizen and can't apply as a result. I want to insert a drop down box (which corresponds to a citizenship field I have in the table) that would search Astronaut across the entire table, but remove anything that didn't also meet the citizenship requirements. Is it possible to do this? The online chat support person said I would have to do a virtual field, but because I have a free account, couldn't give me more information (understandably).
  3. Hello, Is there a way to convert a view into a table? Thanks.
  4. 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.
  5. 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?
  6. HI All, I'm looking to create something that automatically deletes a record after a certain number of days. Essentially: If ITEM is marked as FOO, delete after XXXX days. Anyone know if it's possible to do this?
  7. Hey! Is there any way to automatically and instantly insert new view's records into a separated table?
  8. i have a search page where i am searching using a view and i would like to hide columns that are totally empty
  9. 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.
  10. Hello Community, I´m new to Caspio and my try, to use a calculated field in a table ends with an error (see Screenhot here: http://prntscr.com/cxgbw8) in the formula: Invalid formular: Incorrect syntax near PERSISTED I´ve used this formular DateDiff(year, [@field:P_DOB], GetUTCDate() as it is shown in the help section (http://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/). Any ideas about my wrong usage? Thanks for your comments!
  11. Hello; Do views and tables have different performance characteristics? Or, is their only purpose to provide multi-table data sets? Consider these two scenarios: tbl_1 -> fld_1 | fld_2 | fld_3 | fld_4 | fld_5 | fld_6 frm_1 -> tbl_1.fld_3 | tbl_1.fld_5 Will the following View save me data usage or speed up the call? (or do anything else) view_1 -> tbl_1.fld_3 | tbl_1.fld_5 ---------------------------------------------------------------------------- frm_2 - tbl_1.fld_1 | tbl_1.fld_2 | tbl_1.fld_3 | tbl_1.fld_4 | tbl_1.fld_5 | tbl_1.fld_6 Will the following View slow down the call? (or do anything else) view_2 - tbl_1.fld_1 | tbl_1.fld_2 | tbl_1.fld_3 | tbl_1.fld_4 | tbl_1.fld_5 | tbl_1.fld_6 THANKS
  12. 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?
  13. 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
  14. 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.
  15. Hi there I would like to know if there is a way of changing the date format in a table from MM/DD/YY to DD/MM/YY I have changed region settings but the date format stays the same. I have been able to change the format on the datapage but have found no way of changing it on the table. Does anybody know if this is possible?
  16. 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
  17. 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???
  18. 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
  19. 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
  20. 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
  21. 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.
  22. Hi, I am going crazy with some grey lines now that I'm trying to launch. I ignored them since I thought it would be easy to fix once I came back to them. Boy, was I wrong. I do not know CSS much at all, so I'm sincerely hoping someone knows a fix. Thin grey lines surround and are inside all of my datapages. I write boxes below, but they're really lines. I am deployed on Wordpress, so I've gone about trying to eliminate what is causing them. I now believe this is related to some sort of default style with Wordpress, but not related to something defined in the actual CSS file since I've been deleted files and still having issues. I find it cannot be fixed with Caspio style, however, something in the Caspio code IS triggering these lines. I have included screenshots, look for the thin grey lines, perhaps related to Caspio using tables in its code? Based on various support pages elsewhere, it might be an outline and not a border. Trying to fix that didn't help. I am using Divi from Elegant Themes. It is not an Elegant Themes issue, since I tested with the theme twentythirteen. My site is at adjectivs.com. NO BOXES In Dreamweaver, completely new blank page, no CSS, embed the data page, NO boxes with iframe, no boxes appear With preview within Caspio generated preview, no boxes appear WITH BOXES Used Twentythirteen theme and the boxes appeared. deleted the whole css and rtl css files for twentythirteen and boxes appeared deleted the caspio plugin and boxes still appeared, then embedded and boxes appeared tried adding css to make outlines and border of div gone
  23. 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.
  24. Hi, I've reviewed the forums and have been able to successfully pass virtual field data into my Caspio tables using the '"Cascading drop-downs" JavaScript code method in the header and footer section of the form. It's working perfectly. I'm currently having an issue passing virtual field data into my Caspio table using a "Single Record" update form; which is required for my multi-step submission form . I modified the code for 'text field' (removing the [0]) since cascading drop-downs are not being used. The user will be entering data into the form directly. The code I'm using to 'get' the virtual text field value in the Header section of the single record update form is: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var x = document.getElementsByName("cbParamVirtual1").value; document.getElementById("LandFillRate1_Field").value = x; var x = document.getElementsByName("cbParamVirtual2").value; document.getElementById("LandFillRate2_Field").value = x; var x = document.getElementsByName("cbParamVirtual3").value; document.getElementById("LandFillRate3_Field").value = x; var x = document.getElementsByName("cbParamVirtual4").value; document.getElementById("LandFillRate4_Field").value = x; var x = document.getElementsByName("cbParamVirtual5").value; document.getElementById("LandFillRate5_Field").value = x; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> The code I'm using to insertrecord into the table in the Footer Section of the single record update form is as follows: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var x = document.getElementById("cbParamVirtual1").value; document.getElementById("InsertRecordLandFillRate1").value = x; var x = document.getElementById("cbParamVirtual2").value; document.getElementById("InsertRecordLandFillRate2").value = x; var x = document.getElementById("cbParamVirtual3").value; document.getElementById("InsertRecordLandFillRate3").value = x; var x = document.getElementById("cbParamVirtual4").value; document.getElementById("InsertRecordLandFillRate4").value = x; var x = document.getElementById("cbParamVirtual5").value; document.getElementById("InsertRecordLandFillRate5").value = x; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> Unsure if my getElement should be by Name or ID; and if it differs between the header and footer scripts. The examples for the footer script show ID and the header shows name. I'm officially confused. I'd greatly appreciate any assistance provided. I checked the script using the F12 function in the console and everything looks good but still no data showing in the table. Thanks, Bre
  25. I wrote this simple code which takes in parameters from the database Caspio to create a simple table. I just want this table to remove all fields which are empty. Since email servers do not run javascript, what is the best way to hide the rows which are empty (the paramters such as @field:Facility is not filled out). Thanks! I've also added the code: <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <style type="text/css"> tr:nth-child(even) { background-color: #D3D3D3 } </style> </head> <body> <table class="Form" border="5" width="95%" cellpadding="10"> <thead> <tr> <th colspan="2">&nbsp; <h3>[@field:TestOrder] - [@field:Facility]</h3> </th> </tr> </thead> <colgroup> <col width="250" /> <col width="750" /> </colgroup> <tbody> <tr> <th>FIELD</th> <th>RESPONSE</th> </tr> <tr align="LEFT"> <td>Facility :</td> <td>[@field:Facility]</td> </tr> <tr align="LEFT"> <td>Patient ID :</td> <td>[@field:PatientID]</td> </tr> <tr align="LEFT"> <td>First Name :</td> <td>[@field:PatientFirst]</td> </tr> <tr align="LEFT"> <td>Last Name :</td> <td>&nbsp;</td> </tr> <tr align="LEFT"> <td>Date of Birth:</td> <td>[@field:DateOfBirth]</td> </tr> <tr align="LEFT"> <td>Gender :</td> <td>&nbsp;</td> </tr> <tr align="LEFT"> <td>Primary Phone :</td> <td>[@field:PrimaryPhone]</td> </tr> <tr align="LEFT"> <td>Secondary Phone :</td> <td>[@field:SecondaryPhone]</td> </tr> <tr align="LEFT"> <td>Emergency Contact :</td> <td>[@field:EmergencyContact]</td> </tr> <tr align="LEFT"> <td>Emergency Number :</td> <td>[@field:EmergencyNumber]</td> </tr> <tr align="LEFT"> <td>Patient Address :</td> <td>[@field:PatientAddress]</td> </tr> <tr align="LEFT"> <td>City :</td> <td>[@field:City]</td> </tr> <tr align="LEFT"> <td>State :</td> <td>[@field:State ]</td> </tr> <tr align="LEFT"> <td>Zip Code :</td> <td>[@field:ZipCode]</td> </tr> <tr align="LEFT"> <td>Special Instructions :</td> <td>[@field:SpecialInstructions]</td> </tr> <tr align="LEFT"> <td>Primary Insurance :</td> <td>[@field:PrimaryInsurance]</td> </tr> <tr align="LEFT"> <td>Primary Subscriber ID :</td> <td>[@field:PrimarySubscriberID]</td> </tr> <tr align="LEFT"> <td>Primary Subscriber Relationship :</td> <td>[@field:PrmarySubscriberRelationship]</td> </tr> <tr align="LEFT"> <td>Secondary Insurance :</td> <td>[@field:SecondaryInsurance ]</td> </tr> <tr align="LEFT"> <td>Secondary Insurance ID :</td> <td>[@field:SecondaryInsuranceID ]</td> </tr> <tr align="LEFT"> <td>Secondary Subscriber Relationship :</td> <td>[@field:SecondarySubscriberRelationship ]</td> </tr> <tr align="LEFT"> <td>Diagnosis :</td> <td>[@field:Diagnosis]</td> </tr> <tr align="LEFT"> <td>Other Diagnosis :</td> <td>[@field:OtherDiagnosis]</td> </tr> <tr align="LEFT"> <td>Physician Name :</td> <td>[@field:PhysicianName ]</td> </tr> <tr align="LEFT"> <td>Other Physician :</td> <td>[@field:OtherPhysician]</td> </tr> <tr align="LEFT"> <td>Physician Phone :</td> <td>[@field:PhysicianPhone]</td> </tr> <tr align="LEFT"> <td>Physician Fax :</td> <td>[@field:PhysicianFax]</td> </tr> <tr align="LEFT"> <td>After Hours Phone :</td> <td>[@field:AfterHoursPhone]</td> </tr> <tr align="LEFT"> <td>Test Order :</td> <td>[@field:TestOrder]</td> </tr> <tr align="LEFT"> <td>Test Duration :</td> <td>[@field:TestDuration]</td> </tr> <tr align="LEFT"> <td>Holter Performed :</td> <td>[@field:HolterPerformed]</td> </tr> <tr align="LEFT"> <td>Holter Test Order :</td> <td>[@field:HolterTestOrder]</td> </tr> <tr align="LEFT"> <td>Holter Duration :</td> <td>[@field:HolterDuration]</td> </tr> <tr align="LEFT"> <td>Previous Holter Date :</td> <td>[@field:PreviousHolterDate]</td> </tr> <tr align="LEFT"> <td>Requested Start Date :</td> <td>[@field:RequestedStartDate]</td> </tr> <tr align="LEFT"> <td>Receive Monitor :</td> <td>[@field:ReceiveMonitor]</td> </tr> <tr align="LEFT"> <td>Recorder ID Number :</td> <td>[@field:RecorderIDNumber ]</td> </tr> <tr align="LEFT"> <td>H_P :</td> <td>[@field:H_P]</td> </tr> <tr align="LEFT"> <td>Upload HP :</td> <td>[@field:UpploadHP]</td> </tr> <tr align="LEFT"> <td>Authorize :</td> <td>[@field:Authorize]</td> </tr> <tr align="LEFT"> <td>Submit :</td> <td>&nbsp;</td> </tr> </tbody> </table> </body> </html>
  • Create New...