I have a dynamic column in my retool table. When i tried to use the column reorder event. The specific columns are either moving to the end of the table or creating a duplicate column

I have a dynamic column in my retool table. When i tried to use the column reorder event. The specific columns are either moving to the end of the table or creating a duplicate column.

In my application, I'm trying to save the column reorder into local storage and show the same order to the user on the next login. Somehow, this isn't working as expected. Can anyone help here please!

1 Like

Hi @Jyothi Thanks for reaching out! I haven't been able to reproduce this yet. Any chance you could share screenshots of your table & event?

Also, what version does it say in the ? button on the bottom right corner of the editor?
CleanShot 2024-11-05 at 10.28.12@2x

1 Like

Hi @Tess ,
Retool Version:
image

Events:
image

Getting Column Order(retriveColOrder):
const columnOrder=table1.getDisplayedData();

Returning keys to get only the column names
const keys =Object.keys(retriveColOrder.data[0]);
return keys;

Saving the order in local storage
const tableColumnOrder = query13.data;
localStorage.setValue('tableColumnOrder', tableColumnOrder);

Setting up column Ordering
table1.setColumnOrdering(localStorage.values.tableColumnOrder);

Reordering is working fine. But when i try to reorder the dynamic columns, that specific column and the source column are moving to the end of the table.

Dynamic Column:
image
Here, VW_SUM_STREAMS is the source column and is having the format as 'progress'.

Please let me know if you need more details.

Thanks!!

1 Like

Hi @Jyothi Thanks so much!

We shipped a fix, but the version you're using doesn't have the fix yet. I can manually add the fix to your org, but I'm having trouble finding it based off of the email you use for the forum.

Could you add your Retool org email to your profile, if it is different, or could you DM me your license key?

1 Like

Hi @Tess ,

I've added org email address to the profile. Please try to add the fix and confirm once it is done.

Thanks!!

1 Like

Thanks so much! I'll follow up when I have an update from our team internally on getting it added :blush:

1 Like

Hi @Jyothi,

Just checking in here. Unfortunately, adding this particular fix ended up being a bit more complicated. I am still working with our engineering team on getting you access, but I'll keep you posted

1 Like

Thanks for your patience! We added the feature to your organization :slightly_smiling_face: It should be available after you click the "Check Key" button on the Settings > Advanced page in your Retool instance, or wait 6 hours for the next automatic license key refresh.

Hi @Tess ,

Thank you very much for the update!

I've tried testing the column reordering after the "License key refresh". But, I'm still facing the same issue. The Dynamic column(source and target columns) are moving to the end of the table.

Please let me know if anything need to be fixed or to be added from my end.

Thanks!!

:thinking: Thanks for letting me know; I'm sorry to hear it didn't resolve the issue! I'll do some more testing & check in with our team.

In the meantime, if your team happens to upgrade, I'd also be curious if you're seeing the issue on the newer version

Hi @Jyothi,

I still haven't been able to reproduce a bug that persists with the feature I added to your org :thinking: :disappointed: Any chance you could share an app export in a DM for us to research further?