March 4, 201312 yr Filemaker currently allows a value list to be determined by a table field, OR by a static list. There should be an option to create a value list from a table field AND a static list. This would make it easy to add choices like ALL, NONE, etc.
March 9, 201312 yr There is a way to do this. The cool kids these days are using ExecuteSQL() and virtual lists to create value lists on the fly. Check out this website: www.filemakerhacks.com.
March 9, 201312 yr The easy way is to create a calculation and use the calc instead ... Simple, easy ... for example ... If your value list is based on Status, the calc would be Status & cr & "-ALL-" replace cr with a real pilcrow
March 9, 201312 yr BTW, I see a place for 'none' also at times Barbara. If you are using a pop-up or radio button and User changes their mind, a None provides an option since they cannot 'unselect' or *clear. Many times it is important also to distinguish between User skipping a question (null) versus set to None. * and yes you can remove values by shift and there are other tricks but None is more User-friendly. :-)
Create an account or sign in to comment