rholmes
asked on
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?
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?
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.
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.
ASKER
So, can I send this field in an @MailSend() with arguments?
ASKER
Can I change it to a Text field and solve my problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Thanks a lot phooey for your help.
Extract from Programmer's Guide, Part 2 ... pg 726
Rich text fields cannot be evaluated for content...........