I have just produced my first data table can't fathom out how the recognize links feature works. One of my fields is Username and I want to link this to the person's Community Builder profile which, for one of my dummy users, Kermit the Frog, whose username is kfrog, is in the form [domain]/index.php/cb-user-profile/userprofile/kfrog. How do I do this? The options given are just Blank, Self, Parent and Top. I have no idea what these options mean but none of them lead me to the URL I want and I can't see where I put the link to [domain]/index.php/cb-user-profile/userprofile/[username] and indeed what the variable at the end needs to be to link to the particular record.

Also my table only takes a few of the fields in a particular record. How do I link the primary key field to the one whole record with all of the desired detailed fields populated?

I am quite comfortable with SQL but know very little about php and html so please be gentle with me!

Hello,

If you want to convert username to a link and username is stored in "Username" column, set "Columns settings -> ID" parameter to Username and "Columns settings -> Format" parameter to the following value:

<a href="index.php/cb-user-profile/userprofile/{$value}">{$value}</a>

Regards,
ARI Soft

Many thanks for this. Happy to say it works.

Best wishes

Frances