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.

counting the first record

Featured Replies

Im adding automated clause numbers to a portal using an auto entry calculation and the Count function.

Unfortunately I cant get the first row to number (presumably because it hasnt been fully created yet). I tied a case statement to no avail.

Case(Count(minutes::minutes)="";"01";

Count(minutes::minutes))

What else could I use? i also tried isempty and isvalid. thanks

Have you tried @@ in a text block in the portal row? That won;t really number the portal records, only display numbers in the portal rows.

Alternatively, try creating a cal field in the parent record to count the related records. Then put an auto-enter in the related records that = parent::countrelated + 1

It might not work because auto-enters don't always like pulling in info from related tables.

  • Author

basically i have a series of meetings (and different projects) and a number system of 01(meeting number).01(minute number) so @@ wouldn't work. I havent tried your alt solution but i think it would suffer the same fate as my solution in that the first minute doesnt fully exist until after the auto calculation count.

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.