Caspio Ninja
  • Content count

  • Joined

  • Last visited

  • Days Won


Farnsbarnes last won the day on June 10 2016

Farnsbarnes had the most liked content!

About Farnsbarnes

  • Rank
    Advanced Member

Recent Profile Visitors

667 profile views
  1. Can JS extract data from data table?

    Thanks douvega. I suspected it might come down to using API calls. However, while I understand the Caspio codes and explanations as presented, I just can't get my head around actually putting the explanations together to make a basic API call. If only Caspio had a step-by-step example of the simple operations required to have a GET View Rows up and running (a video would be good). This is such a big and obvious gap in Caspio's explanations that I can't help suspect it's purposely done! Do you know of any such help anywhere? I appreciate the 3rd party recommendation. Perhaps for later, as I'm on a bit of a shoestring budget at the moment. Thanks
  2. Can JS extract data from data table?

    Well, Lets say I've got a table called 'Customer_services' with 3 fields; Name, Country, Product (all text fields). 3 records in the table: 1. Sue USA Rake 2. Eric Spain Fork 3. Sue Mexico Rake I'd like to create a variable containing all countries and products associated with 'Sue'. So what I want is: myvariable = 'USA, Rake, Mexico, Rake' Hope this is possible. Thanks MayMusic
  3. Is it possible, using javascript / jQuery, to extract data from specific fields in a Caspio table, or its results datapage, and assign that data to an array? If so, can this code be made to work by placing it in an HTML block inside the relevant datapage? Please give me an example of the code that would achieve this. Thanks
  4. Should I index a Year?

    Understood. Thanks.
  5. Should I index a Year?

    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
  6. Logout from inside an Iframe

    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.
  7. 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.
  8. 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.
  9. 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
  10. 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.
  11. Formatting downloads for Excel

    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
  12. 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.
  13. 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!
  14. How to remove blank row in listbox

    Thanks May Music and kR013. This will be a great help.
  15. 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