Get Portal Row Number

[Gary Weisbrodt]

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.

[-Queue-]

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

[Gary Weisbrodt]

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

[-Queue-]

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

[Ugo DI LUCA]

Well,

You may modify the calc to :

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

or something alike I'd think

[-Queue-]

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

[Ugo DI LUCA]

Hi,

Just tried it, AFTER suggesting.

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

[Gary Weisbrodt]

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.

[ĸupiэȶƺ]

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.