Forums

Hello,

I am using Jomsocial and all the data is stored in their tables that I need. Basically I just want to extract data and present it to the user based upon their query. For example, radio button to select gender, drop downs to select other information, text box, check boxes, etc. I just downloaded CC and tested it. The part I don't understand is how to get the user's name for example and not the user id to present and make the user's name a click-able link.

Thanks,

Hi ddouglas,

I don't know how JomSocial stores the data so can't give you specific instructions. Typically, if there's a column called 'name' then you'd put {name} in the CC body section.

Bob

Hi, thank you for the reply. I know what table the data is in that I want to work with, but Jomsocial doesn't store user information in their tables. They are in Joomla's jos_users table. So, while I can get to the data within JS, I want to extract the user's name with that data as well. So, how would I go about extracting data from two separate tables? Hope I am explaining this correctly.

EDIT*********

Let me explain a little further if it helps.

There will be three tables involved.
1. _users table. It is where the field {name} will be to extract the users name.
2. _community_fields. This table has the field names. Example=Gender. I would extract this information.
3. _community_fields_value. This table holds other information that would be extracted as well.

So, with information in three different tables, how would I setup CC or Forms to do that?

Hope this helps.
Thanks,