Hey there @Katunga ,
I remember long ago sharing this with the forum:
Hello there,
We know the struggle with retool tables when we want to provide users a more excel feel with calculated columns updating upon values on other columns being updated, without necessarily having the query updating the backend database. This is arguably doable with having a variable as the table's data set, but it gets tricky when you want to undo, or remove a change, etc.
As such, for one user case I'm working on, I thought to set up the functionality for users to download a formulat…
It provides a way to format an excel file, including formulas. So this may be a good way for you to consistently and programmatically download an excel file.
Hope this helps!
Best,
2 Likes