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.

adding numbers into a databse automatic

raymate
in Calculation Engine (Define Fields)

Featured Replies

Have an old FM file that has 880 records in it, we have added a serial number field and asked it to start counting from 881 and this is does with any new records.

What we would like it to be able to put the serial number into the old records, of course old records have nothing in the serial field.

Apart from typing in 1-880 into every record, could it be done some how I assume changing the field from a serial to something else, add the numbers then turning back on the serial number option.

R

Show all records (Cmd J)

put your cursor in the serial number field

Main Menu >> Records >> Replace Field Contents

You will get a Dialog Box

Second Choice Serial Numbers. Put [color:red]1 in the first field, Click [color:red]Replace

HTH

Lee

  • Author

OMG, that was so easy... never thought to look there, I was dreaming up some sort of calc to do it...

Thank you..... :)

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.