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.

Spacing in Layout and Other Dilemmas

Featured Replies

  • Newbies

We are in the process of converting our Excel database of calendar information into a Filemaker database which we share between Mac OS 9 and Windows 98 computers. In Excel, we often pulled reports into Word using mail merge, creating 3 column formats that are easy to distribute to the public and our media and academic contacts.

We have now set up a layout on FMP to do this, but there are a few kinks we are trying to work out. This past week I figured out how to do sub-summaries to have the dates sorted by Month on the layout. Next on the agenda is to fix the spacing. I'm using merge fields so the internal spaces are cenched up. I am also using the sliding option and the pagination option under the Body Part Setup to make things go to the next column. However, there are still two or three spaces between sub-summary headings and sets of merge fields, and the amount of space fluctuates. Plus, are there any options for a text wrap so there aren't four or five spaces empty at the bottom of some rows because all of the merge fields won't fit into the space. Please advise. I'm about to pull my hair out.

i.e. the reports look like this, but in 3 columns:

September 2004

Sun, Sep 12

John Doe, trombone

8:00 PM

Recital Hall

Admission Free

Mon, Sep 13

Piano Duo Recital

Pianist 1 and Pianist 2

8:00 PM

Recital Hall

Admission Free

Also, to send these reports out, we usually e-mail an attachment in Word? Is there any way to get this format out to other users who do not have FMP other than a spreadsheet or html table? Perferabbly a Word document or PDF file.

Thanks,

Joanna confused.gif

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.