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.
Juggernaut

Create a table of empty records

Kevin Cheesman
in Calculation Engine (Define Fields)

Featured Replies

In MS Access I had a routine to create a table of records. 2 records for each day between two dates I specified. One record was marked AM and one was marked PM. These were linked to a bookings table and the empty records showed as AM or PM slots that we could book as appointments. This method was very clear when the table was printed or displayed on the screen, showing free and booked dates in date order.

Is there a facility in FileMaker to do this, or is there a better way of displaying free, unbooked dates?

Sure this can be done. See this thread for some discussion about a couple different methods for generating records for a similar solution:

http://www.fmforums.com/forum/showtopic.php?tid/176396/

I think there's a demo from John (near the end of the thread) showing the differences.

Edited by Guest

  • Author

Thanks for that!

Create an account or sign in to comment

https://fmforums.com/topic/43252-create-a-table-of-empty-records/
Go to topic listing

Important Information

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

I accept

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.