Filter Drop-down based on previous rows

AppSheet AppSheet Q&A
,
1

Hi Friends,

I’m creating an app to manage my clinic appointments.

I have a table where users can fill there details and select a time slot from the drop-down which has a list of available time slots.

Now I want to create a filter expression so that drop-down list only shows remaining slots on particular day. ( An expression which filters slots that are taken in previous rows )

Thanks in advance for your help.

2

You need to show us your time slots table structure to suggest a filter expression for you.

Most likely something like this

Filter(“your time slots table”, [assigned] = “NO”)

2 Likes
3

Appointment filling form Column settings.

I want an expression to be filled in suggested values.

IMG_20220216_124725.jpg
IMG_20220216_124725.jpg1080×1598 206 KB

Referred table that contain list of time slots

IMG_20220216_124440.jpg
IMG_20220216_124440.jpg915×589 55.9 KB

Sheet containing time slots

IMG_20220216_124906.jpg
IMG_20220216_124906.jpg1080×2340 184 KB

4

I am not sure if your architecture is really scalable…

However, if you want to continue to use what you have then you can try the expression

SELECT(Timings Physician[Physician], NOT(IN([Physician], [Related Appointment List][When you want to consult physician?])))
2 Likes
5

Thanks Mate, Your expression worked for me. :+1: