Profile fields

Hi
I need to store some details in the users profile. Namely their dogs details which consists of 24 fields of data for each dog. Most of our users have more than one dog which I have done this using different tabs. The problem I have is getting the data out of CB so I can use it elsewhere i.e RSforms - normally I would use a separate database table for the dogs details linked by user ID and dogs ID. With my limited knowledge of SQL I cant think of a way of retrieving this info. Have you any ideas ?

That's going to be too many fields for CB. I highly recommend using an extension built for such a usage or having one developed. A form extension like RSForms could work and you can display their form data on profile using CB Query Field as it'll need to be queried from RSForms.

Thanks - I think. Not quite what I wanted to hear.
You say it will be too many fields for CB - what is too many?
I have spent a lot of time and effort to get this site 98% of the way I want it and it will be a shame if it all falls down at the last hurdle and I cant find a way to make this work as CB is an excellent program in all other respects.
As for using an extension that has been designed to do the job - I have been looking for a year I have not found anything suitable. The reason I started using CB is that (on paper) it does what I want and makes life easy for my users and for that I applaud you.
Are you sure that there is no way to extract the data I require to use in RSforms?

You say it will be too many fields for CB - what is too many?

If you only have 1 set of 24 fields you'll be fine, but if you need multiple sets it's going to add up quickly. Depending on the type of fields you use you'll be limited to about 1,000 fields. However, with that may comes performance problems. Your usage really calls for a custom plugin or separate storage table.

Are you sure that there is no way to extract the data I require to use in RSforms?

If it supports Joomla content plugins then you can use CB Content Bot to allow substitutions within RSForms. You can display RSForms form results on profile pages using CB Query Field as I assume the results are stored in the database. Beyond that there's not much more I can advise as we're not the developers of RSForms.

Hi
Thanks for the reply.

1000 fields ! great I doubt i will need more than 120ish.

Sorry my question was not specific enough, I was wondering if there is any way to use CB_query or something else to link two database tables.
i.e. If I create another table say "Dogs_Details" and store the dogs data in there using the user_ID and Dog_ID as reference.
Cheers
Mark

I was wondering if there is any way to use CB_query or something else to link two database tables.

Yes, that's specifically its purpose. You can output the results of a database query as a field. We've a few video tutorials below showing example usages of CB Query Field.

www.youtube.com/playlist?list=PLp0puRITgC7MM9iP9FooKB1qk8f5MLWVp

i.e. If I create another table say "Dogs_Details" and store the dogs data in there using the user_ID and Dog_ID as reference.

Yes.