Columns Order in Database Re-Shuffles

Ask the community
,
1

I have created my very first contact form using code. It works great, and I even connected to an email notifications service. However, given the fact it was my first functioning contact base I added and removed columns constantly until I got the ideal set-up.

Unfortunately, even if I properly order the columns in a logical chronology (Name, Surname, Email, Phone, Message… etc…) both Sandbox and the live versions - it keeps shuffling back to an illogical order… probably has to do with the order I created them in the first place. It just reboots the order.

This is not ideal given the fact I’ll have to explain my client that in order to export the list he’ll have to re-order the database every time??? Is there a way to overcome this before I recreate the Database?

2 Likes
2

Hi again Naama,

This not really a code problem, rather it’s more of an issue with the Wix Content Manager. I would suggest you contact the Wix support team . They’ll be sure to better understand non-code issues such as yours.

Oh, and be sure to share with all of us the answer. :smiling_face:

Yisrael

3

Hey did you figure this out? I am having the same exact issue. I have a pretty extensive database that needs to be organized so that when I export the output to csv it’s a bit more readable and not as jumbled. Let me know. Thanks!

4

You need to export the whole database, then rearrange your columns. You then need to import the new database and use that. I had a database with 100 columns and this is how I had to do it.