Formula Agent

HCL Domino Domino Forum
1

Hi All,

I have a couple of fields called questions and questionNo in a form called Extra Questions.

The questionNo display the number of the question and the questions field displays the question. The user can create more than one questions.

However I have a large number of records with the following:

Example 1

QuestionNo Questions

1 How old are you?

2 Gender

3 Date of Birth

4 Question

Example 2

QuestionNo Questions

1 Question

I would like to remove question 4 from above but leave questions 1 to 3 in example 1 but I’m not able to do this.

In example 2 I created an agent to remove the question. The agent is a simple formula agent:

Field Questions := “”;

and it works great.

I’m having difficulties with removing question 4 in example 1.

Can anyone help with this problem? I’m not sure how to remove question 4 in example 1. I would like to use a formula agent because they are easy to understand.

Thanks.

2

Subject: Formula Agent

Try using the @replace with @trim see help

Field Questions := @Trim(@replace(questions;“Question”;“”)