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.

Define and Update new Serial for existing records

Leb i Sol
in Calculation Engine (Define Fields)

Featured Replies

Hello Peoople!

I am hopeing some one can help out....perhaps a script guru would see a short way out of this. I have 700+ records that need a serial number generated and updated accordingly. I have a field "SerialNo" defined as serial auto-enter and increment in format ABC0001 increment by 1. This works great for the new records created but I need this field to be updated for all the records each record would reflect:

eg.

record1 SerialNo:abc0001

record2 SerialNo:abc0002

......

Any thoughts?

Thank you for the help! wink.gif

You can show all records, sort them accordingly & then do a replace, serial number, update serial# definition.

  • Author

smile.gif thank you....and I even used this "function" before why oh why did I not think of it!

worked like a dream!

her cjager fiel danke zu hilfen laugh.gif

ok...my german is not that great alta but THANK YOU!

Create an account or sign in to comment

https://fmforums.com/topic/15775-define-and-update-new-serial-for-existing-records/
Go to topic listing

Important Information

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

I accept

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.