Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6847 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

On my FM 5.5 I have this merged field on my layout that shows the following

Record 1 of 6533

Found 533

It comes from 3 Calculated fields

Status(CurrentRecordNumber)

Status(CurrentRecordCount)

Status(CurrentFoundCount)

I am trying to do this on a layout in FM 8 with no sucess

Thank you in advance

Dave

Posted

Status(CurrentRecordNumber) = Get ( RecordNumber ) or merge directly the "@@" symbols

Status(CurrentRecordCount) = Get ( TotalRecordCount )

Status(CurrentFoundCount) = Get ( FoundCount )

Posted (edited)

Thank you very much

When I tried the Get Functions they would not work,

I then noticed that my old functions were unstored calculations after I changed the calculations to unstored it worked great

Thank you for taking the time to help me out

Dave

Edited by Guest
Posted

Hi Dave,

This is an example of when Custom Function is handy (since you have Advanced). You can create ONE custom function and just call it within each table (as unstored text calc). Going by the example you gave, you could have CF called RECORD BAR (with no parameters)???

"Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) & ¶ & Get ( FoundCount ) &

If ( Get ( FoundCount ) < Get ( TotalRecordCount ) ; " Found" ; " Total" )

It will speed up your development, add consistency for your Users and best of all, if you decide to change it, you will only have to do so in the Custom function itself. I also add the Sort state to the mix (since I remove Status Area). You can use it directly in a calc in each table without CF also. By combining your three calculations, your Define Fields will also be shorter (YAY). You would then just place the field directly on the layout (or place a merge field of the ONE calc). :wink2:

LaRetta

Posted

Hello LaRetta

Thank you for the information. I set it up as a custom function and it worked great. I had not used the custom function feature before, I learned something new.

Thank you

Dave

Posted

"Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) & ¶ & Get ( FoundCount ) &

If ( Get ( FoundCount ) < Get ( TotalRecordCount ) ; " Found" ; " Total" )

Simple and handy :)

This topic is 6847 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.