Jump to content
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
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Exporting fields into a .csv file

Featured Replies

I need a scrip that will export selected fields of the current record to a .csv or tab-limited txt file to import into Moneyworks Express.

I have little knowledge of scripting and tried using "Export Field Contents" but this wanted to overwrite the destination file each time a field was exported.

You want File>Export Records or the script step Export Records. It'll export the found set. You could script the export so that the file name is unique by appending a timestamp to the file name.

"Selected Fields.." So you want to make several exports of the content of different fields on just one record, and then import each fields content as a record? or what?

If this is the case you could make a calculated exportField that is formattet the right way with the data from the wanted fields ad export this.

Or if the fields are decided at runtime . add them to the export field one by one and then export it.

Not at all sure that this is what you want, but thats what I get out of your post :)

Why do you suggest a "calculated export field" instead of Export Records? I would think that the accounting program needs the same data fields each time.

  • Author

Sorry, didn't make myself clear. When I create a record in FM I want a button on the layout marked 'Export' that will copy a selection of the fields in that one record so ao I can update my Moneyworks account record. The only fields i need would be the unique number, Name, and Address fields of the current record exported into a single file for importing

Why not use the Filemaker plugin that they have available? Link I would think this is a more stable way to communicate btw the two programs than text files.

  • Author

I have installed the plugin but not sure how and where to access it in FM

Plugin are typically found as External Functions in the calc engine. Start a new script, and add a Set $var script step so that you can create a calc. Have you done their tutorial?

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.