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.

Featured Replies

I know there are alot of posts out there for calendars and even schedules. What I am looking for is some help in multiple dates per record, placed into a simple weekly schedule. Sort of like a job that gets done in parts through out the week or weeks. I cannot get a script to recognize the multiple repetitions for each record. Only the first repitition is show. Please help.

It would help to know more about your structure and script.

But in general, it's better to use a related table if the number of elements (dates in your case) is not static, or if there may be more than a few. Repeating fields can be useful in some situations, but it's not clear if this is one of them.

  • Author

there is 1 field with 5 repititions per record. The account rep can specify the single date in the first repitition or multiple dates in the 5 total repititions they would like their job completed. Say they have a 10,000 piece job to print, and they wanted 2500 pieces printed on 4 different days. It is still one record but with 4 differnt "print" dates. Right now the ticket is set with one due date. I need to show a schedule for the week or month so all departments can see the different days the rep scheduled the job.

This definitely looks like a good candidate for a related table (maybe call it "Job_Date"). Especially since it looks like the Number of Pieces could be stored in there with the Due Date, and maybe the Status of the job.

With a relationship from your current Job table to this new Job_Date table via the Job ID, you can use a portal to show and enter the Due Dates and other details. Then a simple Find in the Job_Date table for those Job_Dates whose Due Date is <= the current date with Status = "Open" or whatever, will show the list of jobs that are due along with the Number of Pieces.

Or, if you want to consider the job load of the existing Jobs when you go to schedule a new Job, you can use another relationship "Job_Date by Date (and maybe Department)" to get a portal showing those Jobs already scheduled for a selected date.

  • Author

what about filemaker 6 that i will need to eventually convert to ver 7 or 8?? any ideas

Same deal. Use multiple files in place of multiple tables.

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.