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.
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 |
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.
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. :)
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. :)
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.
Thanks jgarcia! I'll let you know how this works.
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!
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!
I don't see the field in "Submission" you listed in Step 5.
That is in the form's Settings?
That is in the form's Settings?
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.
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.
I went through your instructions, but I don't see the "Method of specifying which item to display" under "Submission" in the form setup.
Any updates to this? I wasn't able to find the submission setting you mentioned in Step 5.
Thanks!
Thanks!
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
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
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!!
Sorry about the confusion!!
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
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