Writing an expression for an action to move row from one data table to another

[Shirlene_Clark]

I am pretty new at Appsheet so need some help with writing an expression for an action.

I want to have an action where a complete row in a table is removed from one table and placed into another table.

The table in my App shows the order in which people are to wait in a queue for entry to an event (each row is a person in the line and their  details).  I want the person monitoring the queue to be able to push an action button in the App which moves that person (ie the whole row of details ) to another table once they have gained entry into the event. 

I have not had much experience in writing expressions.

[TeeSee1]

You should familiarize yourself with actions by first reading this article.

It seems that you need to create three actions.

1) to copy a row from table A (source) to table B -> Data: add a new row to another table by using values from this row

2) to delete the current row -> Data: delete this row

3) Grouped action to fire 1) and 2) -> Grouped: Execute a sequence of actions

Hope this will get you started and good luck!

[Shirlene_Clark]

Thanks your reply makes sense to me.

I am able to set an action for Data: delete this row

But I am getting a warning when i try to copy row from one table to another.

[TeeSee1 · Accepted solution]

As the warning says you have to specify at least one field to copy under set these columns

[Shirlene_Clark]

Thank you so much TeeSee1.  I got it to work just how I wanted.  Thank you so much