How to strip fields to create alert

HCL Domino Domino Forum
1

Hello, hope someone can help;I want to have a field, under a certain condition, display a prompt which is a dialog box message.

If the field has number with an “R” in this place:

XXXX-XXXX-RXX

I am uncertain on how to “strip” or “count” the numbers for this to happen.

I hope to do this change on one form and not have to create views if possible.

Any help is greatly appreciated…

Thank you

2

Subject: How to strip fields to create alert

What language are you trying to accomplish this in?

Formula would give you value:

TmpR := @Left(@Right(@Trim(FieldName); 3); 1)

Script would be similar:

TmpR = Left(Right(Trim(Doc.FieldName(0)), 3), 1)

3

Subject: RE: How to strip fields to create alert

Tom;thanks for the reply.

This is a form so Formula would most likely be best. How would I get a prompt from that code?

4

Subject: RE: How to strip fields to create alert

I thought your issue was not knowing how to stip the character out of the string and you knew how to code the prompt?

You would then interrogate the TmpR value like so:

@IF(TmpR = “R”; @Prompt…; “”).

5

Subject: RE: How to strip fields to create alert

Thank you for your help and knowledge, Tom. I am starting to learn Lotus Designer/Script.Just was not sure how the code fits together.