Jump to content
  • 0

Relationships between records


GuidoThys
 Share

Question

I am looking for and end-user friendly way of "hopping" from one record to another.
I have a number of one-to-many relationships for family relations: "parent of", "partner of" etc.
e.g.:
Name:          John Doe
Parent of:   Jane Doe

How can I turn "Jane Doe" into a hyperlink that directs to Jane Doe's datapage? Or add a link in any other way?
I couldn't find anything in the documentation, so any suggestion/help would be greatly appreciated! Thanks.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello @GuidoThys,

My understanding is that you have multiple tables that are related to each other.

For example: there is the Students_ table that stores unique students, and there is the Parents table that stores unique parents, but we can have 2 parents related to one student. 

qe389Es.png

And let`s say you have a Report or Details DataPage that is built on the Parents table. You may add an HTML block and add a link there:

YSQisAN.png

 

The link should lead to the Students DataPage and pass an ID value as a parameter. 

In my example the path is: https://accoountID.caspio.com/dp/9fae700094b472895f114351b8a8?Student_ID=[@field:Parent_Of_Student]

So, the Students DataPage should receive this ID value as a parameter. For that, use the "Filter data based on your pre-defined criteria" option and receive an External parameter:

dvAeh4F.png

 

These articles can be helpful:

https://howto.caspio.com/parameters/parameters-as-query-string-values/

https://howto.caspio.com/parameters/receiving-parameters/

https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ (this article describes how to use separate Results and Details, however, this solution can be applied for 2 Results, etc.)

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...
 Share

×
×
  • Create New...