Solved

Field Name in Functions & Fields List

Posted on 1998-12-30
6
187 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Email relaying to outside address 4 161
Lotus Notes Mail Database issues 2 899
Send email lotus notes / VBA 6 167
Add code to Lotus Notes view column 2 117
  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…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now