layout

Tag: layout

FileMaker Pro

Record Count in Portal Fields

I used to use this very simple calculation to display a record count in all my solutions:

c_Record_Status

“Record ” & Get(RecordNumber) & ” of ” & Get(FoundCount) & ” ( ” &  Get(TotalRecordCount) & ” total )”

and though it still works in my main layouts in FileMaker 11 it seems to have stopped working in portals, so I had to come up with a new solution and thanks to a post by Daniele Raybaudi over at FileMaker Forums I found a much easier solution:

c_Found_Count_Portal

Get(FoundCount)

which I then compliment on the layout by using the layout shortcut for Get Record Number Symbol or Get Portal Number Symbol: @@. So it is rendered on the page as:

@@  of <<JOIN_Addresses_Companies::c_Found_Count_Portal>>

Which is in itself a much more elegant solution. Oh and remember to set the calculated field to un-stored.

I’m a small business consultant enabling small business owners to achieve sustainable growth, whilst working part-time at Tees Valley Arts. For more about me personally see peterneal.co.uk