Field with Issue: DocHistoryField Type: Computed Rich Text
Formula writing to the field:
User := @UpperCase(@Name([CN]; @V3UserName));
Format := “Jill Smith” : “Jack Jones” : “Jill Jones” : “Jack Smith”;
@If(@Member(User; @UpperCase(Format)); @SetField(“DocHistory”; DocHistory : (“Format Change Made” + " by " + @Name([CN]; @V3UserName) + " – " + @Text(@Today))); @Return(@Prompt([Ok]; “Sorry”; “You are not listed as a Quality System Format Change Approver”)));
@If(@Prompt([YesNo]; “Attention!”;“Do you want to make a Format Change?”); @Success; @Return (“”));
@If(@Contains(Status; “Approved”); @Do(@SetField(“Status”; “Format Change”); @SetField(“RejectFlag”; “Modified”); @Prompt([Ok]; “Approved Document Modified”; “Please complete the format change and approve the format change quickly. The document status will be reset to Modified.”)); @Return(“”));
@SetField(“DisplayStatus”; “Modified Document”);
RequestDate := RequestDate;
@SetField(“RequestDate”; “”);SELECT @All
Problem:
Error Message pops up: ERROR: Incorrect data type: Text, Number, or Time/Date expected
Data Type is now listed as “Error” where it used to be Rich Text.
Text in field is now: Incorrect data type: Text, Number, or Time/Date expected.
I have seen this when referring to just a Text, or a Number, or Time/Date. I would find the field and change it’s datatype to the correct one, the error would then go away.
Does anyone have a suggestion as to where to look?
Thanks
Teri