AnsweredAssumed Answered

Substitute displayed value

Question asked by jimlongo on Mar 14, 2011
Latest reply on Mar 14, 2011 by jimlongo


Substitute displayed value


Hi, this is probably a pretty simple question, I just can't find the answer.

I have a field for whether or not a telephone number should be published.  It comes from a mysql database and is 0 for Yes, and 1 for No.   I would like my FMPro database to display √ if it is 0, and x if it is 1. 

That's easy enough.

BUt I don't want the actual value in the database to change, I just want the display to change.

I've tried various calculations but they always end up changing the actual field data.