Search the Community
Showing results for tags 'report'.
-
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 my results table. In that calculated field I have already placed "GetUTCDate()" . I named the calculated field "Last Updated: (click to refresh)". Essentially this shows up as a column and displays the date and time the table data was loaded. Filtering by this column refreshes the data and updates the "Last Updated:..." field as well. For me this solution currently does work, however I would be interested in a cleaner way of accomplishing this. Perhaps a method that does not require the use of its own dedicated column in the table is possible. On a side note, the data that I am most interested in refreshing is another calculated field (SQL). This is relevant because (at minimum) I do not actually need the entire table to refresh if only there is a way to refresh these calculated fields. Thanks again for bearing with me. I'm curious to see if others have had a similar problem or could use this solution that I currently have in place. COdell
-
I'd like to add some HTML to my Datapage to conditionally change the color of a report's background and text color based on the value of a calculated field. This field finds the number of days left until a project is due. I'd like to change the text color of this field to red and the background to yellow if it is past due (if the days left are negative). I know there are a couple of other pre-existing threads on this topic but for some reason I am having no luck. I pasted these in the source of my header but they had no effect. Let me know if you see anything wrong with my formulas: //for the background <a id="visi[@calcfield:1#]"> <script> var isi = document.getElementById("visi[@calcfield:1#]"); if(isi < 0){ isi.parentNode.parentNode.style.backgroundColor = 'red'; } else{ isi.parentNode.parentNode.style.backgroundColor = '#NoColor'; } </script></a> //for the text <div id="mydiv[@calcfield:1#]"> </div> <SCRIPT LANGUAGE="JavaScript"> if ("[@calcfield:1#]" < "0"){ document.getElementById("mydiv[@calcfield:1#]").innerHTML ="<span style='color:red;'> [@calcfield:1#] </span>"; } </SCRIPT>
-
Hi, So I have an HTML DataPage wherein I embedded multiple Report DataPages as iFrames. Would it be possible for me to have a button in the HTML DataPage that activates all the Download Data link for each of the Report DataPages so that all of them are 'clicked' all at once then generates the documents all at once? This way I wouldnt have to download them individually. -
We just recently moved from Google to Caspio. I'm trying to find a way to recreate the same reporting we used in google and the report was created by an outside source. Right now, we are using a bar chart. I would like to do something similar to our previous reports.
-
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.
-
If you want to filter your DataPage Report from Authentication follow these steps: 1. In Authentication, add a Virtual Field. 2. The form Element of the Virtual Field should be Text Field 3. In the Advance tab you can pass the parameter on exit: 4. For Text Only parameters this should be sufficient to pass the value to the next form. 5. If you need to pass a Date, then you need to add this JavaScript Code to Header: <link rel="stylesheet" href="//code.jquery.com/ui/1.13.1/themes/base/jquery-ui.css"> <script src="https://code.jquery.com/jquery-3.6.0.js"></script> <script src="https://code.jquery.com/ui/1.13.1/jquery-ui.js"></script> <script> document.addEventListener('DataPageReady', function(event) { $(function() { $("#cbParamVirtual1").datepicker({ dateFormat: "mm/dd/yy" }); }); }); </script> 6. Change the Virtual1 to the corresponding Field based on your needs, you could as well change the Date Format according to your needs. 7. The Login Page will look like this: 8. In the Report DataPage, use the Authentication you just created/modified 9. Filter the result on Pre-Defined Criteria 10. Select a Date Field for your Search Fields 11. On Search and Report Wizard - Configure Filtering Fields in Advance Tab chose Recieve External Parameter 12. In similar way you could pass other parameters.
-
Any ideas on 'how to format' this custom link to be inline with the 'data download' link and include an icon? Please see below code I'm using for the custom link placement and the attached image, thank you: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var child = document.querySelector("li[id^='DataDownloadButton']"); var parent = child.parentElement; var a = document.createElement('a'); var linkText = document.createTextNode("my title text"); a.appendChild(linkText); a.title = "my title text"; a.href = "http://example.com"; parent.parentNode.appendChild(a); }); </script>
-
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!
-
Hello. I am trying to create a summary report with calculated fields however I am having issues with the report. In the big picture I want to do SQL COUNTS to see if data is in a particular field however I want to group those counts by districts. There are 1202 records and 12 districts. I can not make a summary report that calculates totals for the 12 districts. I am learning as I go but I am trying something new... In one of the calculated fields (at this point I tried a new report with only this calculated field to see if I could get 12 DISTINCT records) I am trying to do a SQL DISTINCT command that only pulls the 12 DISTINCT names from the District column in the table. I am not sure if I am missing something in caspio to make this work... here is what I have: SELECT DISTINCT [@field:District] FROM tbl_Charter_Base when I do this in caspio it pulls every record in the 'District' column to total 1202 records instead of pulling only the DISTINCT records (12) any ideas? Not sure what I am missing... THANKS for YOUR HELP! -
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!
-
Hi I am new to caspio and not a fluent sql programmer but understand some of the logic. I have a Users_table, and a particular submit form, that includes a submitted_by field for the unique email address of the user. I would like to create a report that lists out the users that have not completed the form on that particular day. And a summary table of the number of users completed vs not-completed. Ideally I would be able to include other filters in the pivot. I am having a problem structuring this in the report, can anyone help out with just the first part? Thanks
-
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.
-
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? -
I have a report I'm using to search through various fields of my table. I would like to include a search box that can search for a term within/across all of my fields. Is this doable? How? Edit: I've continued to look for this info and I found this article http://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ But, I don't understand the steps. When I go to create a submission form, I don't know what field(s) to include. I can't seem to tie the form and report together, and the search doesn't end up working. I'm not sure it's even what I'm looking for. Thanks!!
-
How can I use Multiselect listbox to perform a search with OR logic? I have separate search and report as described in the video: https://howto.caspio.com/getting-started/display-results-on-a-separate-web-page/ Does anybody have ideas?
-
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.
-
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. -
How to change background of the item being Selected
NeoInJS posted a question in Styles and Localizations
I need assistance to change the background of an element in a gallery or list report when clicked. And get it's reference ID or info as a parameter -
Hi I have 3 fields; 'Year', 'Product' and 'Price' I want to be able to show a results table with 'years' across the top, 'product' as a column and 'price' as the data that's relevant to each year and product. I also want to be able to multi-select the 'Year' field in the search page, so that only the User's selection of years is displayed. I know I can do this with a Pivot Table, but this option isn't included in my subscription package. Is there a way that any of the other reports can be used to show this? Thanks for any help!
-
This could be a totally dumb question, but I'll risk it! My interest is to search my table and show a report. I don't wish to submit data to the table. I've been using submission forms for my search fields. The reason for this is because I wanted to keep my results page on the same web page as the search fields. Submission forms allow me to stay on 'same page', while report datapages force you to show results on a new datapage. Ideally I would have preferred to use a report datapage for the search fields, mainly because there are no silly problems in trying to get multi-select cascade listboxes to update in real time from a multi-select parent listbox (a problem faced by many on this forum and not yet properly solved). So is it possible to use a report datapage with a little bit of JS code, that effectively prevents its results page from being generated (as possible with a submission form)? Obviously I'd then pass my parameters to a separate results datapage, just as I do now. Thanks
-
I have a report data page that lists all customers and purchase orders through a left outer join view that shows ALL Customers and Purchase Orders, regardless of the whether the PONum field is blank or contains a PO Number. How can I label the blank fields to show something like "No Orders " instead of a blank field. All suggestions are greatly appreciated.
-
Hi all, If someone knows how to hide some records on the Tabular report if Calculation => 5 for example? -
Hello, My website (gradlook.org) uses Caspio to host a search engine for graduate schools as well as chat forums. I am now looking to create a compare functionality. This is essentially will just a combined table in which the user enters the names of two schools from the same table (preferably with an autocomplete feature). The results are a table with two columns (each school) and each school's fields/stats side by side. I have been working with views but haven't really been able to get anywhere. Can someone point me in the right direction? Thanks, Joe
-
Hey Caspio Forum ! I am a freshman here. What I want to do is to be able to change 0,00 in my Report DP. Say if any record has this value, automatically change it to blank field, or to '--'. Any help will be appreciable! Thanks guys
-
Hi! I'd like to know if it's possible to create a report showing only the aggregation I've created, and no all the records (expanded or not). Thanks for the help. Sergio
