8 Replies Latest reply on Jun 22, 2016 3:38 PM by Penny

    Data formatting different in layout to table

    Penny

      HI everyone

       

      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!

      Penny