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.

Field array

Featured Replies

  • Newbies

I just started learning File Maker Pro 7 and have been doing well but have run into one thing I can't seem to find out how to do. This database keeps tracks of many dates. I would like to have basically a date field that is an array so that it remembers the last 10 or so dates entered (which can also be referenced in formulas and I would actually like to do this for many fields). Obvisouly making a sperate database that is relational would not work because I would need a new database for each record then. Is there anyway I can make fields work as an array? Thank you.

This is possibly an example where you could use repeating fields. HOWEVER, there are major differences with how you manage repeating fields and they can be quite sophisticated and complex.

I suggest you flesh out your requirements and post in the "Defining Fields" forum.

There are 'Field' gurus lurking there . . .

FileMaker does not support arrays. I don't think that you understand relational databases. One related file could hold all you information with a record for each date. A portal in the main file could show you the last 10 dates and the other information you want to show.

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.