Save last username that modifies data

Question

Hello, well , I can retrive the username that its logged in, so I want to save that username to my table everytime the form its saved.

In the section On Load I put a Custome code with this:

<?php
$user =& JFactory::getUser();
$form->data['name'] =& $user->name;
?>

Then I put in the Designer a textbox (name) and the username displays there everytime the Form its loaded, everthing works fine so far.
Then I create a new column in my table= "name" so when the form its saved the username saves there.
But it doesnt work , form saves everything except the username😟

Please help!

Save last username that modifies data image 1

Save last username that modifies data image 1

Save last username that modifies data image 2

Max_admin · Accepted Answer

Easiest solution is to use v7 and in the "Save Data" action, use the "Data sources" advanced setting, then add a new table field "name" and set the value to {user:name}

Save last username that modifies data

Save the logged-in username to a database table when a form is submitted.

Overview