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.

serialized list trouble

Featured Replies

  • Newbies

can't seem to make the Get (RecordNumber) do what it is supposed to. I have a calc field defined as a number Get (RecordNumber). from everything it says this field should change as the record is included in a found set or sorted in one. I set up and attached a test Db that has an auto enter serial field and a calc field as I described. Of course when I created 26 records in a row the numbers were the same. BUT if I find one record the calc field should show 1 regardless of the value of the number in the other field, isn't that correct? So if I find four records and view as a list the calc field should show 1,2,3,4, right? It doesn't, the calc field is not indexed but the number never changes. Thanks for any help this is buggin the crap out of me.

test.fp7.zip

The Get(RecordNumber) function returns the current record number in the current found set. The operative word here is current. There is only ever one of those, regardless of how many times you call the function. Likely all four of your calc fields will change to the same value as you scroll through the found set.

Are you trying to add a sequence number to records in the found set?

Cheers,

John.

You need your calc field to be "unstored."

  • Author
  • Newbies

Thanks and Yes to both of your answers, did you look at the file I sent? The calculation is unstored and yes I am trying to add a sequence number. jrb, according to the description of the function it is the current placement in the found set, so if you flip through a found set that should not change them, however if you resort them then they should change.

I did check your file and although you did not index your calc field, you did not select "unstored." I did that to your file and it worked fine. When you select "unstored" vs. none, the calc field recalculates every time.

Here's your file, with the calc field unstored.

test.zip

  • Author
  • Newbies

Ahhhh

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.