GetCurrentSelections without certain fields

[#1]

I need to use the function GetCurrentSelections into a text object , but without showing the selections of certain fields. Is it possible?

Thank's a lot!
Pol

[#2]

Maybe you could use GetFieldSelections function instead ?

Rgds,

Sébastien

[#3]

No... I need all the fields except three... some idea more?

thank's!

[biester]

I know that this my question won't solve the problem, but: I don't know of a GetFieldSelections (at least don't remember it in the API-Guide - can't check now). Is there really such a function, and if yes, what exactly does it do? Are there parameters? If exactly explained, this function COULD solve the rpoblem.

Rgds,
Joachim

[prieper]

Have not tested, but think that you might play around with the GetCurrentSelections()-formula and then try to formulate your exclusions and replace it with a combination of string-formulae, like checking for keywords and then purging the complete line.

Not a straightforward help, but may show you the way.

Peter

[pkelly]

I had a similar problem sometime ago but was more about checking that bthe user had invoked a selection to sbhow a field.

I have mocked up a shortened version of this - don't know if this will help you or not...

The premise is to store the selection for each filter into a variable.

Steps I took...

1) Create variabl

2) Add script from Tools | Edit module (watch variable / field names)

3) Go to Tools | Document Properties | Macros (think this is Triggers in newer versions)

4) Need to look at On Change And Select filters.

In the example I have provided, the text box updates to the selection(s) made in the respective filter.

Hope this helps.

[#7]

hi,

thank's for the answers, but I do not manage to solve it...

I have 3 fields selected always for default, and do not want that they appear in the object of text with the GetCurrentSelections() function...

Finally I will use the GetFieldSelections with all the fields ... a lot of work!

Thank's for all the messages...

Regards,

Pol

[#8]

if you always have 3 fields selected, why not load your info with that filter already applied?

[#9 · Accepted solution]

Hi,

i don't know that this will help you with text object but i have similar problem. I didn't want to see specific field selections in SelectionBox. in the begging of the script i define: Set HidePrefix=%; and then when im loading table and fields that i dont want to appear in SelectionBox i put % sing in front of them. This works for me - fields with % sign named didn't appear when i make selection i them in SelectionBox. I don't know if this will work with GetCurrentSelections function

Edit: Also be sure that "Show system fields" check box in "Sheet properties" is not selected.

Regards!

Stefan

[#10]

mmm... very interesting...

I don't understand the last part, it's possible upload a example please? I define the variable, and I put the % in front of fields, but they appear too into the SelectionBox...

Which is the last step?

Thank's a lot!!
Pol