View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Exporting checkbox fields to Excel

Followers

November 9, 201114 yr

Hi, I have a few checkbox fields in my layout that I want to export to Excel. The problem is when I do this I get some very weird results and strange characters. Is there a secret overall to exporting check-box value fields into Excel, where they are actually usable? i.e, look correct, can do calculations etc etc. One thing I did in Filemaker to get rid of the actual checkbox logos themselves in tableview was do a substitute field. Substitute(Field1; "¶"; ",") This stores the checked values with a comma between them in FMP, but I still dont get the correct results when exporting to Excel. Basically, is it BAD to use checkbox fields if you want to export your data to Excel and have it usable? Thanks