Select in Field with Multiple Field selection and Multiple Value

[BrianT]

Hi there,

I'm new here, so I just want to ask a question regard the Select in Field function.

I would like to select Multiple Fields in one button for example, when the user click on the text box, the result will return Field 1, Field 2, Field 3 and Field 4, also with each field selecting specific values such as Flagged, Error, and Justified.

I've tried to make multiple Select in Field Actions, but the results are not desirable.

Thanks in advance.

[SergeyMak]

Hi Brian,
I think you should explain a bit, what results you are having. It would be also great to see a sample of your data set.
It seems correct of what you are doing. You might have a problem with that if your selections are exclusive. eg you have records Flagged, Error, but not Justified.
Try to make those selections manually in listboxes.

Hope it helps.

[BrianT]

Hi Sergey,

The sample data set is

Field 1: Flagged, Error, Justified
FIeld 2: Marked, Incomplete, OK
Field 3: Flag, Mistake, Good
Field 4: Wrong, Transition, Go

So I've tried to use Select in Field under action in a text box in this order,

Field: Field 1, Search String: Flagged
Field: Field 2, Search String: Marked
Field: Field 3, Search String: Flag
Field: Field 4, Search String: Wrong

So they returned only the first one, i think due to the data being exclusive.
Any other recommendation for this problem?

Thanks

[SergeyMak]

Hi Brian,

If data is exclusive, you simply can't select it all together.

Then I have a question about your requirements. Why do you need it working in the way you data can't provide?

It wold be great if you give a table, but not just fields values listing.

[BrianT]

Hi Sergey,

Because the data compiled comes from multiple source and uses different values that means the same thing. So I want to select something that only means one thing as shown in the example above. In the fields there are only 3 possible values.

I got around the problem by having additional fields that standardises the value that mean one thing.

Thanks for your reply.

Regards

[SergeyMak · Accepted solution]

Thanks for clarification, Brian.

In your case your solution of 'additional fields that standardises the value' is the only way to go.

That's great, that you've found it by yourself!