(Slices) about supervisors who do not have appointments

AppSheet AppSheet Q&A
1

Hello guys
I have a table named (supervisor data)
and table named
(appointments)

After entering the appointments for supervisors working on Sundays, for example
I want to make a(Slices) that shows me the names of the supervisor who do not have appointments on this day

note :
I used this expression to find out which supervisor have appointments for the current day

IN([supervisor name], SELECT(appointments [supervisor ], [date] = TODAY()))

thank you all

2

Assuming your comparisons are correctly matched by data type. the expression you have supplied seems it should work to extract the correct rows from the table. What is the issue?

There are a couple things to check:

  1. How is the column [supervisor] defined in the “appointments” table. Does it also have the supervisor name?

  2. Is the [date] column in “appointments” table defined as type of Date? If it is DateTime, wrap it in the DATE() function to get just the date portion.

2 Likes
3

Wrap your existing expression with a NOT()

2 Likes
4

Everything you said is correct
[supervisor] column It is present in both tables
and [date] column type of Date()

1 Like
5

It is amazing

Your idea has already worked
Expression works effectively

Thank you Marc

3 Likes
6

Oh wow! I missed that little word “not”!! :slightly_smiling_face:

3 Likes
7

Not a problem :rose:

1 Like