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.

Schedule summary?

Featured Replies

Hi everyone!

I've been struggling with a problem that I'm not sure can be solved given Filemaker's limitations. I've been working on a solution which includes a schedule database. I am trying to figure out the best method of summarizing a client's schedule.

Currently there are 3 related databases:

Main

Appointments

Calendar

The appointments database stores the dates as individual records. The calendar database displays these dates in a series of portals in a calendar format. (i.e. 28 different layouts depending on the month)

What I would like to be able to do is summarize a list of the related dates in a single calc. field in the main database. For example:

A client goes on vacation from May 15-20. The dates exist as individual records in the appointment database (May 15, 16, 17..etc). They display fine in the portals in the calendar database. How can I create a calc. field in the main database that could summarize these records?

A portal would be easy enough, but that would display the dates as individual records. Ideally it would be great if they could simply appear as "May 15 - 20".

If anyone has any ideas I would be grateful. I feel like my head is going to explode.

Cheers,

Christian Knudsen

Toronto, Ontario

if in the Main db you have something like an event ID, you can get the start & End dated with this calc:

duration display= Month(appointmens::date) & " " & Day (appointmens::date) & .. & " -" Month(Last(appointmens::date)) & Day(last((appointmens::date)) &...

Now add a couple of case statements to check wheter day, month, year are identical & adjust the disply accordingly:

Month(appointmens::date) & " " & & Day (appointmens::date) &

if(Year(Last(appointmens::date))!=Year(appointmens::date);Year(appointmens::date),"") & ....

Instead of just the related field and Last() you could use Min() and Max(), which would be independend of portal sort order.

  • Author

Thanks Christian!

It works! I'm going to try to put in a loop into the script so that I can display individual dates as well as a range.

Thanks a million, I couldn't get my head wrapped around that one.

Cheers,

Christian Knudsen

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.