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.

resetting automatic serial number

Capt JB
in Script Workspace and Script Triggers

Featured Replies

Guys,

 

I've no programming background, so I am asking for help :hmm: . 

 

I have a text field with an automated serial number of three digits by increment of 1. This serial is part of an ID number that includes the current date.

I am trying to have this serial returned to 001 at midnight, meaning that every single day the serial starts at 001 up to maximum of 999.

My problem is I cannot have the serial reset to 001, unless I do it manually.

Any help will be very much appreciated

 

If there is a link available so I can learn basic programming instead of sucking knowledge, it will be very much appreciated too, and I would feel better.. :idot: TIA

 

 

What formula have you tried?  We can start with that.

Create an account or sign in to comment

https://fmforums.com/topic/89396-resetting-automatic-serial-number/
Go to topic listing

Similar Content

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.