Jump to content


  • Content Count

  • Joined

  • Last visited


About NickO

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. @DefinitelyNot31337, thanks for circling back. While it would be great to be able to cache results, they are calculated on the fly based on user provided criteria. They are also queries against a View, so I am not sure that a calculated field in that view would be allowed even if I could leverage that method.
  2. Thanks DefinitelyNot, you are understanding. You describe what I currently do to get those values. The problem is two-fold. 1) There are 15 of those queries for each of the 400 rows of the contents table and 2) Those queries are happening against about 4mil records currently in the view. This leads to a significant performance drag. It is light years better than the pivot table performance to be sure, but it is a turn off for users. My real problem is that the data they are looking for really could be any combination of those 15 different criteria so I can't step them through it in any way to reduce the # of queries in any given datapage or the number of records in the view.
  3. Thanks for the suggestion Watashiwa. That is the first path I tried. Unfortunately, performance is atrocious on a pivot with that many records and criteria.
  4. I have a Datapage which is sifting through data in a fairly large view (4mil rows and growing). The simplified version is that the view allows me to search for "content" that meets a combination of about 15 different criteria, so no real way to shrink it. The Datapage in question though, is concerned only with summary level data. I.E. how many of each criteria are met by the content. For example: I have a single content, Content A. That content is linked to 3 items in criteria1, 2 items in criteria2 and 0 items in criteria3 So my view looks like: But my datapage looks like: With 4 million rows, 500 Content and 15 different criteria, the datapage itself obviously takes a while to chew through the data and load, filter, sort, etc. Is there any way to create a table or view that will have the summary level data for this datapage so I don't have to calculate it all on the fly every time a user interacts?
  5. Hmmm...that is one way to address it, but if I have multiple different types of entities I want to associate the Content to, then I have to add a column for each type to the table. I would also have to remove the value the user selected from the table when the Triggered Action was run. I.E. User chooses P1 for C1, C2 and C3. Triggered Action writes combo to ContentProduct table, creating 3 new records. Triggered action removes P1 reference from C1, C2 and C3 in Content table. Yes it would techincally work, but is pretty kludgy. Is there any way to do a control like the one attached? Basic flow would be as follows User chooses product and is brought to a screen like this which lists all available content in on box User selects Content to associate to product (or removes) as necessary and list on right is populated User submits changes and entries are created in the ContentProduct table
  6. Sorry Perzival, just saw this. I noticed a typo above with likely didn't help. The three tables are Content, Product and ContentProduct. Say Content has fields ContID, Name, Description and Records C1, C2, C3, C4. Product has fields ProdID and Name and records P1, P2, P3, P4. ContentProduct allows me to link them together so a record in ContentProduct would have fields ContID and ProdID and link the two together. Specific to my question. If I want to create three rows in ContentProduct that contain C1,P1; C2,P1; and C3,P1 is there a way to do this without the user having to select each Content record and click add through a new record (or other) Data Page?
  7. I have two normalized tables, Content and Product. They are linked by a DescriptionContent table. I have a form that allows me to link the a single Product to a single Content. That form automatically gets the ProductID via a parameter. I am trying to find a way to associate multiple items from the Content table to that Product in a single data page. Does anyone have any thoughts?
  8. Hi Andrew, thanks for the reply. I actually came up with a fairly acceptable way to address this for our needs. It is pretty simple, and does have its limitations, but it works. Created a Pivot Table datapage One Row for the target field that I want unique values for One Calc Field in the Values with a SQL query to get the unique ID for the target field Added some JS to the footer to change the displayed value in the results cells Formatted a small table in those result sets with links to the Datapages that perform the tasks I need for each option It isn't super elegant and I am limited in formatting options because it is a pivot table, but it gets me where I need to go.
  9. Is there a way to add HTML to a Pivot Table datapage? I want to use it similar to an HTML Block in a List report datapage. Specifically I want to capture the Row value and use that to open a separate data page. Alternatively, if anyone has a creative way to do a "Distinct" type action against a specific field in a List type datapage, that would solve the need as well. I am open to Javascript solutions if there is a way to make them generic enough to re-use on other similar data pages or some sort of CSS.
  10. I have an odd problem trying to work around the lack of "Distinct" query functionality within Caspio. My data has many to many joins and therefore the view lists a specific field multiple times. When I query to reach a list of these fields, there are obviously multiple rows. I am trying to eliminate those multiple rows and list a single row for each unique value in that field only. The problem is that the datapage is still formatted as if all the results are present. So I get multiple pages with only a single entry on each. While I can change the view to include more records per page, that does not actually solve the problem. I would like to be able to prevent the pagination or actually remove the extra rows from the result set instead of just hiding them. Any ideas?
  • Create New...