I have a richtext field, “Description”, on my form and need to display it in an e-mail message. I have the same code in both QuerySave and WebQuerySave and the field does display with WebQuerySave, but not with QuerySave.
I then added a computed “text” field called, “DescriptionText”, with the formula of Description. While I can see both the Description and DescriptionText fields are populated in the properties, neither will show in the QuerySave event in the e-mail. Here is my QuerySave event code:
tmpEmail:=@If(Status=“Requested”; “There is a new project is the IS Projects Database for review.” + @NewLine + @NewLine + "Project Name: " + Title + @NewLine + "Requestor: " + Reqstor + @NewLine + "Phone #: " + OfficePhoneNumber + @NewLine + "Department: " + Department + @NewLine + "Office: " + Office + @NewLine + "Project Description: " + DescriptionText; “unknown”);
tmpEmail2:=@If(Status=“Assigned”; "There is a new project assigned to you in the IS Projects database: " + Title + “.”; “unknown”);
@If(Status=“Requested” & RequestedEmailFlag=“”; @Do(@MailSend(“Patty Bennett/Notes”; “”; “”; "New IS Project : " + Title; “”; tmpEmail); @SetField(“RequestedEmailFlag”; “1”)) ; “”);
@If(Status=“Assigned” & AssignedEmailFlag=“”; @Do(@MailSend(Responsible; “”; “”; "New IS Project : " + Title; “”; tmpEmail); @SetField(“AssignedEmailFlag”; “1”)) ; “”)