Condition for action based on the match between tables

AppSheet AppSheet Q&A
1

I have two tables that work as follows:

TABLE A - registry where all the data is and all users have access to the data.

Gusta55_0-1741094829043.png
Gusta55_0-1741094829043.png496×125 2.51 KB

TABELA B - serves as a FILTER where only the data that was transferred from TABLE A to TABLE B through an ACTION.

Gusta55_1-1741094896195.png
Gusta55_1-1741094896195.png388×108 1.38 KB

When making this transfer, the respective row bring the email of the user who triggered the action, the idea is that each user only the rows that have their email.

This data can be freely included and deleted by user and he will have a filter with only the data that interests him at that moment.

It turns out that I need a YES/NO formula to apply to the CONDITION FOR ACTION, so that the ACTION DOES NOT APPEAR when the data corresponding to the same NAME and the interested user are already in TABLE B.

This formula worked - NOT(IN([NAME],LIST(TABLE B[NAME]))) - to condition the ACTION only to the NAME, but I’m not able to resolve the issue to the FILTER the user.

Can anyone help me?

2

Why copy the data? You can filter existing tables to the current users’ entries in 3 ways:

  1. Security Filters - set a filter at the table the level that only downloads entries associated with the logged in user. View uses normal table but since table only loaded rows for the logged in user, that is all they will see.
  2. Slice - Insert a Slice that filters data from a source table based on the logged in user. View then uses the Slice so user only sees their rows.
  3. Filtered View - a user taps a button to activate the filtered view function (LINKTOFILTEREDVIEW()) - view uses normal table but this function filters the rows based on filter criteria you specify in the function.

For all of these, and likely your expression to copy…if still wish to do that, the YES/NO expression to filter based on email is typically:

[Email] = USEREMAIL()

This does assume you are using a secured app where the user is authenticated and therefore the logged in users’ email is known to the app.

I hope this helps!

3

Thanks for your help!

I need to copy the data because the initial table is collective and the data inserted by the administrator.

The data will be private at the moment of transfer, in this case, the data will include the user’s email.

The TABLE B already have the security filter that you referred to.

My need is for the rows not be to transferred twice.

Thanks