script to go to next range of records

[digit]

Happy Easter everyone!

I am new to FM IWP and have been having troubles with layouts and navigation scripts for webusers of my database.

I have suppressed the status bar so that web users have less access to the database, however I am having difficulties creating a script that would let them navigate through the records when these are more than 25. I would like to create scripts that would allow them to go back and forth in the found range of records.

Moreover, I have noticed that when users search for some records and they come up with the list of the results, the script I am using to allow them to see once more all records in the database apart from the found set does not work. The layout is a list view only.

Thanks a lot in advance for your advice!

Edited April 13, 2009 by Guest

[Søren Dyhr]

Listview is simply not up to it! - I would portalize the search results, since portal doesn't have any limits. However could the riddance of scrolling be done via a tabbed layout instead ... say having 10 records on each tab/pane!

To assemble the found sets records use the tail recursion CF shown here:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000663

The collection of key values would then be primary key for the portalized layout.

--sd

[LaRetta]

However could the riddance of scrolling be done via a tabbed layout instead ... say having 10 records on each tab/pane!

Unless you plan to re-use the first tab and continue the set in a rotation fashion, I wouldn't recommend this approach. No matter how many tabs you use, you can always have more records than will fit in the number of tabs.

I remember viewing a demo from a top Developer when tabs first came out. I chuckled when I saw a Company table with addresses within 5 tabs. I chuckled because I know that the first time a company is a chain store with 144 locations, that solution would break. And so will 10-row portals without scroll ... it will hold a finite number of records (10 rows times number of tabs).

I suggest you always design planning that there will ALWAYS be more than you anticipate thus plan for unlimited numbers in all cases when EVER possible - no exceptions. Just my personal opinion, of course.

LaRetta

[Tony Morosco]

If you would like to create scripts/buttons for your IWP list view, I have found this solution to work.

Create a script (one each) for 'next page of list view', and 'previous page of list view'.

Select the script step "goto record/request/page", click "perform without dialog", and choose "By Calculation..." next to specify.

For the Next page script, paste in:

Let (incrementby = If (Get(FoundCount) > 25 and Get (LayoutViewState) = 1 ; 25 ; 1) ;

If (Get(RecordNumber) + incrementby > Get (FoundCount) ;

Get (FoundCount) - incrementby ;

Get (RecordNumber) + incrementby))

For the Previous page script, paste in:

Let (decrementby = If (Get(FoundCount) > 25 and Get (LayoutViewState) = 1 ; 25; 1) ;

If ((Get(RecordNumber) - decrementby) > 1 ;

Get (RecordNumber) - decrementby ;

1))

Then you can create buttons on your list layout associated with these scripts, to page through IWP results.

Warning: the buttons don't work for the list layout in native FileMaker.

Working for me under FileMaker 9.0v3 on Windows 2003 Server Internet Web Publishing.

[digit]

Thank you all very much! Now it works perfectly!