We are trying to create a dynamic Value List that filters the results in real time as the user enters data into the destination field.

We are also trying to format the value list in a unique way in which all sub-categories are indented just below the main category. We would also like the Value List to display a separate column containing an additional value.

I have created a quick screencast that shows the QuickBooks functionality that we are trying to achieve in FileMaker 11.

Is this possible? If not, is there a plug-in for FileMaker that would allow us to do this?

Thanks.

View ScreenCast Movie

Edited July 16, 201015 yr by Guest

If given the job to replicate this functionality, I'd probably do a popup window with a filtered portal or a list view with global fields in the header that would allow for finds (scripttriggered).

Afaik, the exact functionality (all this in a value list, especially the add new subaccount on the fly) cannot be replicated in FM. Furthermore, it is best to use IDs under all choices, and to replicate type-ahead you'd need to use the actual text. In fact, I bet QB does a reverse lookup, storing IDs by matching the account name.

While the indents indeed are possible, would the sorting cause you grievance ... and you should perhaps investigate this:

http://www.24usoftware.com/SimpleDialog

My guess is if you post your video to Honza, will he immediately be able to tell you if it's up to it.

Though I have toyed a bit with the scenario and indenting and sorting can happen ...The approach need a bit more to be honest... take a look at the attached!

--sd

selection.zip

thanks for the feedback and sample