Help with Table and user to save Column selection and order

💬 App Building
,
1

My gold is to allow users to create there own view in table by

  1. Order table columns according to there needs and preferences and then save this to localStorage with user id.

  2. Select Columns to show in table by using a Checkbox group

As this is not out of the box solution and my limited development knowledge, specially related to JavaScript I'm hoping there is somebody in the community that can help me with a solution.

Table name: "list_items"
DataSource: "Get_items" (SQL query)
CheckBox group source: checkboxGroup1 {{Object.keys(formatDataAsObject(Get_Items.dataArray))}}

I have trayed to use ChatGPT and it referring to dynamic setting for the table.

image
image234×283 5.03 KB

I have created a Transfermer JS query:

const defaultColumnConfig = [

{ key: "itemID", Label: "Item", hidden: true},
{ key: "rowID", Label: "RowNo", hidden: false},
{ key: "DueDate", Label: "DueDate", hidden: false},
]

Here i'm lost

I hope that there are somebody that will help me with a Solutions and step by step guide?