How to create a field that links to a category

You can create a field (J1.7+) that displays a category select box in item form and a link to the category at frontend views.

1. Create a select field

2. enable Use SQL Query

3. as Field elements enter

1

SELECT id AS value, CONCAT(REPEAT('-',level),' ',title) AS text FROM `# __categories` WHERE level>0 AND extension='com_content' ORDER BY lft

NOTE above remove space from # __

4. enable Remove space

5. as Frontend Display
select "value" instead of "text"

6. as value prefix enter:

1

<a href="http:://mysite.com/index.php?option=com_flexicontent&view=category&id=

7. as value suffix enter:

1

" alt="Display category">Some text</a>