Remembering Collapse states > store array var to db

[Kattouf]

I have many collapse regions on the page and i want to store their state in the Members table in column m_collapse_state. Probably as an array. I COULD do it with a separate joint table but i want to learn arrays

Basically i will assume they are open unless Item exists in array then close it.
When collapse/button is pressed, Update array and save in table.

I just can’t figure the update db logic yet.

I created an Array element, added click event to populate it . Got this far. How to save to db?
I tried adding an update server action but cannot choose the Array variable, need to pass that to the action somehow.

any ideas?

thanks

[Hyperbytes]

Hard to be too specific based on your info but basically you may be able to do what you want by

Define your server action to save the settings with the array passed as a GET parameter

Then in app connect, make a server connection and set it to No Auto Load and link your array in the parameter box as detailed below.

Then, in your dynamic event linked to collapse, load the server connection to save the details

[Kattouf]

Yupp that worked! thanks!

I was trying to do it with sessions but couldn’t figure out how the server sessions where related to the app connect sessions.

[Hyperbytes]

They are different, in app connect, session refers to browser sessions, in server connect they are server session, yes it is confusing

There is a feature request to allow access to server sessions from app connect if you want to vote for it

App connect component to access Server Sessions

In general Wappler offers an amazing array of methods for manipulating variables of all types within App Connect and Server Connect. However there remains two issues which I feel could be improved. Server Connect manages Server Sessions, APP connect also offers session management however these are browsers sessions. This can lead to confusion among users, particularly those new to wappler who do not realise the difference These is no way within App Connect to directly access a server sessi…

[Kattouf]

One more thing.

The Array var is now stored in the Db Correctly initially.

I then bind the Array Var to the db value. So it has a default value. thats working too.

However now the ADD Unqiue doesn’t work… doesn’t seem to recognize that the array var already has values pulled from the db

[Kattouf]

Nevermind figured it out, Had to use Split value. man so many things to discover