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
)
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
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |