AnsweredAssumed Answered

Importing a checkmark into Filemaker 14

Question asked by BadToro on Dec 31, 2015
Latest reply on Dec 31, 2015 by Markus Schneider

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. 

Outcomes