AutoAction for formatname

Hi, I set a AutoAction to update the field "FormatName". When it is executed returns this error

Unknown column 'formatname' in 'field list' SQL=UPDATE `#__comprofiler` SET `formatname` = 'NomeSecondo nomeCognome' WHERE `id` = 413

I would like to know how I can proceed.
Thank you

You can't update formatname field. It's not stored anywhere and simply outputs name or username based off the name format parameter in CB > Configuration > General. You'll need to update Name, First Name, Middle Name, Last Name, or Username as needed if you want to adjust its output.

Because I use as a CB setup "Firstname" "Middlename" LastName "could fit action with this query?
I need to update the field without having to upgrade profile because I have an action that controls whether the fields Name, Middle Name, and Last Name are formatted with the first Uppercase letter.
For even update FormatName field should move from the edit profile, otherwise remains formatted as the user wrote.
From my tests it seems that the query works well and updates the field as they are set in the fields Name, Middle name and Lastname. I want a confirmation from you, thanks

Don't understand the need for this. You can override what formatname field outputs using the Layout parameters. You can uppercase first letter of each word strictly using CSS as well (e.g. text-transform: capitalize;). The Field action does not fire profile update triggers either so you can safely use it to modify those fields as well.