I have a single lead capture form that just collects, name email company and phone.It is referenced across about 100 individual product pages.

I am collecting the $CurrentURL to get some specific data so we know what the interest is, which is then put into a CRM.

However, once it gets into the CRM, it has just the URL, /Default.aspx?tabid=56, which is basically useless to the sales person without actually clicking the link. It would also be handy if it were put into the CRM as Widgets 1.0, so when we upgrade we could find all leads that were interested in that product.

What is the best method to get info from the page into the form? The page title would even provide better data.

Thanks,

Ben

Hi Ben,

I think the important information here is the tabid. So you can get it as a single number (without the Default.aspx thing) by adding a hidden field to your form. This field must have the short name tabid. And you select the option "Retrieve values from querystring variable for this question" for this field. So this field will always have the tabid-number as its value and you can refer it in the form completion event.

If you use a form completion event of the type "Dynamic SQL Statement" you can use following statement to get the page name to the tabid:
SELECT TabName FROM dnn_Tabs WHERE TabID=$(tabid)

You can also pass the value of the tabid-field to a stored procedure and the procedure gets the page name for you using a similar SQL statement.

But an very easy and direct way would be:
You call every page with a parameter DSParam1 and use the "Initial SQL Rendering/Bind" of the form to write the page name directly into a hidden field inside your form.

Example:
You call your page with the address: .../default.aspx?tabid=56&DSParam1=56
(value of DSParam1 equals the value of tabid)

Now add a hidden field to your form ... lets say that you give it the short name MyPage.
Now you activate the "Initial SQL Rendering/Bind" in the form settings and add following SQL statement:
SELECT TabName AS MyPage FROM dnn_Tabs WHERE TabID=$(DSParam1)

Resullt: the value of the hidden field "MyPage" is the page name.

Unfortunately, you cannot refer $(tabid) inside the "Initial SQL Rendering/Bind", but with $(DSParam1) it works.

I hope this is helpful.

- J.

I found an alternative using JavaScript:
You can parse it directly from the HTML code of the page using the value of the breadcrumb on your page. Just have a look in the source code of your page or DNN skin.

In my page skin the breadcrumb is written in a span-tag with the id dnn_dnnMLBREADCRUMB_lblBreadCrumb.
Now I just add a (hidden) field with the short name MyPageName and after that I went to the form settings and add a "Initial Javascript" to the "Custom Javascript File" section. A JavaScript like:
$(MyPageName) = document.getElementById( 'dnn_dnnMLBREADCRUMB_lblBreadCrumb' ).innerHTML.replace(/<(?:.|\s)*?>/g, '').replace('&nbsp;', ' - ')

The JavaScript gets the HTML code out of the span-tag, strips all HTML-tags and replace the spaces (&nbsp) between the entries by " - ". The result is the complete path in your menu structure with all page title from root down to the current page.

If you don't have such a span-tag you can add it into your skin yourself.

- J.