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 Portal Row Number

Featured Replies

Please explain how one gets and uses the portal row number.

I have tried:

field "Row Number" type number with auto enter calculated entry Get ( PortalRowNumber )

result

returns numbers incrimented by one but the first row which should be one is some other number

and

field "Portal Row Global" type number with auto enter calculated entry Get ( PortalRowNumber )

result

returns the number 2 for every row.

There seems to be a bug with it, so you should be using it in a script, not a calculation.

  • Author

But, I heard that calculations were better for IWP purposes.

Probably so, but this is one of the Get functions that seems to only work correctly in a script.

Well,

You may modify the calc to :

1+Case(Get ( PortalRowNumber );Get ( PortalRowNumber )-1;0)

or something alike I'd think

From what I recall, it displays 0 when in the last portal row also, unless they've fixed that with v2.

Hi,

Just tried it, AFTER suggesting.crazy.gif

Workee so far. They may have fixed it, or I can't see the last row bug right now.

  • Author

ok, I tried

1+Case(Get ( PortalRowNumber );Get ( PortalRowNumber )-1;0)

as a calculated value in my Portal row Glogal field and it only returns the value of one in every portal row.

  • 4 weeks later...

ok, I tried

1+Case(Get ( PortalRowNumber );Get ( PortalRowNumber )-1;0)

as a calculated value in my Portal row Glogal field and it only returns the value of one in every portal row.

Auto-enter calculations are only recalculated when a field they contain is updated. Because you do not use any fields in this calculation, it is never recalculated. Try using an unstored calculation field instead. Or put a button in you portal row that inserts a value in a dummy field to trigger the recalc.

IE...: Use "if(dummy field=dummy field,0,0)+1+Case(Get ( PortalRowNumber );Get ( PortalRowNumber )-1;0)

Then every time Dummy Field changes, the auto-enter calcualtion will be recalculated.

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.