Farnsbarnes

Caspio Ninja
  • Content count

    52
  • Joined

  • Last visited

  • Days Won

    1

Farnsbarnes last won the day on June 10 2016

Farnsbarnes had the most liked content!

About Farnsbarnes

  • Rank
    Advanced Member
  • Birthday

Recent Profile Visitors

536 profile views
  1. Understood. Thanks.
  2. I'm normalising a large Table which can extend to 3-4 million rows. One of the fields is 'Year' (eg '2017'). There are up to 80 different years in the database and obviously many are repeated many times, Is it worth indexing this field? I can make a table with a primary key and the related year, such as y1 = 2000, y2 = 2001, y3 = 2002 and so on, then relate the primary key to year field in the main Table. I'm just wondering whether all this fuss for so little is worthwhile. Is it going to make a performance improvement? Or should I be doing this a completely different way. Thanks for any advice
  3. Panic over, I've found the answer myself. Use a target tag. Using '_top' breaks outside of all the frames it is nested in and opens the link in the top document in the browser window. <a target="_top" href=" --- Enter Caspio URL here --- " id="Logout_button">Log out</a> Hope this can help someone.
  4. Does anyone know if it's possible to have the logout link working from inside an iframe on a webpage? At present, I've positioned the usual logout link in the iframe but I can't seem to escape the iframe when I try to logout. Any ideas? Thanks.
  5. 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.
  6. I have a simple pivot table with 'Years' field across the top and a 'Regions' field and a 'Countries' field down the side. The regions field is collapsible, so the User has the choice whether or not to show the countries inside each region. So far so good. Problem is that In the regions column I want to be able to show selected regions with the collapsible option, but I also want to show (in the same column) other selected regions which do NOT have the collapsible option and therefore just show the aggregate total of their countries. I know this is not a regular option, so I'd be willing to use javascript. Can anyone give guidance on the code to use to access selected fields and records in a pivot table, and also how to apply/remove the 'collapsible' feature at runtime. Many thanks
  7. 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.
  8. Well, as far as I'm concerned, writing the Excel macro to format spreadsheet data is the straightforward part. The hard part for me is understanding how to make the whole process happen, ie as soon as the User hits the Caspio results table 'download' button the steps (I think) would be: 1) Caspio sends unformatted data to Excel (could send directly to my computer (which would be on 24 hrs/day), or perhaps to a specified Excel 'shell' available in the cloud somewhere) 2) Once data received into a spreadsheet, an Excel macro is triggered to format the data in that spreadsheet (that's the easy part) 3) After formatting the spreadsheet, the file is saved as xls / xlxs, and sent back to CASPIO, and 'magically' appears on the Users screen as an Excel file for download ... and all within seconds of the User hitting the 'download' button! I imagine that this involves CASPIO API's, or some other data communication, but would really appreciate someone pointing me in the right direction. Thanks
  9. 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.
  10. Mmm - can't see anything obviously wrong with the code. I know it's a basic question, but did you disable the HTML editor in the HTML block? When you say it's "hover-able" I assume you just mean that the cursor changes shape when hovered over the button, and not that you expect the menu to open without clicking?. Have you checked to see whether this works on your webpage... sometimes preview doesn't show what it should. I'll leave any other comments to the real Caspio experts!
  11. Thanks May Music and kR013. This will be a great help.
  12. I have been trying to use the code in the link below to help remove a blank row appearing at the top of my listboxhttp://forums.caspio.com/index.php?/topic/3170-js-prevent-blank-entries-from-displaying-in-a-dropdown/I couldn't get it to work, and Caspio's Technical Help confirmed that the code won't work in a submission form, only in a report datapage.I tried using a 'view' of the data, but this didn't work either. Anyone got any ideas for removing a blank row in a listbox in a submission form? Thanks
  13. Hi MayMusic. Actually, it's the opposite (unless we're agreeing from opposite directions)! The download and dropdown search move up and out of view when I scroll down. Ideally I'd like them to remain in view when I scroll. Another idea to make it all look a bit tidier would be to have some kind of white banner to block out the lines above the header. Don't know if this is possible though. Thanks
  14. The 'Sticky headers' option in reports seems to work by 'floating' the header bar. I'm working in an iframe, so I've got a space between the top of the frame and the start of the headers row, and in this space is the 'download data' and 'search' option boxes. But when I scroll down, my lines of data end up scrolling above the header bar, filling the space where I want the the 'download data' and 'search' option boxes to remain permanently displayed. Does anyone know a way of stopping the data lines from rising above the header bar when scrolling? Thanks
  15. Aesthetic reasons. I want both pages visible at all times. iframes also load much faster. Overall, a much smoother, less clumsy User experience. Thanks