Jump to content

Search the Community

Showing results for tags 'tabular'.

  • 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 18 results

  1. Hello, I have reviewed this page below, but I'm not sure if this is the right solution for me. I have a tabular report, and if there is a blank cell, I would like the background to highlight yellow. What is the best way to do that? See my screen shot below, where ideally, a header or footer code would make these fields jump out as bright yellow. Thank you!
  2. Hi, I am attempting to use Virtual Fields to allow a user to specify some input that must appear on each line of a tabular report. The report requires the person who exports it to provide some contact information, and I do not want to hard-code this information. I have set up a Virtual Field as a search field, and set it to "pass as parameter" called [@Virtual1]. In my report body, I would like to display the value of the Virtual Field variable. I have attempted to use a calculated field and just put [@Virtual1] as the value, but I get an "Error in forumla." when I attempt to run the
  3. I have a tabular report with search form above the results. I was able freeze the first column and it works fine. However, the search form moves with the report when scrolling left and right. Does anyone know how to keep the search form in its fixed position? Thank you.
  4. I want to hide everything below the "Download Data" button in my tabular report DataPage. Tried adding Header & Footer with: <div style="display:none"> </div> But it also removed the “Download Data” button. Any ideas?
  5. Hello, I was hoping at some point soon Caspio would enable Lookup tables/views in ListBox type fields so the user could create their own choices for the Listbox (instead of it being hard-typed in in the table Design for that Listbox field). It's been awhile though and I can't wait any longer- so I'm using the older method of js and a text field to store multiple values comma delimited. This works fine except I don't have a way to show the related text values to the stored numerical values in a Tabular or Gallery datapage. This is because the field (text255) only has the option for Text,
  6. Hello, In a tabular datapage I need to show/hide a field (text64000) that contains html markup and needs to display as html. I use a div id to isolate each record in the tabular datapage's recordset. Then I use an 'if' statement to check the values of 2 fields in that record ("field1" and "field2"). If both criteria are met I need to then show the text64000 field ("field3") in html format. If both criteria are NOT met I need it to show nothing. The below code works to check "field1" and "field2" and then show a value in the span, either a typed in text value or a normal text
  7. Hi! There is a Tabular report with a comment field (Text64000). I want to add a "Copy Text" button, that on click will copy text from the comment field to the Clipboard, so a customer can copy the text without highlighting and copying. Just one click action to copy. I have found some solution, but it does not look like working in the reports: https://www.w3schools.com/howto/howto_js_copy_clipboard.asp Has anybody done it before or maybe you have some working solution? Thanks in advance.
  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. Is it possible to generate customized reports similar to that of Ms-Access? I know we can export as XLS, Access, CSV or XML but how do I create a tabular or a stacked report which I can print to paper? Is there a tool in Caspio where I can create a layout similar to a spreadsheet with labels across the top and data in columns below the labels (Tabular) or a layout similar to paper form with labels to the left of each field (Stacked)? I'd like to be able to print it so export to MS-Word or PDF will be great. Thanks!
  10. Hello all, Thanks in advance for looking at this. I'm looking for a clean way to refresh the data in a tabular search and report without reloading the whole page. I know that enabling AJAX in the Wizard allows the tabular report to use AJAX to filter and page through results without needing to reload the entire page each time. Reloading the whole page mandates that the user enter in all of the required search values prior to seeing the updated data. I am looking for a way around this. I currently have a system that works where I have added a calculated field as the final column in
  11. Hi, I have a tabular report that list my users. One of the fields identify who is active and who is blocked. I want to show an padlock icon on the row of every blocked user. I mean: when the field [@field:Usuarios_Ativo^] value is "no". This is a "yes/no" field type I think that should be easy, but I am really struggling to make this work with my limited java skills. Many thanks Caspio minds!
  12. We have a requirement for our Users to be able to update v quickly a large number of records within a tabular type report. The Bulk Edit/Update on its own wont work for us as we need to - when updating each of the records - to concatenate two Notes fields together along with a system date within each record and update another field. We can do this quite easily with JS in aa single Details Page (simple JS concatenating the two different notes values and adding today's date). However this approach does not seem to work on the Bulk Edit/Update - as whilst we can change a common field value ac
  13. I use a script in the footer of every datapage to have the tab header include my logo & the name of the datapage. What I need now is for the tab header to also include a string field from the datapage...how do I do that?Current footer code is:<script>var v_link = document.createElement('link');v_link.setAttribute("href", "http://login.zalipresents.com/wp-content/uploads/2015/09/Zali_logo_Z_Tab_Icon.png");v_link.setAttribute("rel", "shortcut icon");document.head.appendChild(v_link);</script>I'd like to have the tab label read: Z (logo inserted like screen shot) WORKING - [Artist
  14. Does anyone know any code for collapsing or expanding sections in a Pivot Table and a Tabular table? For example lets say that column 1 is 'Regions' and Column 2 is 'Countries'. The pivot table table is set up to show all regions and all countries expanded. I'd like to set up a button outside the results table to be able to collapse all countries, all in one go, to just show region totals, without having to go through each region individually. Many thanks in advance.
  15. I would like to hide a column in a tabular report IF it meets a specific criteria. I have looked at several forum posts including the following: http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/?_ga=1.209653078.530491687.1457713192 and Currently I have the following script added to the footer: <script> var isi = document.getElementById("visi[@field:CFC_zones_OPM_Name]"); if('[@authfield:User_Table_WGAusers_Access_Level]' == 'Finance'){ isi.style.display = 'none'; } </script> Help would be
  16. Hello, am totally new on this. and i am not an IT person in fact either. my account is also on a free plan. I wish I could get helps on how to insert aggregations, in this case Count formula into the header/footer or HTML block in my tabular/gallery datapage. I created a datapage based on a Views. According to Release Notes, Caspio Bridge 9.1 has a new feature to allow insert a field in Aggregations. But, unfortunately I couldn't see the Aggregations/Calculations on DataPage elements wizard. Any helps would be greatly appreciated. Thanks, Adhika.
  17. I have a tabular report that has calculated fields using SELECT expressions to get various values related to each record in the results. I then have the main field in the results grouped and an aggregation to average (so the aggregated value is the same as the repeated calculated field value) the calculated field(s). The aggregation shows up at the 'top' next to grouped main field. This is good (unfortunately tabular grouped sections only show the single grouped field and no related fields get to be in the top level with it- so I have to go this route). However.. What I need to do:
  18. Is it possible to hide entire rows of data in a tabular results page based on a Calculated field Value using JS? Essentially, I have a search and report to return records based on predefined criteria. However, one criteria that I would like to filter by is not stored directly in the table (Table A). It is stored in another table (table B ). So I have a calculated field holding a SQL Query to return a number based on the records from the other table (table B ). I would like to then see if there is a way to hide all records returned that are returned with a Value of 0 from the Table A Tabula
  • Create New...