Can these QuickBooks features be replicated in FileMaker?

[HALBURN]

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, 2010 by Guest

[bcooney]

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.

[Søren Dyhr]

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

[HALBURN]

thanks for the feedback and sample