I have a date field, a step field, a notes field and comment field.
The table in the date field uses 1/1/1753 until the user fills in the next date with updated comments and notes.
I have suppressed the date field with currentfieldvalue=date(1753,1,1) and it's been working great. I've also formated the date field so if it is more than 30 days old from today's date and there is no 1/1/1753 in the next date field (no next comment) that the font is in red. This basically says that the last contact on this person is over 30 days old so someone needs to call him.
I have created a text box and I'm putting all the fields into the text box so the comments run together, the date is followed by a colon, the two comments are separated with a comma, etc.....
The problem is, when I put the date fields into the text box, the suppress formula gets removed from the field.
Is there a way to get around this and keep the supress formula working in the text box?
IP Logged
