How can I hardcode and store GetFieldSelections() in a variable?

[#1]

Hi,

I have a field called ProductID. Say I select ProductID = { "5" , "6" }

I am trying to GetFieldSelections(ProductID) --> and store it in a variable (vProductSelection1) , but hardcoded.

So that when my selections change (i.e. values in GetFieldSelections(ProductID) would change too), my variable value stays the same.

e.g. if I now select ProductID = { "8" , "9" }, although GetFieldSelections(ProductID) now shows "8 , 9",

my variable (vProductSelection1) still shows "5 , 6"

How do I do this?

Thanks!

[swuehl]

When do you want to store the values?

You can create a button to trigger writing the values to the variable in the trigger action.

[sushil353]

You can use input box instead of getfieldselection

[jonathandienst]

Hi

You have not said exactly when you want to store the field selections in the variable. By hardcoded I assume you mean that it should ALWAYS have this value. If so, then use the variable overview (Settings | Variable Overview) to set the variable contents and then save your document.

HTH

Jonathan

[#5]

Well actually, my ultimate aim is to keep appending new selections to an existing bookmark without overwriting the old bookmark selections.

e.g.

(1) BM01: ProductID = { "5" , "6" }

(2) I apply BM01, and my straight table shows the corresponding values.

(3) I now select ProductID = { "8" , "9" } from my straight table

(4) I want to now be able to replace BM01 with the new selections without losing the old ones. i.e. BM01 should now save selections: ProductID = { "5" , "6" ,  "8" , "9" }.

------------------------------------------------------------------------------------------------

As I was unable to do this, I thought of trying this instead:

(1) store BM01's selections, ProductID = { "5" , "6" }, in a variable (say v1) (somehow. I don't know how to do this yet).

(2) Select my new selection, ProductID = { "8" , "9" } from my straight table

(3) Click a button  - it will do 3 things:

     (a) set a variable (say v2) to = GetFieldSelections(ProductID)   (so its value would =  "8" , "9")

     (b) use trigger: Select in Field: Field = ProductID, Search String = v1 + v2  (with appropriate dollar-sign expansions etc.)

     (c) use trigger: replace bookmark BM01 with the current selections (which should now be v1 + v2 = { "5" , "6" ,  "8" , "9" }.)

and repeat.

Problem is that putting v2 into the Search String does not work because v2 is tied to GetFieldSelections(ProductID), which I think gets cleared when trigger (b) is actioned.

------------------------------------------------------------------------------------------------

Any help with trying to replace a bookmark without losing the historical bookmark information (i.e. keep appending the bookmark with new selections) would be greatly appreciated.

Thank you so much!

[swuehl · Accepted solution]

Maybe like attached.

[#7]

Oh wow, it works great. I spent so long trying to figure this out.

Really, thank you so much!!