Help needed with text in a field

Posted on 2003-02-27
Medium Priority
Last Modified: 2013-12-18

I am working on a form, with a field called "body", the formula for "body" is:
-start formula-
@NewLine+Catno+": "+Description+@NewLine+@NewLine+SMPTY+" Samples (MFR: "+Vndor+"-"+EDNO+")"+@NewLine+
-end formula-
Which works as expected. What I need to do is insert some text below the "COMMENTS" area in the form. The text will be something along the lines of:
-start text-
This is area 1
-end text-

And I will have areas 2 and 3 as well.

I tried putting the text in the form outside of the "body" field, but it doesn't get displayed when the form is filled out and emailed.

I looked around on Notes.net for a @text, @print, @write, command, but haven't found anything that will work.

Any assistance on this is appreciated.
Question by:yim11
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

AndrewJayPollack earned 1200 total points
ID: 8038031
do everything you're presently doing, but name your field "body1".  make a field called "Body" computed and hidden, with the formula:

body + @newline + "-------------------" + @newline + "this is area1" + @newline + "---------------" + @Newline

Another way to do this, would be to do just what you're doing, but use the form option "store form in document" which will send the complete form including all that you've done.

Expert Comment

ID: 8038037
You can just add these to the end of the formula for your body field:

@NewLine + Catno + ": " + Description + @NewLine + @NewLine + SMPTY + " Samples (MFR: " + Vndor + "-" + EDNO + ")" + @NewLine + @NewLine + "COMMENTS:" + @NewLine + "---------------------------------" + @NewLine + "This is area 1" + @NewLine + "---------------------------------" + @NewLine + "This is area 2" + @NewLine + "---------------------------------" + @NewLine + "This is area 3" + @NewLine + "---------------------------------"



Expert Comment

ID: 8041760

Expert Comment

ID: 8043121
Hi yim11,
I think you can have problems if 'the text in the form outside of the "body" field' is rich text. Try converting it to Text.

Author Comment

ID: 8043280
Thanks all for the comments.

A iittle more info on this form - it is a notes email template for sending a report (usually to an Exchange [Outlook] address.

AJP - I almost got it with your solution. I wanted to have the

areas non-editable, so I made each of the 3 a field (body2, body3, etc.) with a empty field below them for user input. I noticed that when the form was sent, the body was empty [in outlook] when received. I tried formulas such as "body + body1 + body1text + body2 + body2text....etc" in the main form as well in the body field, but still no go.

I did work with the "store form in document" suggestion, but could not get that work at all.

Any additional thoughts? Or info I can provide? Can you elaborate on the "store form in document" suggestion please?



Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question