one staff will enter the one time in atttendance app in one day didnt show the another name

AppSheet AppSheet Q&A
1

one staff will enter the one time in atttendance app in one day didnt show the same name

SELECT(Employee[Email],AND (USEREMAIL()=[Team head],[_THISROW].[Date] = TODAY()))

2

Hi @naveenkumardnk2

What is your question ? What do you see and what did you expect to see ?

2 Likes
3

my app in dropdown will enter the names staff will enter the name in per day didnt show the per day ady will enter the same name.

naveenkumardnk2_0-1670906347353.png

DIdnt show the same name in today dATE.

4

Can you check about your data set ? And can you please answer the question:

Also, can you use a proper translator ? I would suggest this: https://www.deepl.com/

1 Like
5

naveenkumardnk2_0-1670913857609.png
naveenkumardnk2_0-1670913857609.png1743×724 65.9 KB

naveenkumardnk2_1-1670913887340.png
naveenkumardnk2_1-1670913887340.png694×445 9.9 KB

SELECT(Employee[Email],AND (USEREMAIL()=[Team head],[_THISROW].[Date] = TODAY()))

6

NAME: Should not be repeated on the same day in only one instance user Did not display the dropdown in the same name in the current date in the attendance app.
I’ll use the select query to determine whether an employee’s name is in the Attendance table only if the Team Head enters the employee names.

SELECT(Employee[Email],AND (USEREMAIL()=[Team head],[_THISROW].[Date] = TODAY()))

7

Hi @naveenkumardnk2

Thank you for further details, but I’m afraid I still don’t get it.

8

k i will got the answer

SELECT(Employee[Email],AND (USEREMAIL()=[Team head],NOT(IN([Email], [userDetail]))))