I have been able to get my dependent drop dow...

[Tammi_Canelli]

I have been able to get my dependent drop downs to work with one problem…

Once the selections are made I need the cot number that is selected to now become unavailable and removed from the list.

How do you accomplish this when the record being edited is not in the same table as the lookup values?

[tony1]

@Tammi_Canelli This sample might be a good starting point: appsheet.com - Distinct value dropdown - Only allow values that haven’t been chosen in dropdown Distinct value dropdown - Only allow values that haven’t been chosen in dropdown appsheet.com

[Tammi_Canelli]

Does this work on more than col?

I want the user to be able to pick room type, see only the rooms that match that type, choose room, then see available beds.

[tony1]

@Tammi_Canelli You could probably generalize it to do that, yes.

Maybe an even easier way to do this would be to make a slice that has “unclaimed” rows. Then make your dependent dropdown(s) point to the slice.

[Tammi_Canelli]

How do you point a dep drop down to a slice?

Would the slice name go where the table name goes?

Slicename[column]?

[Aleksi_Alkio]

@Tammi_Canelli That’s correct

[Tammi_Canelli]

Thank you @tony and @Aleksi_Alkio the slice works great!

Now to figure out how to mark the cots unavailable when they get assigned…I’m guessing i need to create a ref between the two tables.

wish me luck

[Tammi_Canelli]

@tony

thanks for the sample app but i can’t figure out how to make that work.

i’m giving up before my laptop goes flying across the room

[Lynn]

Hi @Tammi_Canelli , Check the Valid If formula in the equipment col (You need to click on the flask to see the whole formula as only part of it shows in the box)of the requests table. It is giving you the initial list of equipment - (minus) the used list that doesn’t have todays time.

I am trying to do something similar but my “equipment” gets returned so is available again. I haven’t figured it out yet.

[Tammi_Canelli]

@Lynn thank you.

It took me a while but after enough frustration I went through everything and finally saw that. So excited to get this working!

@tony I noticed the sample app used the timestamp in the expression but I’m assuming only because it was the key? My table uses ID as key so I used that in my expression…it all seems to work but will I have any issues by not using a timestamp?

[tony1]

@Tammi_Canelli Yeah, I believe in that app the timestamp is the key column, but you could use any valid key type.

[AlejandroCamach]

Hi everyone,

I’m trying to do the same, the difference is that the values are of a previous dependent dropdown. First, it is nos applying the dependent dropdown, and second this appears:

Thanks for the help!