I have a drop down list that uses a value list that uses values from first field "Employees::id" and second field "Employees::name" Showing values only from second field.

I would like to be able to add an additional selection to this drop down for "-All-". Can anyone tell me how I can do this?

Edited September 16, 201015 yr by Guest

...and what would you aspect if the user chose "-All-" ?

It would be attached to a global field which would trigger a calc to populate the target field with all options. My layout doesn't allow for a checkbox set and I would prefer not to use a button. I have done similar with custom value lists, as well as ones based on a single field using a calculation field. But I suspect the fact that this value list is based on two fields showing only the second makes it much more complicated and perhaps simply not possible.

What about a 0 serial number ?

-All-.zip

I suspected that might be my only option. I'm not thrilled about using a dummy record. There are other value lists and reports drawn from the Employees table that I would then have to create work arounds for to keep it omitted and hidden.

I will just have to decide if it's worth it to maintain the consistancy in my UI.

Thanks for jumping in :)

Or like this...

PopupFiltPortalShowAll.fp7.zip

No room on the layout for all the options in a checkbox set. I'm thinking at this point that I will probably just use a button for "All".

I'm not thrilled about using a dummy record.

So what about an empty field ( or which ever char ) means ALL ?

_10_-All-.zip

My demo does not have a checkbox set...?

Daniele: That may be worth exploring.

Barbara: I am confused. I'm not sure how your demo presents a possible solution. I don't see a dropdown anywhere, but I do see a checkbox set of "Staff" and "Volunteer" which I took as meaning that you were suggesting I use a checkbox set to allow for selecting all.

Ron, lol, I think I've posted a completely wrong technique. I didn't want to start from scratch, and so I modified another demo I had. I inadvertently posted the original.

So, here is the Show All filtering a portal method that I use.

PopupFiltPortal1.fp7.zip

Thank you Barbara!! This should do the trick. :