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.

auto enter serial numbers

Featured Replies

I want to define a field with an automatically generated serial number, each one greater than that for the previous record. This seems easy (Define Fields>enter field name (type is text)>click Options>choose Serial number and enter a starting value (e.g. 1)...but nothing appears in the field thus created! I'm doing something bone-headed, but don't see what the problem is. Thanks...

Did you specify the amount the serial number is supposed to increment by?

Also, keep in mind serial numbers are assigned when the record is created. If you already have records in your db, and this is a new field (or newly-modified field), there won't be any values in the field. If there are already records in your db, you can use Replace to populate the field with serial numbers.

Auto-entered data or calculations only take effect when a new record is created. I suspect your confusion is over records that already exist. If that's the case, first Unsort and reserialize the existing records using either a manual Replace or a scripted Loop using Set Field, with a global incremented to track the next number. Then go to your last record, record the serial, open Define Fields, and enter the recorded number plus one as your next serial number.

  • Author

makes sense...thanks

Create an account or sign in to comment

Important Information

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

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.