Solved: Value in a Drop Down once selected should not be s... - Page 2

Kanha_PM_Office · 09-17-2019 09:19 PM

Hi,
I have a table where one user inputs the Type of Vehicles needed.

Another user allocates the available Vehicles against the corresponding Vehicle Types.
But, once selected, the particular value should not be allowed to be selected or not be available in the drop-down list.

How can I achieve this in the Valid_If condition?

Thank you.

Kanha_PM_Office

Yes.

There can’t be without type. The requester should mention Vehicle Type.
It’s a mandatory field, based on which the Vehicles are auto populated as Drop Down List.

Also, I have these formula working for that particular day or the previous day. (However, I couldn’t achieve the same for any other days.But, that’s not a criteria to worry about).

I am so glad that I could get immense help from you & your team! Kudos!!

1) For Vehicle Allocation:
SELECT(All Heavy Vehicles[Reg #] , [Vehicle Type]=[_THISROW].[Vehicle Type]) - SELECT(Vehicle Allocation[ Allocated Vehicle #], AND([Vehicle Type]=[_THISROW].[Vehicle Type], [Status]=“Allocated”,or([Date]= TODAY(),[Date]=TODAY()-1), NOT([Date]>TODAY()),NOT([Date]<(TODAY()-1)), [Shift]=[_thisrow].[Shift]))+SELECT(All Heavy Vehicles[Reg #],[Vehicle Type]=“NONE”)

2) For Drivers:
SELECT(Driver Master Data[Driver Name],true) - SELECT(Vehicle Allocation[Driver Name],AND([Status]=“Allocated”,or([Date]= TODAY(),[Date]=TODAY()-1), [Shift]=[_thisrow].[Shift]))

These are working well for my usage criteria.

Apart from this,
Is there any possibility for the user to enter the values directly in the Table form view instead of opening in the form & using a drop-down list. Precisely, is there any option to use like a drop-down list for the Vehicle & Driver fields directly from the table view? If so, how to achieve this. It would actually save lot of time & effort for our users.

Thank you again!

View solution in original post

Value in a Drop Down once selected should not be shown (based on a condition)