Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Field Name in Functions & Fields List

Posted on 1998-12-30
6
Medium Priority
?
197 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
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!

 
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 300 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

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

971 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