November 25, 200817 yr Hi I run a script on a button to perform a find This finds the records based on the users criteria then takes them to a new layout to display the results. On this layout i would simply like to add a line of text that says "Displaying X of X records found" just as it does in IWP. Is there an easy way of doing this or am I looking at using calcualted fields to do this. I know there are certain symbols you can use on a layout to display username, version, last modified etc I was wondering if the same is true for current record of current found records? I dont know if this makes a difference but it is a hosted database on FMSA 9 with clients perfoming finds in FMP 9 Many thanks
November 25, 200817 yr This will work. Make text changes to say what you want. Create a global field. Set as a calculation. Add the following: Let([ Fc = Get(FoundCount); Tc =Get ( RecordNumber )]; "Viewing " & Tc & " of " & Fc) & " records."
November 25, 200817 yr You need a calc field, result text, unstored: RecString = Get (foundcount) & " records found out of " & Get (recordcount) & " total records." You can put this as a merge field in the footer of your list view. I put one of these in each table.
November 25, 200817 yr Author I was along the right lines with my calc field - just found the issue was storage - do not store calculate when needed... Thanks both for your help
Create an account or sign in to comment