Search the Community

Hello All, I can't find out where/how to change the 'Download Data' icon. I see all the other icon options in the various Styles settings but not the 'Download Data' icon. I also found in the Localization how to change the text for 'Download Data' but there's no option for the icon. Does anyone know where this specific icon setting is? Many thanks!

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.

Hi, We are in the final stages of a project where users are able to download a PDF version of the responses they have submitted. The PDF document is several pages long and is designed as a professional customised template. We want to be able to save all users PDF files in the CASPIO database so they can access the files in the future without having to generate them again from the CASPIO data page. We also want to be able to mass download all PDF files from all users at once (over 900 members). This is complicated by the fact that parameters cannot be passed to the PDF generator within CASPIO. We would like to know if there is a solution for using JavaScript that will generate the PDF file (perhaps as a standard data page) and then when the download link is pressed it downloads the file to the users hard drive, but also uploads the file to the CASPIO database? I've got as far knowing this command will allow different types of files that can be uploaded: <SCRIPT LANGUAGE="JavaScript"> document.getElementById("InsertRecordfilename").setAttribute("accept","application/pdf"); </SCRIPT> Is it possible to upload the present data page using a similar command? Thanks Scott

This thread has parts and answers in other threads, but none of them solve doing this in a Submission form so I thought a new thread that unified this info would be helpful to anyone who needs this kind of solution. @Meekeee has posted a really cool solution for pushing calendar events via download from Caspio to Google, Apple, MS calendars, which is extremely beneficial: https://jekuer.github.io/add-to-calendar-button/ and https://github.com/jekuer/add-to-calendar-button. There's a few issues in using this solution with Caspio, though, that I haven't been able to figure out--mostly when it's deployed in a submission form. The issue is you need to get the user's input from the submission form to populate the values for the exported event's name, description, BeginDateTime, EndDateTime, and Location. On a Details page it's fairly straightforward, using [@field:BeginDate], etc. But the [@field:..] method isn't available on a Submission form, only Authentication fields can be used that way. I've tried using variables to get the field values (and testing with a 'dead' button and alert box confirmed that the values were captured correctly). The problem is I don't know how to use those variables in the event export code that goes into the datapage (there are other files, css, js, etc. that are referenced from elsewhere). This is the code that gets the values and coverts the date/time field to ISO formatting for the export: function getevent(){ var v_name = document.getElementById('InsertRecordTasksTimeline_Title').value; var v_note = document.getElementById('InsertRecordTasksTimeline_Notes').value; var v_location = document.getElementsByName('InsertRecordTasksTimeline_Location')[0].value; Stamp = new Date(document.getElementById('InsertRecordTasksTimeline_CalDate').value); Hours = Stamp.getHours() Mins = Stamp.getMinutes(); v_BeginDate=('' + Stamp.getFullYear() +"-"+ (Stamp.getMonth()+1) + "-" + Stamp.getDate() +"T"+ Hours + ":" + Mins); Stamp2 = new Date(document.getElementById('InsertRecordTasksTimeline_CalEnd').value); Hours = Stamp2.getHours() Mins = Stamp2.getMinutes(); v_EndDate=('' + Stamp2.getFullYear() +"-"+ (Stamp2.getMonth()+1) + "-" + Stamp2.getDate() +"T"+ Hours + ":" + Mins); } This is @Meekeee's code (there's variations, I'm using one that uses a normal button to call it) that creates the button with the event download options: <button id="default-button" name="submitevent">Save/Close</button> <script type="application/javascript"> const config = { "name": "tile of event", "description": "notes for the event", "startDate" : "2022-05-21T10:15", "endDate": "2022-05-21T12:30", "location":"location of event", options: ["Google", "Apple","Microsoft365"], timeZone: "currentBrowser", trigger: "click", iCalFileName: "Reminder-Event", } const button = document.querySelector('#default-button') button.addEventListener('click', ()=> atcb_action(config, button) ) </script> The issue is getting the variable values into the " " part of the code. For example, "name": "tile of event", will work with "name": "[@authfield:Company]", but I can't figure out how to use the variables. It would be something like this (but it doesn't work, though): <button id="default-button" name="submitevent">Save/Close</button> <script type="application/javascript"> const config = { var v_name = document.getElementById('InsertRecordTasksTimeline_Title').value; var v_note = document.getElementById('InsertRecordTasksTimeline_Notes').value; var v_location = document.getElementsByName('InsertRecordTasksTimeline_Location')[0].value; Stamp = new Date(document.getElementById('InsertRecordTasksTimeline_CalDate').value); Hours = Stamp.getHours() Mins = Stamp.getMinutes(); v_BeginDate=('' + Stamp.getFullYear() +"-"+ (Stamp.getMonth()+1) + "-" + Stamp.getDate() +"T"+ Hours + ":" + Mins); Stamp2 = new Date(document.getElementById('InsertRecordTasksTimeline_CalEnd').value); Hours = Stamp2.getHours() Mins = Stamp2.getMinutes(); v_EndDate=('' + Stamp2.getFullYear() +"-"+ (Stamp2.getMonth()+1) + "-" + Stamp2.getDate() +"T"+ Hours + ":" + Mins); "name": "v_name", "description": "n_note", "startDate" : "v_BeginDate", "endDate": "v_EndDate", "location":"v_location", options: ["Google", "Apple","Microsoft365"], timeZone: "currentBrowser", trigger: "click", iCalFileName: "Reminder-Event", } const button = document.querySelector('#default-button') button.addEventListener('click', ()=> atcb_action(config, button) ) </script> Does anyone know how to integrate the variables with the event export code? This would be a really great solution if it can be worked out.

