Sixdots Posted February 26, 2006 Posted February 26, 2006 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
Raybaudi Posted February 26, 2006 Posted February 26, 2006 Status(CurrentRecordNumber) = Get ( RecordNumber ) or merge directly the "@@" symbols Status(CurrentRecordCount) = Get ( TotalRecordCount ) Status(CurrentFoundCount) = Get ( FoundCount )
Sixdots Posted February 26, 2006 Author Posted February 26, 2006 (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 February 26, 2006 by Guest
LaRetta Posted February 27, 2006 Posted February 27, 2006 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). LaRetta
Sixdots Posted February 28, 2006 Author Posted February 28, 2006 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
Raybaudi Posted March 5, 2006 Posted March 5, 2006 "Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) & ¶ & Get ( FoundCount ) & If ( Get ( FoundCount ) < Get ( TotalRecordCount ) ; " Found" ; " Total" ) Simple and handy :)
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now