Action on filtered view to add to another table

[EmadK]

Hi Appsheet,

We are creating a prototype where students are listed in a table from a form search (filteredviews).

Search form:

The above form has a Form Saved event to execute an action FiIter Family:

LINKTOFILTEREDVIEW("Show Family", [Family ID] = [_THISROW].[Family ID])

(view name is Show Family)

Action Filter Family

Each filter row has an action button “Request Pickup” which adds the current filtered row data to another table.

Action Request Pickup

Data added to another table


What I am doing wrong?

Thank you :]

[mateo]

HI @EmadK
Is the [Student ID] column, ID column in the Student’s table? If so, maybe instead of [Student ID] in your Request Pickup action try to use [_THISROW] combination.

*I am just thinking, not sure I am right.

[EmadK]

Hi @mateo ,
Thanks for your answer.

[Student ID] exists in Pickup Plan table (the database)

Pickup Record is a log of entries where the ID is a unique ID because this sheet will have many days.

I tried THISROW but no luck, it’s still inserting the same [Student ID] for all students in the filtered view.

[_THISROW].[Student ID]

[mateo]

@EmadK it may sound funny but maybe try to rename (just for testing) the [Student ID] column in the destination table. I had few situations where renaming columns solved my problems.

When I look at this what you attached I cannot see the error -after whole day on platform my mind is a bit tired it can be a reason as well ..

*maybe you could also share how those tables’ structures look like?

BTW I am sure there are other users who could help you too. Let’s wait for them.

[Steve]

Have you solved this?

[EmadK]

Hi Steve, I wasn’t able to solve it with the above approach.

I tried a different approach with a filtered dashboard and it seems to be working now.