I desire to have a flat single table/object of data, where we will filter, field by field, until we end up with one record.

Think: Inventory (see the screenshots from Excel).

In Excel: I'm talking about Auto-Filtering.

I could not find anything canned in AppExchange. Does anyone know of any already-available options to do this? I don't want to redevelop the wheel, so to speak.

The complete table... The complete table

...after filtering down to one row/record After filtering down to one record

So here, you'd select options from each Field (either left to right, or whatever order you like, maybe starting with Interface) until you end up with the one you want. Your SKU (in this case) is shown on the left.

If there were only a way to grab the functionality of the filter-builder from the Report Editor and throw it at a specific object with a Picklist for each Field onscreen...

  • I think you're going to have to roll your own here. – Adrian Larson Oct 28 '16 at 21:09
  • 1
    You might look at something like SlickGrid which does all the heavy lifting for you, but you'll still have to do some custom coding. – sfdcfox Oct 28 '16 at 22:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.