Choosing a value from a text list contained in a Profile document

HCL Domino Domino Forum
1

Hello there,

I am currently coping with a problem which seems simple, but I wasn’t able to solve it yet. And this is pretty surprising, all the more because this is basic knowledge.

I would like to access a text list field of my Profile document. More precisely, I would like to access one specific value of it. SO to say the nth-element. All ijn formula, it’s for a hide when formula.

basic formula : @GetProfileField(“Name”;“Field”). Now, in the profile, with an agent, I test accessing the value with simple Field[1], but when outside the profile, I must use the @GetProfileField and I’m lost.

@GetProfileField(“Name”;“Field[1]”) doesn’t work, neither does @GetProfileField(“Name”;Field[1]) nor obviously @GetProfileField(“Name”;“Field”[1]).

So, am I so ignorant I can’t find the solution or is it really tricky ? Thx a lot in advance for your insight, these obvious but not so obvious problems drive me crazy …

Mathieu

2

Subject: Choosing a value from a text list contained in a Profile document

I think you want:

@GetProfileField(“Name”;“Field”)[1].

or if it helps

tmp := @GetProfileField(“Name”;“Field”);

tmp[1]

3

Subject: RE: Choosing a value from a text list contained in a Profile document

Tanhks a lot Stephen it works perfectly. I guess that was the last possibility …