Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by BjornSkifs

  1. Hi Jonathan, Thank you for the confirmation. This is probably a longer explanation than you asked for, but here it goes. This is what I want to do: I use DataHub to export a view with sales data to Google Drive. Then I want to perform a few simple calculations on this data. For example I aggregate the data per month. This is where I need year(a2), but also month(a2). Then I want to use a feature in Google spreadsheet that creates a gauge to show sales during the current month. I know that there are people who argue against gauges as being an inefficient way to display data, but our sales people just love it. This gauge is then shown on our internal Caspio page as an iframe. I have two problems with this. First, since the date is not recognized as such in excel, I can't do the aggregations. Second, it is cumbersome to make Google Drive automatically transform the excel file to a google spreadsheet. For these two reasons I have now abounded the project. Instead I create an anonymous web page and scrape the data from there with Google spreadsheet. Then I can create the gauge. I don't like this solution much, so I'd prefer another solution. I know that I can create a bar in Caspio and display the bar instead of the gauge, but the gauge is simply much more fun. At a more general level, being able to export data to Excel or Google spreadsheets, and then to have it automatically presented in custom made charts, would be a big advantage. Thanks Bjorn
  2. Hi! I am exporting a view to excel. When I try to perform the operation year(a2) on a date, then I get an error saying that the cell contains text and not a date. I.e. it seems that a date i Caspio is not exported as a date to excel. Regards Bjorn
  3. This is for a submission form. I would like to use no label, and instead have a placeholder-label within the text field. I know I can do this by assigning a static value under Advanced. My problem is that when the user clicks in the text field, then the text is still there. I would like it to disappear. Is this possible? I'm really grateful for any help. Bjorn
  4. Thanks! Actually all the information is here: http://howto.caspio.com/authentication/ ... ntication/ I thought I'd memorized it, but not quite. :wink:
  5. I have a table with two columns: Sales_Date and Status I'd like to create a stacked bar chart showing the number of sales each month, and were the bar is divided into the different statuses. I have two problem: 1. Can I even create stacked bar charts? 2. Can I create multiple series from the one series status? I'd greatly appreciate any help Thanks /Bjorn
  6. I'd like to use one Caspio account to host files for two separate organizations. Both organizations need password protection, but obviously I don't want them to be able to login to each other's accounts. How can I achieve this? Ideally I would like to set up two different Authentication Tables, but I suppose I can't do this. I don't think I can use Record Level Security since it can't be used in submission forms. I'm grateful for any suggestions. /Bjorn
  7. I would like to have a html field where I write "You are logged in as X" in a report - on the results page. I use the Authentication Table, and I know that I can filter depending on who is logged in. But this somewhat different. Actually, I want to acheve more than this - I want js-links on the results page to be different depending on which class of user that is logged in. But if I know how to write "You are logged in as X" on the results page, then I can solve the rest myself. I'd be grateful for any suggestions. Thanks! /Bjorn
  8. Thanks MayMusic, I made a silly mistake. I had http://www.yourdomain.com/index?cbResetParam=1 but should have used http://www.yourdomain.com/index&cbResetParam=1 I.e. I should have used & instead of ?. Thanks again for your help. It's really appreciated.
  9. I can't get this to work: http://howto.caspio.com/parameters/rese ... eters.html I do the following: 1. I have a link on page A to a reports datapage (page . In the link I pass a parameter in a query string, which is then used to filter the results on page B. 2. On page B I have a link taking me back to page A. 3. On page A I have a second link to page B, but where I don't want to pass a parameter, so I use ?cbResetParam=1. The problem is that the old parameter isn't cleared and the results on page B are again filtered. I have tried to have ?cbResetParam=1 also in the link in 2. - although I think it is superfluous. See the enclosed screenshot for the setting on page B. I have also tried If empty, ignore criteria. I'm probably doing something silly here, but I can't figure out what it is. I would be very grateful for any suggestions. Thanks! Bjorn
  10. One workaround, that unfortunately doesn't work very well, would be to create the tables Table 21 to Table 23 - all tables being identical to Table 2. Then I could create a view linking them in order to Item1ID, Item2ID, and Item3ID in Table 1, and effectively creating a 3-dimensional view. The problem with this solution is that when a name changes I need to change it in all tables. (In my real world case I would have 12 tables). This is messy. Is there a better solution? Thanks! Bjorn
  11. First of all: Thanks MayMusic. You always help me out - and with excellent advice too. I really appreciate it. Now, back to business. I'm short on Datapages, so I'll give you a few screenshots. Screenshot 1: This is the submission form where users report their sales. It's a dropdown where the ItemName is shown but where the ItemID is recorded. The submission writes to Table1 and Table 2 is a lookup table. Screenshot 2: These are the tables, and some views. In View 1, I have linked Table1_Item1ID with Table2_ItemID. I would like to link also Table1_Item2ID and Table1_Item3ID with Table2_ItemID - as shown in the View wizard. But that doesn't work, as can be seen in View 2. (The reason, I suppose, is that a View can only be a 2-dimensional matrix). Screenshot 3: This is a details page drawn from Table 1. I want to display the results in a datapage that is not editable. Since I can't use a view, I might as well use Table 1 itself, which I have done in Screenshot 3. Since I don't want it to be editable, I might as well use Display only, but then - as you can see - it only shows the ItemID, not the ItemName. I could instead use a dropdown, using Table2 as a lookup table, but then it's editable - which I didn't want. So in conclusion. I can't construct a view, since a view can only be 2-dimensional (or at least so it seems). And I can't use a lookup table, to display the name instead of the value, either. (One workaround would be to record the ItemName and not the ItemID in Table 1, but the ItemNames changes quite frequently. That's why I used this approach to start with). This was really long. I'm sorry about this. I hope it makes my problem clearer though. Thank you for all your help! Bjorn
  12. I have two tables designed as follows: Table 1: SalesDate Item1ID Item 2ID Item 3ID Table 2 ItemID ItemName People fill in Table 1 in a submission form. I know that it would be better to have them submit sales of each item separately, but for various reasons that's not an alternative. Now, I have a problem when I want to display the results. I can display the results in a dropdown that uses Table 2 as a lookup table. The problem is that then it will be editable - and I don't want that. If I only had one column for the items in Table 1, then I could use a view, but I'm not able to create a view that links both Item1ID and Item2ID with ItemID. Am I doing something wrong? Is there a workaround? I would be very grateful for any help. /Bjorn
  13. I found a way around this: Create HTML fields and use JS to render the fields that you don't want to be editable. <script> document.write('[@field:Name]'); </script>
  14. I pull data from a view, merged from several tables, and make it possible for the users to update on the results page. But when the users click Modify, they are warned that the non-editable data in the view is required, and that "You did not enter valid information in one or more of the fields." Is there a way around this?
  15. Thanks MayMusic! This is probably a silly question, but how do I know the URL OF THE SEARCH? (I would like the button to take me back to the results page). /Bjorn
  16. I have a details page that is a reloading after a few seconds. I would like to add a "Back" button in addition to the one that is standard. Normally, <input type="button" onclick="history.back(-1);" value="Back" > would work, but since I'm reloading the page after x seconds, the Back button wont work after x seconds.Is there a way to get around this? For example, it there a way to redo the search through a button on the details page? I'm grateful for any suggestions. Thanks /Bjorn
  17. I would like to save the content on a details page automatically without reloading the page. Is this possible? I know that I can use document.getElementById("caspioform").submit(); to submit the form. On the "Destination and triggers" page I can choose "Same Form", but this means that the details page will load again. I don't want this for various reasons, some of them discussed here: http://forums.caspio.com/index.php/topic/3675-automatic-update/ I would extremely grateful if anybody can suggest a solution to this. Thanks! /Bjorn
  18. I have a list of sales that basically looks like this: Date Seller Amount I want to use collapsible groups and display it in the following way There are three problems: 1. I can group per year or per month, but not both per year and month. 2. I can't aggregate both per year and seller. There is an option "Also apply to the first group". I would like it to be "Apply to every subgroup". 3. When I collapse the groups so that only the years are shown, then only one year is shown on the page. The reason is that at maximum 250 records can be shown on each page - although they are all collapsed. Is there an easy way to address these issues? I'm really grateful for any help. /Bjorn
  19. Thanks Barbara. I think there is a problem with this solution, though. I think it loops indefinitely.
  20. Thanks Barbara, I'm actually interested in having fairly updates exchange rates, so I would prefer something more automatic. I'm not done yet, but it seems to be possible with javascript though.
  21. Beautiful. Thank you so much!!!
  • Create New...