Retrieve Back-end Color value from Profile Document

I have read and understand the instruction on how to use color in a view from a profile document. However as usual we all come across tasks that aren’t covered in the help documentation.

In my profile document I’m creating dynamic fields based on user’s input. Therefore these fields don’t exist when viewed by the designer but are there when viewing the Doc Properties of the profile. What formula can I use to retrieve the value of a field using a variable that equals the name of the field.

Back-end Profile fields: “XTxt” and “XBck”

Document Field: “Number” = 1

Code:

"vwdocfld := Number;

clrtxt := vwdocfld + "Txt";

clrbck := vwdocfld + "Bck";

clrtxt : clrbck"

Subject: RE: Retrieve Back-end Color value from Profile Document

@GetProfileField and @SetProfileField works for fields that are not on the profile form. In fact, unless you have some reason to show it to the user, you don’t need to have a profile form.

Subject: RE: Retrieve Back-end Color value from Profile Document

Think of how the mail file is set up for the Inbox folder but I can’t put user’s in a group of three boxes. I need to be able to (without knowing the number of people) have colors for each person.

Subject: RE: Retrieve Back-end Color value from Profile Document

This question has been answered here before. Search for the answer. Bottom line is that you can’t.