Formula agent - Replacing values

HCL Domino Domino Forum
1

Hi All,

I need your assistance. I have the following formula agent:

FIELD Address := “21 Johnson Street”; “Victoria”;

SELECT @All

I would like to insert the address and suburb into the field however only “21 Johnson Street” is been inserted and “Victoria” is been left out and I don’t know why.

Can anyone assist with this problem?

Regards,

John

2

Subject: Formula agent - Replacing values

Try this:

FIELD Address := “21 Johnson Street”: “Victoria”;

SELECT @All

A colon instead of a semicolon is the default delimiter for a text list. Also, make sure that the field you are populating is multi-value.

3

Subject: RE: Formula agent - Replacing values

Thanks Peter. I wasn’t aware I could use a colon on the formula agent. It works great now.Regards,

John

4

Subject: RE: Formula agent - Replacing values

You’re welcome. In formula language, the semicolon has a very specific meaning, which is to delimit arguments of the formula.