Is it possible to hide columns in Google Sheets for individual users?

Question

JavaScript

There is a table with a large number of rows and columns and several people who work with it at the same time (view and change).
Each person works with a limited set of columns and the rest of the columns interfere with him. But if someone hides the columns that he does not need now, then for everyone else these columns will also be hidden.
Google Sheets has the ability to do "filtering modes" ( https://support.google.com/docs/answer/3540681) when the filtering result is shown only to the user who selected it. I did not find the same for columns, placing information horizontally is also not an option.
Google Sheets has the ability to import data from one sheet to another. Those. it would be possible for each person to make a set of columns convenient for him. The problem is that the data needs to be edited and different people need to be able to edit the same columns. Those. editing with standard formulas can only be done in the general table.
Is it still possible to hide the columns so that other users do not suffer? Or is it possible to two-way link cells on 2 sheets so that editing on one is displayed on the other and vice versa?

Answer 1

const
  [  name,   price,   number ] =
  [ 'name', 'price', 'number' ]
    .map(n => document.querySelector(`input[name="${n}"]`).value.split(', '));

const arr = name.map((n, i) => ({
  name: n,
  price: price[i],
  number: +number[i],
}));

Answer 2

what does not work?