[Tuturial - use @SELECT and checkbox tv to populate pulldown listmenu tv

I use the foloing code to make a puldown list that is filled by documents where another tv checkbox is set to yes
I used it to select 3 (I made 3 tv’s with the same code but differend default selected) info screens on each page that links to that page(will be online soon then I can show you all)

this is a @SELECT using join:



The above gets me all page id’s and pagetitles that have tv with id 4 set to "yes"

Dimmy

Nice

Looking forward to online example!

Truly impressive Dimmy.

1 more post Dimmy...you can do it!

Hi Dimmy,

I’m just curious on a use for your @select code which I really like a lot. Perhaps, you have already accomplished the below with it?

I’m trying to create a link based on what is selected, but can’t figure out how to retrieve the pagetitle? The output of the TV is the id for the selected item, but I’m trying to figure out how to set the anchor text based on the ID.

So, if I choose Product #1 from the select box, which has an ID of 17, how would I get something like <a href="[~17~]">Product #1</a>?

I hope you might have an answer. I was thinking this may be something possible with PHX?

You can use the getField-snippet to get the fields with &field=`thefield` from other resources. default for &field is pagetitle.




or if you want to use it in a ditto-chunk:

I used it like Bruno describes it.

this is the site where I used it:

http://www.qredits.nl/over_qredits/wie_is_qredits.html

on all pages you see 3 (or less) circles on the bottom those are set using the select in the tv and then in Ditto I used the getfield stuff.

and I update the select a bit so it only get docs with a certain template.




Dimmy

Works perfectly. Thanks guys.