Concat Issue - II

[kishorj1982]

Started new thread as original has already been marked as correct.

Concat Issue

HI Stefen.

last time you have provided the solution to the issue above where I wanted to add and append selected fields from one state to another. I have worked on the same lines to remove the selection from the another state with diff button action

It works fine in my application.

But it shows formula in the current selections instead of the actual selections. To get rid off it I have added one more button action - "Select Possible"  IN the intended field.  But its not giving correct results when I am removing selections from another button.

Can you please let me know how to display the actual selections in the current selections box rather than Formula...that too without using the  SELECT POSSIBLE additional action ?

Attached is the sample application

[swuehl]

Is this the correct file you attached? AFAIR, we used different search strings, and I don't see a remove button etc.

Also it's not really clear in which fields I am supposed to select and which sequence of actions I am supposed to do.

[kishorj1982]

HI Stefen,

Please find attached  -new file.

Actions :

For 1st time selection from State A Table --> State B Table  -- Use button : Add to List (A -- > B) -1st time 

For subsequent Selections :  from State A Table --> State B Table  -- Use button :  Add to List (A -- > B) 2

To remove selections : Here, you have to select in state B and hit Button :  Remove List-2.

Please look into it. I also want to highlight the selections in STATE A .

Please help

[swuehl]

I think you should also select in state A FILE when you want to remove values, at least that's how it is working.

What is the exact issue with SelectPossible and removing values? I added this action to the buttons and it seems to be working ok.

[kishorj1982]

HI Stefen,

Thanks. I have tried with Select possible option. But While removing users can remove selected OR unselected FILE fields from the State A table. Issue happens when user selects  all the fields already selected in State B Table + unselected fields in State A table.... in that case due to select possible selects entire table in state B this defeat the whole purpose of building this functionality.

I.e. If I have A,B,C ,D in Table with state A.

and if I have selected  fields A, B in Table with state B.

When I am selecting A,B and C  in Table with state A for removing corresponding items from Table with state B, then it selects all the fields in Table with State B.

I dont want this to be happen.

[swuehl]

Try applying the SelectPossible action triggered by field OnSelect trigger.

See attached.

[kishorj1982]

NO Stefen it still expands the entire table in State B. Cant we have any action in buttons itself as triggers may cause issues in many situations. I already have trigger on that field in my main application and dont want to go with that route to make it more complex.

Please suggest.

[swuehl]

Well, maybe these trigger are counter-productive anyway? How do these triggers and actions on that field look like?

If I select some few values and then press the first button

Then add a fifth value per second button, I get

If I then select the same values again in State A and press Remove

All selections are gone...

[kishorj1982]

Yeah thanks Stefen. Just trying to understand if we can use another action instead of trigger ?  IF yes - then it will be great..

[swuehl]

Maybe like this, using only button actions