Set 1 reserved workstation to available

[LikeAFool]

Hello, me again

I have an issue of, when I unreserve my work station all other reserved workstations are set to available, I was wondering if there is a way to do it so only the requested unreserved workstation is set to available

some screenshots of what I’ve done so far

[Steve]

Use the Test button:

Does it display the results you expect?

[LikeAFool]

Hi Steve, thanks for your quick response, it gives me the results i desire, but it sets all “Reserved” desks to “Available”

[Steve]

Please post a screenshot of those results. Please also post screenshots of the configurations of all actions involved.

[LikeAFool]

Apologies for the delay, here are the screenshots of my test results and all my actions involved

Screenshot 2021-11-18 10.31.09|690x180

[Steve · Accepted solution]

In this expression:

Try changing this:

([Workstation Name] = [Workstation Name])

To this:

([Workstation Name] = [_THISROW].[Workstation Name])

See also:

help.appsheet.com

FILTER()

Select rows of table or slice

[LikeAFool]

You absolute legend, thank you so much!