5 Replies Latest reply on Dec 31, 2015 7:41 AM by Markus Schneider

    Importing a checkmark into Filemaker 14

    BadToro

      I am creating a Filemaker solution which incorporates data retrieved from a salesforce database. Certain fields in the salesforce database are those which a user will check off and therefore, displays either a blank or a check mark depending on what is appropriate.

       

      When I export the data into an excel format it will contain either a 0 (i.e. blank / unchecked) or a 1 (i.e. a checked). How can I change this to actually display either a blank or a checkmark instead of a 0 or 1? I'm still learning about calculations as well as how to create a useful solution, so any assistance would be appreciated.

       

      Lastly, is there a way to customize a button to automatically import a specific report into Filemaker without having to manually export a report into Excel and manually import into Filemaker?

       

      Thanks in advance for your help.