Enter data in slice to Google sheet

[Supershai]

We have an attendance app. In that app, we have

1) the student table;

2) the present student table.

3) Absent students table.

What I have done from the students table is that whatever students are present, when I mark them present, they are all going to present slices using these slice expressions. [Status]="Present" and rest in the absent slice using these slice expressions. [Status]<> "Present." Now what I am trying to do is have all the students in the absent slice go into the absent table automatically when I submit the attendance.

[TeeSee1]

I am a bit confused here.

So you have Students table, Present Slice and Absent Slice.

Students marked as Present are shown in the Present Slice. The way you have set up your Absent slice displays all the students who has a NON present value. Are you saying you have a separate Absent table and you want to copy the students displayed in the Absent slice copied into this Absent table? 

I wonder why you even want to do that. You can already identify non present students in the Absent slice, assuming of course you have a date column.

Copying multiple rows can easily be done either by a bot or bulk action.

Providing more info as to you requirements would probably help the community to give you better guidance.

[Supershai]

Thank you for replying. But bit confused I know I have a absent data already in Absent slice. but just don't know how to write the expression to send the data to table with bot or action. Row by row with attendance ID from absent slice.

[TeeSee1 · Accepted solution]

Run an action of this type (add a new row to another table using the data from this row) for the slice

[Supershai]

Thank you. Now I am able to add the rows from the absent slice when data change. But bot add the same student multiple time ( Like if i have 5 records in absent slice the bot repeat the first student 5 time). I need help to write the Referenced rows in bot run action on row to add all rows.  

[Supershai]

Thank You @TeeSee1 for all your help. The problem has be solved.👍