variable username save to mysql

Hello,

First of all, I am newbie in chronoforms. I have been looking a lot of documentation but I don't see how can I save it.

A month ago, I have been working with chronoforms v4. Now I am using v5.

I have a problem that I can't solved. It is:

My environment is:
-PHPMYADMIN (MYSQL) + Joomla 2.5.16 + ChronoForms v5.
-From ChronoForms I can write to the mysql database from the form without problem.

My problem:
-I would like to add a registry "username" into the table 'guies' where I have the column 'usuari' when I click to submit button (DB Save).

Ideas:
-I have been testing with a "Custom Field" with this custom code:

<?php $user =& JFactory::getUser(); ?>
<?php echo $user->username; ?>

I can see the username in the form, but I would like to be hidden and insert to the database. Then, I have tried several times with hidden fields, but I am not able to save it.... Maximun I put the value JUser, but in the db appears two lines (in this case, I have two db record)

What can I do?

Thank you for your help!
Aitor.

Hi sloanthrasher,

I have tested and now works!!

I have pasted your code in a custom field in setup view (before submit)

Thank you very much!!
Aitor.