PowerFilter with many filter rows but only one query in base

[flanello]

Hello I'm working with the (excellent) PowerFilter example.

I want to expand it so that the filter table has more rows with filter criteria. And then I want to import/copy the filtered data to calc.
This could be done by creating many queries in base with different FilterIDs set ("F"."FID" = 2), and then importing this queries into calc. However this gets messy.

Is it possible to have only query where the filter ID comes from calc and then the result is copied to calc?
Perhaps with a macro in calc?

[F3K Total]

Hello,
no macro necessary. Do you know CTRL+SHIFT+F4 to see your registered databasedocument?
Enter the filtercriteria here, then update the databaserange in calc.

[Villeroy]

It is possible to attach filter forms to Calc: viewtopic.php?t=21099&p=96427#p96427

P.S. and by the way: I use the same method with a Writer template where the user selects a letter receipient from a listbox. The listbox value is stored in a filter row and mail merge fields are filled with data from this distinct record WHERE "Receipient"."ID"="Filter"."INTEGER_1" AND "Filter"."ID"=1. The listbox itself and the save button are set to non-printable.