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.