I am trying to merge 3 clumns into a single column,
here is the logic:
I have a serial number table with:
- number
- prefix
- separation
I want to merge them into a single column named serial_number in the same table.
in another table of commands I will recover the serial_number in the controller, at store it will update the number + 1 in the table of serial numbers,
I tried to update the number and concatenate the 3 columns in the controller at each recording it works ,
but the problem is that the user can modify the order of the 3 columns in the settings.
is there a method to permanently merge and concatenate the 3 columns without doing it on the order controller so if the user changes the order automatically it will update the column serial_number ,