Link to detailpage

Resolved joeldault
(@joeldault)

11 years, 6 months ago

Good Morning, I am sorry but I have read every post I can not find my exact issue. I have some parts but not the whole. I can not seam to find the way to do it. if anyone can help me this would be greatly appreciated
Here is the situation.

1. a customer fills in a (order) from. This order from has 37 fields that need to be filled in. After the fields are filled in and the customer has hit the “Submit” button. The information then goes into the database.

2. Days later they come back and log in to the site. After they login, they are redirected to a page that has a table of it. This table list of all orders. This table has short condensed version of the of all there orders. There will be ten rows with each line representing a certain order only. Each row is a condensed version of the full order (meaning only shows certain fields.) What I mean is that each row will contain a File Number, Submitted, name, address, city, etc.
I have put a filed in each row that is a link to a filter page. When this link is clicked I would like the link to take the customer to a page that shows the full order information. This information is only for the one order. Not the full list of orders. I have created a link on each order (row) that takes you to a bank page. This page is the same page for all orders (rows).

Can some one please tell me how get the page that the link is going to show only the one order fill information on it. I have searched for two days and cant seam to get this to wrk

https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 10 replies - 1 through 10 (of 10 total)

Plugin Author Michael Simpson
(@msimpson)

11 years, 6 months ago

From the where where you are creating a link, include “submit_time” in the short code “show”. If you are using [cfdb-html] you can use that submit_time to compose a link to another page with a parameter like http://...&s=${submit_time}. On the target page, use a short code with filter="submit_time=$_POST(s)"

Thread Starter joeldault
(@joeldault)

11 years, 6 months ago

Thanks for your answer but I am still doing something wrong.

Here is a link to the first page

http://ptia.net/?p=947

Here is the code on that page:
<h6>Open Files</h6>
[cfdb-table form=”PLACE AN ORDER: Title Order Request” show=”submit_time,File Number,Submitted,Borrower/Buyer,Property Address,City,State,Transaction Type,File Status,File Details” filter=”Customer ID=PT0001&&File Status=Open”]
[/cfdb-table]
[line]
<h6>Closed Files</h6>
[cfdb-table form=”PLACE AN ORDER: Title Order Request” show=”submit_time,File Number,Submitted,Borrower/Buyer,Property Address,City,State,Transaction Type,File Status,File Details” filter=”Customer ID=PT0001&&File Status=Closed”]
[/cfdb-table]
[line]
<h6>Dead Files</h6>
[cfdb-table form=”PLACE AN ORDER: Title Order Request” show=”submit_time,File Number,Submitted,Borrower/Buyer,Property Address,City,State,Transaction Type,File Status,File Details” filter=”Customer ID=PT0001&&File Status=Dead”]
[/cfdb-table]

<script type=”text/javascript”>// <![CDATA[
(function ($) {
$(‘td[title=”File Details”] div’).each(
function () {
$(this).html(‘Full Details‘);
})
})(jQuery);
// ]]></script>

You can see the link in the rows next to the order information.

I click the link and I get an error

this is the second page or landing page
http://ptia.net/?p=903

This is the short code
[cfdb-html form=”PLACE AN ORDER: Title Order Request” filter=”submit_time=$_POST(s)” limit=”10″ orderby=”File Number”]

I cant figure out what I am doing wrong, It does not work. Please explain what I am doing wrong.

Plugin Author Michael Simpson
(@msimpson)

11 years, 6 months ago

