Create and link custom field 'Author' to CB user profile

Hello there,

i tried to follow this FC documentation under to create a custom field  « Author profile » that links to the Community Builder profile of the author of the article:
flexicontent.org/documentation/faq/71-fi...ent-item-author.html  

with prefix : 
< a href="index.php?option=com_flexicontent&view=category&layout=author&authorid=
and suffix :
alt="This author's content">More content from this author

but it did not work out ...  thanks in advance

what is html output ?

Hello,
well, as described i created a new custom field with « Select » field type
enable Use SQL Query with:  SELECT id AS value, name AS text FROM # __users WHERE id="{item->created_by}" as field element

the i removed space
in Frontend Display i’ve selected "value" instead of "text"
and as value prefix:<a href="index.php?option=com_flexicontent&view=category&layout=author&authorid=

as value suffix enter:" alt="This author's content">More content from this author


i also tried to use ‘Created by’ field core with same prefix and suffix values, but all of my custom fields values point to CB profil.

Destination URL is :  index.php?option=com_comprofiler&view=userprofile


Whatever I try, I can't get it to work!  Any clue?

Hello

i ll create the field suggested in the FAQ article
test
and correct the FAQ article if needed

 Hello,

i followed step by step every suggestions in the FAQ article but whatever I try to setup in the field settings, it doesn't work and I can't get it to display on every item page.

i've just send a PM

Thank you in advance.

Hello,

the field suggested in the FAQ article doesn’t work properly.
Every other field values were became selectable and display author’s profile when i click on it ... where the issue come from ?

- How to make Article's Author automatically displays on the article page (via the custom field) without having to select it in the form?

- how can i make language substitution for value suffix ‘More content from this author’?

Are you able to help me with this issue?

Hello

it is working now
i edit the field

1. viewing access to public instead of "super user"

2. viewing "value" instead of "label"
 thus you get correct the  ID in the URL ... www.miniatoys.net/fr/component/comprofil...ile/553-someusername

3. To make it simpler / automatic to save the author when ,
in the
Editing TAB 
then Form field TAB

set to hide the prompt "Please select"
thus the value (current author) is auto selected and you can just click save

Anyway the above will soon be redundant , will add link ability to our "Profile field" ...

Hello

a bad thing about the solution in the FAQ is that
- you need to create field when building of your website , because now you have to re-edit and re-save (once) all items ...

Also rare issue
- if you use a DB tool to massively change author ID of many item then you will need to resave too ... or manually update the field our field values table

Hello,
Thanks for getting back to me. I tried the above and I still have the same issue to solve : every other fields values are still selectable (in blue) and CB author’s profile opens when i click on it. Only « Author profile » field should point to CB profile.  is there a mistake in one of the values?

« set to hide the prompt "Please select" thus the value (current author) is auto selected and you can just click save »thanks for the tip but how to display login id (or author’s alias) instead of author’s name?

and  Is it possible to use language strings for value suffix?   

Hello

when you see such behavour that a link is extending too long ... it usually means it was not closed ...

In our FAQ article was bad in that ... the closing HTML TAG:
</a>
is missing

I have added to our FAQ article and i have updated / tested in your website
i have changed again the author field again to public,
you can recheck