I am trying to get data in my tables to display differently than how it displays on a layout, to then easily export in the form I need to Excel. For example, alot of our data collection is done on ipads using FM Go. Data collectors enter data on a layout that has descriptive choices (eg. male/female) but we want our data table to hold a value that makes more sense for analysis, (eg 1/2). I know there must be a way to do this in FileMaker but can't seem to find it.
Thanks in advance for your help!