SeedCode Support Forum

I am looking to provide my users with an icon similar to the FileMaker book, that displays records 25 at a time.

Any clues/

Jim

I think folks have taken pictures of that icon and made calculated container fields that show it in different states to match what is going on in their databases, but I don't have an example of that available. As far as actually gathering the next 25 records, it sounds like you'd need to be storing find requests if you do this in a List. If you do it in a portal, however, you can have all the potential IDs is one relationship and then set groups of 25 IDs into a text key governing the relationship for your portal.

For help gathering these IDs in groups of 25, look at the AppendNth custom function which could be called like this...

AppendNth ( Your::IDfield ; 26 ; 25 )

...to get the IDs for records 26 through 50.

The graphics is not a worry.

I have this as a list. Will the AppendNth, grap the next 25 IDs even if they are not in sequential order?

Jim

Try it out. The function "walks" through the records according to the sort order of the relationship or list.

I must not have the custom function created correctly, the calculation says to many params

AppendNth (JobTicket::Job Number; 25; 26)

I have custom function as AppendNth

Jim

Don't know if I can help you without seeing your function. =)
Note that there are a few versions of the function in that post I linked to: make sure you've picked one with 3 params.

I will keep looking, guess I really need to know more about custom functions.

For now I got this to work,

Button triggers

Go to Related Record/Request/Page by Calculation
Get(Record Number) + 25


Jim