How to create a field that links to contact page of current item author (requires saving item form)

You can create a field of type "select" that when displayed in frontend, it automatically links to the contact page (or community builder user details page).

1. Create a select field

2. enable Use SQL Query

3. as Field elements enter

1

SELECT id AS value, name AS text FROM # __contact_details WHERE user_id="{item->created_by}"

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="index.php?option=com_contact&view=contact&id=

7. as value suffix enter:

1

" alt="Contact">Contact this author

8. Disable Use first option