Jump to content
  • 0

Fetch Information By Id Twice


irebu

Question

Hello,
 
I'm new not only to Caspio but to databases as well, so please excuse any newbie errors I did. Just a quick explanation what I'm trying to do: 
A user picks a punch from a list. As a result he can then see information about the punch (once) and details concerning any stamps matching the selected punch as well as if there is any "buy a bundle" option available. 
The punch, stamp and bundle info all come from a catalog, which is not necessarily the same for all three (e.g. punch in one catalog, stamp and bundle in another). 
 
The current table setup:

 

DBTableStructure-e1457515999395.jpg

 

One view manages the punch / punch-type relation, one view is used as lookup table for the punch-bundle-stamp relation.
 
I use two datapages with reports that are combined in one page similar as described here: http://howto.caspio.com/tech-tips-and-articles/parameters/add-a-search-interface-to-results-sets-page/
(I just use a report instead of the first submission form, as I would like the punch info to show up *once* as well.)
 
So far, I managed to get this running except for one issue:
The catalog ID is linked to the stamp and to the bundle info; I would like the report to show both, the catalog description of the catalog ID assigned to the stamp and the bundle. I can't figure out how to properly set up the view and report page to check the assigned ID for both entries and show up the two catalog descriptions. 
 
Also, it would be awesome if I could combine the catalog url (from CATALOG) and the page information (from PUNCH, STAMP and PSRELATION) into one field on report creation to flexibly create a clickable url, as I could add the url once to the catalog instead of adding the info to each entry in 3 tables.
As far as I can see this won't be possible for me in the free version. That's a minor thing though, maintaining it manually in the 3 tables is ok.
 
Any help on how I get the catalog description twice, but identified by different IDs would be very much appreciated.
Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

I only skimmed this, but it sounds like you want to use GROUPING on your search results: by punch, then category:

http://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/

 

 

Next it sounds like using JS to concatenate text from several fields into one:

http://forums.caspio.com/index.php/topic/3200-js-concatenatecombine-two-fields-into-one-field/

Link to comment
Share on other sites

  • 0

Hi Irebu,

If I understand you correctly, you'd like to create a view, based on 3 tables. It's possible, you should join them on ID_Catalog. You can find more info here

Regarding your second question, when you create a view, use it as a data source for the report datapage. On the result page you can render value of the field "Catalog url" as URL. Find more info  here

 

I hope this helps. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...