Hi, I'm using the new Caspio PDF report download option. I'm noticing that my hidden columns show up on the PDF. Previously, I was using the Caspio PDF generator code provided by Caspio based on my account type and the hidden columns remained hidden. I tried placing the hide column JavaScript in the source code for the PDF configuration but that does not seem to work. Does anyone know how to hide columns on the tabular reports using the new PDF feature? I'm using the the data in the hidden columns for SQL calculation purposes but the end user does not need to see the raw math. As always, I appreciate the input. Thanks, Bre

I have separate search form and results datapage on one webpage. Is it possible to move the download data button, currently at the top of the report datapage, over to the search datapage? I've tried using CSS, but can't seem to escape the report datapage boundaries. I've also tried to extract the appSession link that's attached to the download button (using inspect element in Firebug), and assign it to a button I created on the search datapage. This worked for a short while until I realised that the appSession link is only temporary, so my download button on the search datapage stopped working the day after! Is there not a more permanent link for the datadownload that I can apply to a button? Thanks for any guidance.

I'm having issues downloading xml files from Caspio on some Windows computers. Once I go through the whole keep -> save as song and dance, it converts the file to a .crdownload and refuses to open with excel (corrupts or has other errors) 9 times out of 10. Any ideas on how to fix this? Edit: Having a similar error on Mac but without the .crdownload. This file specifically is coming up with this error when I try to open it.

I'm trying to work with a datapage's download file in a bit of a different way then normal. Instead of the user clicking the 'Download' link I need that download csv file to just 'open in the url.' (meaning the datapage tabular view doesn't open at all). This is because I need that download csv file to be available via a url for another, outside app to access (using that url) and then use to import that data. I need to cut out the steps where the user has to 'download the data,' take that file and then 'upload it to the outside app' to do the actual import. The outside app should be able to just go to a url and grab the data. I’ve looked into the Datahub but it won't work for this particular need because it’s an ‘all data all the time’ thing with 2 drawbacks. 1) it doesn't 'authenticate' the data at a sub-account level, other than the overall CB account and 2) all records need to not be exported at all times- only records the user designates or that are in a queue using various fields in the View for filters. The existing ‘download’ link in a tabular datapage is close to solving both the authentication issue because 1) the datapage will only show data for the account that’s logged in and authenticated already, by design and 2) the ‘export status’ issue is dealt with using normal filters to filter out non-exportable or already exported records. These are the 2 big hurdles and using existing data pages solves them both. The missing part of this solution would merely be setting the datapage to ‘open the download file’ instead of opening the datapage view, on load. Since the datapage already has a download link the user can click on to get the data downloaded in xml/csv, it’s got to be just a matter of pointing the ‘on load’ of the datapage to just go to that existing ‘download’ link and instead of downloading anything just open it in the data page’s existing url. Another related option might be for the datapage's 'onload' to activate the 'download csv' file and send it to a specific, designated url that's not the opening datapage (if that's easier). Then the outside app can go to that url and pull the download csv file. Surely this can be done? It seems like it’d be very similar to the code for ‘select all’ and then ‘open bulk edit’ automatically that can be implemented on a tabular datapage. We just need ‘onload’ to be ‘open download xml/csv.' Any help on this would be greatly appreciated-

Hello! I'm using Caspio's "File" Data Type? and I'd like to dynamically link to the uploaded files. Is there a way to find a "friendly" link for the files uploaded using the Caspio "File" Data Type? By "friendly" I mean the FileName and/or FilePath is visible? Rather than unfriendly: https://bx.caspio.com/dpImages.aspx?appkey=xxx&fileID=123 Friendly: https://bx.caspio.com/dpImages.aspx?appkey=xxx&filePath=[filePath]/[fileName] Thanks

The problem I face is that when Users download data from my Caspio results table they get an unformated Excel file. It would be great to somehow apply a template to adjust column/row widths, fonts, add a logo, etc., so that when the user opens up the Excel file, all looks consistent and professional. Obviously there's no standard feature in Caspio to do this, but I'm wondering whether such a setup could even be possible. I'd even be happy to write an Excel macro to do the formatting (and call the data) if that could form part of the solution. What makes it tougher is that the whole process would need to happen on the fly. Any advice much appreciated.

Hi everyone, I have a search and report form which I have published to a website for a client. I have purchased the white label. On the search results page, I have a logout link and a download data link. 1) Is there a way for the logout link to show in the action bar at the top, where the 'Download Data' link is, instead of having to put it in the header? 2) When I hover over the logout link or the download data link, the URL shows as https://eu1.caspio.com/xxxxx. I would prefer for this not to mention caspio, as this is customer facing. Is there a way to do this? 3) When I download data, it prompts me to accept to download from eu1.caspio.com. Same as above: is there a way to not show this? Thank you, Julien

I attempted to created check boxes on a tabler form, i was not given the virtual option to do it. I wanted someone to be able to select the form and then download the data that they selected via the check box. I know it has to be simple, but i am just not seeing how to do it, since i cant seem to get the virtual option to apprear on the tabler format of the datapage thank you

I'm using the below select statement in a calculated field, the resultset works great in the html grid when I fire the datapage, but when I export the datapage the columns are blank. I am able to get results if I change the values from 'true' and 'false' to 1 and 0. Has anyone run into this? We would like the text value of either 'true/false' or 'yes/no' Thanks, -John select case when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'True' else 'False' end from JRRESULTSTABLENEW a join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID where a.MemberID = [@field:JRCOOKSLISTING_MemberID]