Delete all row of a table A after add a row in a table B

Hi, I try a lot but I’m not able to to this.
I would add a row in a table B and after this delete all row of a table A.
Table B and A aren’t type ref so tables aren’t collegate by a key.
I would easily delete all row.
Is it possible?

Hi @King_Italiano

Without knowing more about what you are trying to achieve, I would suggest to use some grouped actions, one or various “trigger” columns, and some FILTER expressions in order to identify the rows you are trying to move.
For actions between various table, if you have no ref column that can be quite tricky.

Can you be more specific on your use case ?

2 Likes

It’s difficult to explane in some row but i can try.
I have one table (A) that save the foods that I eat for example during dinner with them calories.
For example 70g of rice, 50g of poteto etc… In another table(B) i use the total of calories to make some operation for my diet and then i save the row but when i save this row i want to delete from the table(A) all the row so i can add aliment for the next moment that i eat food and make different operation.
So when i save the row in a table B i delete all the rows in the table A.
Maybe i should use a bot?

Hi @King_Italiano

Ok, thank you for clarification of context.
(For further notices, please identify me with “@” so that I get a notification)

I don’t think you need any bot or action to do so.
Just, make a parent table that will be your meal lists.
A child table with ingredients & quantities, and a virtual column to calculate calories.
I assume you already have a ingredient table with calories per quantity of food ?
and that’s it.

Actually it’s pretty similar to any order app, in my opinion.

You may find useful informations here:

2 Likes