Update a field from Community Builder
Due to the flexible nature of RSform!Pro you can even update a field from a third party table. To do this, you will have to use a script, placed on the Scripts called on form process area:
$db =& JFactory::getDBO();$user =& JFactory::getUser();
$uid = $user->id;
$db->setQuery("UPDATE #__comprofiler SET cb_audio1 = '".$_POST['form']['audio']."' WHERE user_id = '".$uid."'");
$db->query();
The above script will update a field named cb_audio1 from the _comprofiler table with the value got from a form value, named audio.
