Solved

Field Name in Functions & Fields List

Posted on 1998-12-30
6
188 Views
Last Modified: 2013-12-18
I have a field ( rich text and editable, Name: "Message" ) on a form. When I
click on the Function & Fields button and click the Fields radio button to view a field list, the field is not listed. What would cause that and how can I get it to show up?
0
Comment
Question by:rholmes
  • 3
  • 2
6 Comments
 

Expert Comment

by:darrenc
ID: 1117826
This might be due to the fact that you can not use the content of a Rich Text Field in the formula language.

Extract from Programmer's Guide, Part 2 ... pg 726

Rich text fields cannot be evaluated for content...........
0
 
LVL 2

Expert Comment

by:phooey
ID: 1117827
Rich Text fields do not appear in any of these drop down lists.  This is related to the fact that the list can only be 64k long and there is no way of telling what is in a rich text field (well, there is with programming but...).  You can still access the contents of the field using script and check in formula for errors and null values (@if(Message = "" ; ...)

Rich text fields are not only useful for putting more info in but they actually reduce the size of a database (when compared to text fields) since they cannot be indexed in views and are ignored by all except FTI.
0
 
LVL 1

Author Comment

by:rholmes
ID: 1117828
So, can I send this field in an @MailSend() with arguments?
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 1

Author Comment

by:rholmes
ID: 1117829
Can I change it to a Text field and solve my problem?
0
 
LVL 2

Accepted Solution

by:
phooey earned 100 total points
ID: 1117830
Yes, change it to text and it will appear in the list AND can then be used in any @ formula, including @MailSend
Check the use of @MailSend since some of the fields are picked up automatically from a form and don't need to be added (Subject is definately one), I am not sure about "body" but it is probably possible to have this instead of message and then send the entire form.  When received by the mail database it should not matter that body was rich text...since that is what it is in the mail database.
0
 
LVL 1

Author Comment

by:rholmes
ID: 1117831
Apparently "Message" is som sort of keyword in Notes, because i had to change the field type AND name.

Thanks a lot phooey for your help.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 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