Display associated records

Permalink Browser Info Environment
I have two forms, the first form is for obituaries, the other is for condolence messages. The condolence message form has a dropdown populated by the Name field from the obituaries form. I want to display the condolences associated with a particular obit on its detail page.

When displaying the condolence messages, I am trying to use the Filter option, but I'm not sure what the Value should be.

I feel like I may be missing something small here.

Type: Discussion
Status: New
FatTony1952
View Replies:
ProjbyP replied on at Permalink Reply
ProjbyP
Interesting, I'm working on a similar project - for a funeral home. Will also need the ability for customers to possibly add condolences. I will be watching this post for feedback.
jgarcia replied on at Permalink Reply
jgarcia
It never ceases to amaze me the things people are able to do with these packages! :)

That said, this is a tricky situation, but it's doable. Here's what you would need to do:

1. In your list template, rather than using {{DETAILURL}} to link to the detail page, enter the page URL manually and at the end add: ?rID={{recordid}}&q={{name}}. You'd also need to have <recordid placeholder="recordid" /> and
<field name="Name" placeholder="name" /> in your template to make sure those placeholders work.

2. On the detail page, add the Data Display Single Record block with the following settings:
*Method of specifying which item to display -> URL Parameter
*Parameter Name -> rID

3. Also on the detail page, add the standard Data Display block, specifying the Condolences form and list templates appropriately.

4. On the condolences form, make sure that the "Name" field is the only field that is searchable.

5. Lastly, on the Condolences form settings under "Submission" set "Method of specifying which item to display" to "Yes."

Essentially what you are doing when it comes to listing the condolences for a particular obituary is searching the condolences form the names field for one's that match the name passed in the "q" URL parameter.

Hopefully that helps. And hopefully I didn't leave anything out. :)
FatTony1952 replied on at Permalink Reply
FatTony1952
I may have been a step ahead for this. So as not to pull two "Mary"'s for example, when the client fills out the obituary initially, there is a field for the full name just for condolences. This will allow them to search for condolences based on the deceased's full name. I may use the name filter to filter by the full name.

Thanks jgarcia! I'll let you know how this works.
ProjbyP replied on at Permalink Reply
ProjbyP
The obits on the site I'm working on are only being added by the funeral home staff, but the condolences part is definitely something we wish to incorporate - in my case, the form will go at the end of each obit.

Tony - Can you share your site URL? I'd like to get feedback if you get it in place and working ... Thanks!!!

JGarcia - your work is awesome! My first project took a few weeks to work it out as I was learning. After that, just a few hours! And I'm sure I've only touched the basics in my projects. Thanks for a great product!
FatTony1952 replied on at Permalink Reply
FatTony1952
I don't see the field in "Submission" you listed in Step 5.

That is in the form's Settings?
FatTony1952 replied on at Permalink Reply
FatTony1952
I have the proper field passing in my URL and storing in the proper form from the URL, but displaying the condolence messages from the form is where I'm getting hung up.
FatTony1952 replied on at Permalink Reply
FatTony1952
I've gotten it to work and show using the Display Single Record.

I went through your instructions, but I don't see the "Method of specifying which item to display" under "Submission" in the form setup.
FatTony1952 replied on at Permalink Reply
FatTony1952
Any updates to this? I wasn't able to find the submission setting you mentioned in Step 5.

Thanks!
fauners replied on at Permalink Reply
fauners
Hi
I am looking for something similar with records being shown based on a URL parameter. That step 5 you mention i can't see anywhere like fattony.
I'm getting the URL passed fine and the single record display will show the last record with that parameter but I can't get a list showing based on it.
Any info or guidance would be great.

adam
jgarcia replied on at Permalink Reply
jgarcia
Hey guys - for step 5 it was supposed to say "Re-index form when search is submitted?", not "Method of specifying which item to display."

Sorry about the confusion!!
fauners replied on at Permalink Reply
fauners
Hi Justin
Thanks for the reply. i tried that but am not getting what i intended.
Mine is a little different from fattony
I simply want to link to a page which lists all records based on a single field.
I have a page and the URL parameter is being passed fine. So i have a url like /viewform?Reg=wxy1234
So i am trying to get all records where the field "registration number" = wxy1234
I was also trying it with if statements but couldnt get the parameter as the value.
Any help or advice would be great
adam

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.