I have a MySQL table like this:

and I need insert get_current_user_id(); in the column PRODUCER ID when the user adds a new entry but no way.

I tried with Transform Value but no way.

Also I tried with this snippet:

function filterColumnIDValue( $columnIDValue, $columnKey, $rowID, $columnID, $table_id){
// For specific table id - in your case 26
if ($table_id == 26) {
    // Filter for specific name of the column that contains unique values (origin header* of the column) - in your case 'JUPAS Code'
    if ($columnID == 'producer_id') {

            $columnIDValue = get_current_user_id();
        }
    }


return $columnIDValue;

Any help is welcome.

Many thanks.