AnsweredAssumed Answered


Question asked by PeterHochstrasser on Mar 2, 2011
Latest reply on Mar 3, 2011 by philmodjunk


descriptive & technical selection values translation?


Being an old Lotus Notes hand, I am used to have capabilities to automatically translate values of a selection field between a user-ready, descriptive value and a technical value suitable for evaluation in the database.

An example: for a radio button, I want to display "yes" and "no", but store TRUE and FALSE values.

In Notes, it's as easy as defining the values like



when defining the field.

Is there any similar mechanism in FileMaker? Or, is there another way of implementing this?

Let me point out that my target platform is the web via IWP, so any on enter/exit scripts are out of the question.

(I already searched the manuals, help, the forum and the Knowledge Base, to no avail)

Thanks for your help

yours truly