I am building an IWP contact management DB and considering to use the built in list view instead of the slightly more complicated portal route. The 25 records is ok with me as long as the user has a forward and backward button to display the next list.

My question is i would like to hide the status bar and would therefore need to create a script to replace the "Next Range of Records" page button presented in the status bar but can not find it. "Go to Record/request/Page [Next] will only take me to the next record. Is there a way of doing this?

Use "Go to Record [No Dialog; Get (RecordNumber) +25]"

Even better, use these calcs for forward and back:

Forward:

Let(

[ 

 N= Get(FoundCount) ;

 X = Get(RecordNumber) ;

 Y = X + 25

] ;

Case(

 Y > N; X;

 Y 

 )

)

Back:

Let(

[ 

 X = Get(RecordNumber) ;

 Y = X - 25

 ] ;

Case(

 Y < 1; 1;

 Y 

 )

)

The advantage here is that it keeps your record # consistent as you reach the end of the list and then back up. Otherwise, if your # of records is not a multiple of 25, when you hit the end and come back, you'll be on a different record number.

I am trying to set up the same thing, but what I don't understand is how to trigger the scripts. When I switch to list view in IWP and the status bar is hidden, there are no controls, no header, etc. Where do I put the buttons for list view?

Thanks.

I am trying to set up the same thing, but what I don't understand is how to trigger the scripts. When I switch to list view in IWP and the status bar is hidden, there are no controls, no header, etc. Where do I put the buttons for list view?

Thanks.

I wonder if you are confusing List view with Table view? You have to add buttons to the layout. They can go in the header or footer, or on the list item body itself.

In Table view you can't use buttons in the body, so they'd have to go in the header or footer. To see the header/footer in Table view, make sure you enable them in the Layout setup dialog for Table view options.

I'm trying to something similar, but would like to remove the 25 record limit and display all records (I currently only have 55 records). Is there a way to do this?

Thanks

You can set it up as a portal instead -- portals can show an infinite # of records and respond to mouse scroll wheels, so they aren't horrible ways to look at the data.

But it sure would be nice if the 25 limit for lists was changeable.

If I set up a self join relationship with Constant_1 as the link, I get one record repeated 55 times. Is there another join I should use?

Thanks

I wonder if you are confusing List view with Table view?

Aha. You are correct.

In Table view you can't use buttons in the body, so they'd have to go in the header or footer. To see the header/footer in Table view, make sure you enable them in the Layout setup dialog for Table view options.

Yes, that's what I was missing. I didn't realize I had to enable the header for table view. Thanks!

Ken

my pleasure!