You would need to use [cfdb-html] instead of [cfdb-table] (you can still make it a table, you just have to write the TABLE,TR,TD tags in the [cfdb-html] template. Then you get ${submit_time} replaced with an actual value.

Thread Starter joeldault
(@joeldault)

11 years, 5 months ago

I am sorry to have to ask this again. The following is what I have done but it is not working. Please help

First Page has this

[cfdb-datatable form=”PLACE AN ORDER: Title Order Request” show=”File Number,submit_time,Borrower/Buyer,Property Address,City,State,Transaction Type,File Status,Submitted”]
{{AFTER}}
<script type=”text/javascript”>// <![CDATA[
(function ($) {
$(‘td[title=”submit_time”] div’).each(
function () {
$(this).html(‘Details‘);
})
})(jQuery);
// ]]></script>
{{/AFTER}}
[/cfdb-datatable]

Second Page Has this

[cfdb-html form=”PLACE AN ORDER: Title Order Request” show=”File Number,File Status,Property Address,City,State,Zip Code,submit_time” filter=”filter=”submit_time=$_POST(s)”]
${submit_time}

[/cfdb-html]

Please help. I have worked all day and can not get this to work

Thread Starter joeldault
(@joeldault)

11 years, 5 months ago

Sorry This is the details
< a href=”http://www.ptia.net/?p=1308s=’ + $(this).html() + ‘” rel=”nofollow”>Details

Plugin Author Michael Simpson
(@msimpson)

11 years, 5 months ago

change

filter="filter="submit_time=$_POST(s)"

to

filter="submit_time=$_POST(s)"

Thread Starter joeldault
(@joeldault)

11 years, 5 months ago

First Let me say thanks for looking at my issue. This is the code and it is not working. I am stumped. Please can you tell me what I am going wrong

<script type=”text/javascript”>// <![CDATA[
(function ($) {
$(‘td[title=”submit_time”] div’).each(
function () {
$(this).html(‘< a href=”http://www.ptia.net/?p=1308&s=’ + $(this).html() + ‘” >Details’);
})
})(jQuery);
// ]]></script>

Plugin Author Michael Simpson
(@msimpson)

11 years, 5 months ago

How is it not working?

I do see that you don’t have a closing A tag and there is a space between the “<” and the “a” (although maybe you did that to make it appear right on this forum)

Thread Starter joeldault
(@joeldault)

11 years, 5 months ago

Good Morning, Thanks for asking and for all your help.
Below is the first page and the landing page. Yes the extra space in the link is so that it will show so you can see it. The extra space is between “< a”

First page:

[cfdb-datatable form=”PLACE AN ORDER: Title Order Request” show=”File Number,Property Address,City,State,File Status,submit_time”]
{{AFTER}}
<script type=”text/javascript”>// <![CDATA[
(function ($) {
$(‘td[title=”submit_time”] div’).each(
function () {
$(this).html(‘< a href=”http://ptia.net/?p=1308&submit_time=’ + $(this).html() + ‘” >Details’);
})
})(jQuery);
// ]]></script>
{{/AFTER}}
[/cfdb-datatable]

The second page is the following (landing page):

[cfdb-html form=”PLACE AN ORDER: Title Order Request” show=”Submitted,File Number,File Status,Your Name (Submitters Name),Your Company Name,Company Address,Company State,Company City,Company Zip Code,Fax Number,Company Phone Number,Company Fax Number,Email Address (Submitters Email),Date,Property Address,City,State,Zip Code,County,TaxID #,” filter=”submit_time=$_GET(submit_time)”]

It is working fine. Thanks for your help.

There is one thing that I am noticing however.
When I view the page on my windows computer (internet explorer), the link called “Details” show fine. This is the same for safari (apple computer). It looks ok when I look at it on my Mac Computer

The issue I am seeing is that when I look at the page on my ipad. The link does not show right and the link does not work. I have cleared the history and cookies. I am not sure why it is doing this. It is only on my ipad.
Any suggestions.
Plugin Author Michael Simpson
(@msimpson)

11 years, 5 months ago
I created my own example and I think I see what you mean. I think this is a jQuery on IPad/IPhone problem.

You can try this alternative code but I think you will still have the problem. I don’t know if there is a work-around.
```
[cfdb-datatable form="PLACE AN ORDER: Title Order Request" show="File Number,Property Address,City,State,File Status,submit_time"]
{{AFTER}}
<script type="text/javascript">// <![CDATA[
(function ($) {
$('td[title="submit_time"] div').each(
function () {
      $('<a>',
        {
        text: 'Details',
        href: 'http://ptia.net/?p=1308&submit_time=' + $(this).html()
        }).appendTo(this);
})
})(jQuery);
// ]]></script>
{{/AFTER}}
[/cfdb-datatable]
```

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Link to detailpage’ is closed to new replies.