Field Name in Functions & Fields List

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?
Who is Participating?
phooeyConnect With a Mentor Commented:
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.
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...........
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.
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

rholmesAuthor Commented:
So, can I send this field in an @MailSend() with arguments?
rholmesAuthor Commented:
Can I change it to a Text field and solve my problem?
rholmesAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.