How we compare between two tables

The appsheet have two tables.
In the first table there are the list of all people.
In the second one we register the people who do something.

How we can know which people still don’t do something ?

@TONI
If you create a reference between the 2 tables, than you know which user does not have an assigned duty or not. Let me summarize:


TABLE 1 - USERS


Column Name UserID First Name Last Name Related Tasks Assignment
Column Structure Physical Physical Physical Virtual Virtual
Column Type Key, Text Name Name List Yes/No
Initial Value UNIQUEID()
AppFormula REFROWS(“Tasks” , “UserID”) COUNT([Related Tasks])>0
Row1 u001 John Doe t001 , t002 TRUE
Row2 u002 Jane Doe t003 TRUE
Row3 u003 Tony Bose FALSE
Row4 u004 Kim Bassinger t004 TRUE

TABLE 2 - TASKS


Column Name TaskID UserID Task
Column Structure Physical Physical Phsyical
Column Type Key, Text Ref Long Text
Initial Value UNIQUEID()
Ref Table USERS
Row1 t001 u001 Do this
Row2 t002 u001 Do that
Row3 t003 u002 Take notes
Row4 t004 u004 Call Elizabeh

When your tables are set similar to this; you can query if a user have assigned to a task or not simply with a de-ref expression from the TASKS table like this:

IF(
    [UserID].[Assignment]=FALSE,
    "True Value", //if the condition evaluates to true
    "False Value" //if the condition evaluates to false
)

You can query if a user have assigned to a task or not simply with expressions like below directly from the USERS table like this:

IF(
    [Assignment]=FALSE,
    "True Value", //if the condition evaluates to true
    "False Value" //if the condition evaluates to false
)
1 Like

If the user name is unique, how about People[Name] - Task[Name]

Master I had also thought that but later on realized that they might be creating multiple records on that TASKS table and user name might not be unique. As I always said, you are one of a kind level indeed!