Show next set of records

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Wed Apr 16, 2008 10:09 am
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
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Apr 16, 2008 10:19 am
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.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Wed Apr 16, 2008 10:56 am
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
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Apr 16, 2008 11:09 am
Try it out. The function "walks" through the records according to the sort order of the relationship or list.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Wed Apr 16, 2008 12:43 pm
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
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Apr 16, 2008 2:27 pm
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.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Thu Apr 17, 2008 7:30 am
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
JIMBO

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

(855) SEEDCODE
[email protected]
Follow us: