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.

Creating new records from a global?

Featured Replies

I have a file , schedule-like, with one record by every working-day, and a portal related to a tasks file. I know the multiple solutions given for my question (calendars of every kind and complexity that I have tried to adapt) but, finally, this is the most easy solution.

My question is :

Simple answer: Loop. You know how many records should be created, from the overall time interval and the increment interval (or just stop at the last time).

For one day, you create a record starting at a certain time, then create another adding the increment (like 15 min.), then continue until you get enough records for the day (or reach the last time). That's one day. The date would be set into a global first, then set into each record. The time would add the interval to itself.

Try it with a test file. Don't put Allow User Abort [Off] until you've got it right. View as Form speeds up Loops.

Alternatively, you could do the above, but make it a separate "fixed" file (table in 7), with only a global date field. Because the times are fixed, only the date changes. Then set the date, and Import into your schedule file, with Add new records. This might be a tiny bit faster.

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.