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

Insert record between two existing records

hartmut
in Calculation Engine (Define Fields)

Featured Replies

 
 

I have a list of people in my records that have a chronological order but there are times when I and the user will need to insert a new record at the right location in the file. (Between two existing records) Is there any way to do this with a calculation or script? I guess I am trying to build a timeline that constantly needs this kind of insertion. Is this at all possible with filemaker? 

 
 

create an "sortOrder" field and enter 1, 2, 3 etc. if you need someone in between just put 2.5 - (always sort by this field )

if you wan't to "cleanup" just sort the field and do a replace starting with 1. 

 

the ONLY other method to have FMP have record in a natural chronological order is to import them already sorted.

To add to what Stephan said, I would make sure that this number isn't tied to related data, i.e. as part of a key.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.