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 ?

0 7 1,434
7 REPLIES 7

LeventK
Participant V

@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
)

hello,

 

Great info

 

If i have a inventory database that have been updated, how can i make a list whit the new elements, i need this info because in the same aplication i have another table withthe same inventory data but it have photos and some other info.

 

Regards

 

Please start a new topic for help with this.

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!

i have an unique identification id, that is the inventory id of each item, what could be the instruction for that?

 

Regards

Good Day

There is some other important info that i forgot to tell and is really important, database have 43000 rows and 60 fields and the CSV import take about 3,5 minutes.

Regards

Top Labels in this Space