User defined Fields & Filters

[Niels Brabandt]

Hi,

I got two questions:

1) How am I able to change the curreny symbol in certain special fields from
"$" to "€"?

2) Is it possible to use a customized filter which will "ask" me via a
dialog box for the parameter I want to enter?

Thx for help!

Greetings...

Niels Brabandt

 

[JulieD]

Hi Niels

Q1) sorry, no idea

Q2) you can make an interactive filter by using the following syntax in the
VALUES column
"your question"?
note the ? after the "

what happens then when the user chooses the filter the message "your
question" appears and they can enter the value that they want to filter on -
or you can assign a drop down list of values for them to choose from.

if you'ld like more assistance on creating a filter, please post back

Cheers
JulieD

 

[Jan De Messemaeker]

Hi Niels,

1. That depends as to what are "Special Fields".
The symbol for the standard cost fields is defined in Tools, Options, View
You can (through a formula) use a different symbol but only isn custom text
fields.

2. Yes.
As a value for the filter give
"The prompt text here"?
Make sure the quetion mark IMMEDIATELY follows the double quotes.

HTH

 

[Dave]

I have a follow up question, if I may. Do you know how you can reuse a
interactive filter? Meaning, I have a filter that needs the same response as
was already keyed in. Right now it works because I ask the question twice
(hoping for the same response). However, being a prior developer, this seems
very wasteful if I can save it as variable somehow and just call it up when I
need it.

Thanks for any assistance,

Dave

 

[JackD]

Yes you can "reuse" it to an extent. The only problem is that it requires
using some VBA code to do so. You will need to write code to

ask for input
(store it somewhere if you like)
construct the filter
apply the filter.

It is pretty simple. You can look at some of the macros on my site for
examples. The trace macro has code for the input box and for constructing
and applying a filter. You can get rid of all the stuff inbetween.