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.

Get(NextSerialValue) not working

Featured Replies

Hi,

Not sure what I'm doing wrong ... I defined a calculation field as follows:

GetNextSerialValue (

Get(FileName);

"_kp_field"

)

... where "_kp_field" is defined as an auto-enter serial number. The calculation doesn't show any result (empty) (the data viewer doesn't show any result for this calculation either) I'm sure I'm missing something but I'm lost right now ... any help would be very much appreciated! Thanks in advance.

Edited by Guest

Have you tried this explicitly naming the file instead of using the get function?

  • Author

Yes, same result! Does this function work for you?

... Oops!

And don't you have to put a delimiter in a calculation that uses a reserved character?

(e.g. /* SetField ( Target ; "_blinky/shakey" ) */

Yes, I've used this in several instances, but not with the syntax you've stated.

This is how I've used it successfully - although this does seem to be in conflict with the FM Help definition.

GetNextSerialValue ( ; )

and this is with defined as an auto-enter serial number with user override enabled.

I've only used defined as 1 (giving me the next serial number incremented by 1 from the current serial number.

  • Author

Thank you for your help bdavie007 ... I'm an idiot! I just realized that I forgot to put the quotes in the calculation. I had it like this:

GetNextSerialValue (

Get(FileName);

_kp_field

)

whereas should be as

GetNextSerialValue (

Get(FileName);

"_kp_field"

)

The "funny" thing is that when I posted the problem (above) I wrote the right syntax! I'm sorry I wasted your time ... thank very much again for your help!

TJ,

You know when you're just having one of those day? My brain is totally damaged today.

I use SetNextSerialValue - NOT GetNextSerialValue.

I think I'll go out into the lobby and wet my pants in front of everyone just to make my Friday complete!

Still, I think you should look into your use of "_" may be causing a problem (as a reserved character) in the calculation.

Good for both of us... Let's form a Friday idiots club!!!

  • Author

I think I'll go out into the lobby and wet my pants in front of everyone just to make my Friday complete!

Good idea, every time I do that it makes me feel much better! :

Create an account or sign in to comment

Important Information

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

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.