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
Show next set of records
7 posts
• Page 1 of 1
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm |
JIMBO
|
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 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 |
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
|
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 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 |
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
|
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
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 |
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
|
7 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 3 guests