[SOLVED]Several data in table form

Hi i'm italian and probably i will not write correctly but i hope you will understand me
I'm using joomla 1.5.7 CB 1.2 (i use community builder to manage useres)
I create one form with wizard to store sport events result (cycling): The form contain event name, date, relative position, absloute position. I have connected one table but i see that there is only uid and not username used to log in (CB username). It's possible to view also this field (and others) in the table connected?
Another question: is possible to not submit the form only for guests bust only fors registred users (using an error/warning message)?
Is possible for every user to see in frontend (using one menu link) its own form submittend (the user can view nly its form and not the form of the other users)?
Thanks for yours answers (i lost many hours to try to solve these problems...)

Mauro

Hi Mauro,

Lets go through it 1 by 1, when you are trying to create the table, can you take a screen shot and show me here ? you should have a list of many fields, including those you listed at your post here!

Regards
Max

ok i try to do all you need to help me
i did one from with
event name (nome gara)
event type (tipo gara)
Data (date)
Cyclist Category (categoria - in italy)
Category position (pos. categoria)
Absolute position (pos. assoluta)

i created a table (jos_chronoform_classifica) and i connected the table in DB connection

will follow the 2nd part...

in the table field (jos_chronoform_classifica) there is not the USERNAME but only uid
I tried to submit this form but i had not found all the data in the table...
However i dont know how to show username into the table...
it's enought for help me?

ok i understand how the data does not appear: i have not chek the fields creating table connected...sorry...
but there is not username (the same of joomla registration or community builder registration)
To export this component in excel is very easy and the result is perfect!
your work is great!

Hi Max
can you help me?
Thanks

Hi supermambanero,

I was away, If the field username doesn't appear at the create column page then you don't have a field called "username" in your form code, do you ?

Regards
Max

Hi Max
i put into the form the username field (text) but i wuold like tha username was the same of joomla registration (i wuold like this field was complited aumoatically and not by the user)...
Have you understood me?
I hope yes...
Regards

Hi supermambanero,

so you have a field called "username" in your form code ? and you want to add some value to it automatically ? how do you want this value to be generated ? I mean from where it should come ? will you have the user logged in to Joomla when submitting the form and so you want his username at joomla ?

Regards
Max

Hi Max
yes the joomla form will be available only after logging in . so I want the username field be filled with the same username used in the previous logging operation.
Can you suggest me anything to achieve my goal?
Best regards

Mauro

Hi supermambanero,

Please see this post for info on getting the logged in user's details.

Bob

Thanks so much!
It works!😀
You are great great great!

Mauro