How would I get a portal row number? IE. There are 15 rows total but only 5 contain data. I want it to display the portal row number when there is data in the row like

1 Data1

2 Data2

and if the rest of the rows are empty it would not show.

I tried Get (PortalRowNumber) but that returns only currently selected row otherwise it returns 0.

Thanks.,

Try putting @@ as a text element on the row.

Wow, that solved it perfectly. Thank you.

* Just found a workaround too - Made a Get (PortalRowNumber) in Parent table as an unstored calc and an Autoenter Calc in LineItems = Get (PortalRowNumber) from the parent table. That worked to (not sure if it will work smoothly or not).

Glad I asked tho @@ is the right way - many times I end up using something I "discovered" how to do myself while there are much better methods out there.

always learning.,

Thanks.,

You do not need to use get(portalRowNumber). You can create a field RecordNumber, unstored calc, get(RecordNumber). This will display correctly no matter where the record is. If it is in a portal, it will show portal row number.

I sometimes prefer to do this because of how I place fields in portals and how I size portals. It is easier to size the width of the portal if the portal is filled end to end with fields instead of @@ at one end.

Thanks.,

This is exactly what I want to do, but I dont understand what you mean by @@ as a text element on the row.

Do you mean place @@ in a certain field? Or part of a calcuation?

Steve

@@ is the symbol for Record Number (see on FM top menu Insert and at the bottom a list of symbols). For instance, // produces the current date. You woudl use your text tool (as if you just wanted to type text) and type the @@ directly into the portal row (but not directly into any field.)

thanks...I tried the get record number, perfect

Okay. What if the portal is showing results from a join table? For example, you have an IPFs table (Never mind what an IPF is) and a Devices table. One IPF can have many devices and one device can be a part of many IPFs. How would you show the portal row numbers? Having the Get ( RecordNumber ) calculation in the join table doesn't help, because there are many unrelated entries.

It works fine showing an unstored calculation of the joint table in a portal, the calculation been Get ( RecordNumer ).

In you case, you have a multiple to multiple relation, then an intermediate table has to be created, in which you can set up the calc.

Using the unstored calc method, is there any way of having the "0" in the next (uncreated) row not display, or is that unavoidable? Thanks.

Bob

Using the unstored calc method, is there any way of having the "0" in the next (uncreated) row not display, or is that unavoidable? Thanks.

Bob

Here's one way.

RowCalc.fp7.zip

I was thinking something something about using 'case', but had no idea where to go.

That's ingenious, thank you!

Bob