Hi Paul,

I am sorry, but we don't have an easy way to recover formulas in a situation like that.

It depends what you changed in your Query exactly, but if the formulas got lost, then you must have changed something in the column structure, or similar.

Basically, our formula columns are not saved in the Database, they just exist as dynamic fields made by our Plugin's logic in our table.

And when it comes to SQL Query based Tables - they also do not create new tables in your Database, but they are rather only calling the data from existing tables.

Only when you make a Manual table in our Plugin, that creates a new stand-alone SQL Table in the database with its own set of columns+rows, but for them too, the formula columns are not saved in the DB, the same way as for any other dataTable.

To recover it, the only idea we have is to try reaching out to your Hosting Support and ask if they have a backup from the time before the issue happened.

But then again, if you have to change your Query in the same way to lose the Formulas/change the column structure which was needed for the Formula column(s), it would happen again and you would need to re-create the formula(s) which got affected.

Hi Paul,

Sorry, just forgot to add a way how you can check which SQL table is being called in each Query.

So, in any "FROM" statement in your Query, or if you do any JOINs, basically any SQL table names you call, are the tables from which the data is only being called from and these tables exist in your Database.

So you can find them via PhPMyAdmin or any other DB management Tool - but our Formula columns are not stored in the DB table - as explained in the previous reply, they are only dynamically existing in our Plugin table as long as you keep the same column structure;

if any column which is used in a Formula, let's say if it's a simple  : Column A + Column B;

then if you delete or rename header of Column A - the formula breaks.

Maybe you can try this, see if the hosting has a backup, then revert the Site to previous state;

then you can edit the Formulas and exclude any Column name which will be changed;

then when you change the Query you can re-edit the Formulas and add any new columns in them.

That is the only safe way I can think of at this time.

I hope it helps.