• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

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?
0
rholmes
Asked:
rholmes
  • 3
  • 2
1 Solution
 
darrencCommented:
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
 
phooeyCommented:
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
 
rholmesAuthor Commented:
So, can I send this field in an @MailSend() with arguments?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
rholmesAuthor Commented:
Can I change it to a Text field and solve my problem?
0
 
phooeyCommented:
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
 
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.
0
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.

Join & Write a Comment

Featured Post

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now