AUTO SELECT THE NEXT "AVAILABLE" UNIT

[KathB27]

Hi All,

Need your help with the Action button i am trying to create.

I have 3 tables:

1.) Employee Details Table

2.) Lockers Table

3.) Move-in Date Table

I want to create an Action  button on employee table to auto create a row in Move-In Date Table and at the same time auto select the next available Locker from the Lockers Table. Please help what formula to use to achieve this... 😢

There's a formula in the "Lockers Table" where the Employee ID column will show "Available" if not assigned to anyone.

EMPLOYEE ID column is reference to "Employee Details Table"

 the LOCKER ID column is referenced to "Lockers table"

Thank you!!!!

[Marc_Dillon]

ANY( FILTER( Lockers , [employee id] = "available" ) )

[KathB27]

Hi @Marc_Dillon ,

Thanks for replying.

I have tried the formula but i have 150 lockers and it's just choosing the same number...just changing the names when i click the action button.

I need a formula to auto select the next available locker.

Thank you

[Marc_Dillon]

I assumed "first available" would be the first record in the table where [employee id]="Available". Apparently not. So how do you define "first available"?