Scroll in lists

[Koen]

Hello,

At the moment I use a simple database and made it possible via IWP to publish it on the web.

All seems to work fine. Well almost.

When i see the records in list view I can not scroll through all the items.

I only see 24 records, but when I want to scroll up or down to see the rest, it is not possible.

Is there a way to get the scrolling to work?

Or am I dong something wrong?

For the info, I use FM11 for this.

Cheers

Koen

[No_access]

I believe FM limits the number of records in list view using IWP, you should use a portal to show the records and that will work just fine.

[IdealData]

IWP delivers 25 records at a time. If you have the status bar hidden then you cannot get the next 25. Portal solution works well though.

[dansmith65]

If you do use a portal instead of list view, be aware of how many records the portal returns, because every single record in the portal needs to be downloaded (on every page load) before the user can view the page. This is different than when using the FileMaker Pro client, which downloads portal records as you scroll through them (someone correct me if I'm wrong about this).

[Koen]

ok thanks so far.

But now a challenge with the portal.

I have a list of all the records in my portal. (just created a new table (table B ), with one record in it and one field, and linked that field with a field of the first table (tableA))

Now I would like it, that I can click on a portal item and change view to se the details of that item.

In list view I just had to say - Goto Layout Details

But now this goto layout command does not work.

Example:

So if I click in the portal on item 10 I would like to switch layout to see details about item 10.

In list view its just a layout switch, but not in the portal system.

Any help?

Cheers

Koen

[dansmith65]

In FMPro you would use Go To Related Record script step, but I'm not 100% certain that will work with IWP.

[beverly]

Koen, I automatically have 4 scripts that I add to every IWP solution.

Prev1, Prev25, Next25, Prev1

With obvious script steps to go to the record by number (+1 or +25 for NEXT). You can trap to verify that there are enough records to go 25 more (or less), if you desire. Add buttons to every LIST layout (and to form layouts if you desire) with these scripts attached. You've given your users the ability to navigate IF you hide the status bar.

HTH,

Beverly

[IdealData]

Go To Related Record (GTRR) works the same in IWP as it does in FMP.

There is a comprehensive guide in the Electronic Documentation folder in your FileMaker installation for IWP.

[Koen]

Thanks a lot.

Have used the 'next 25' method. Works fine.

Cheers

Koen

[bcooney]

@dan - "which downloads portal records as you scroll through them" . There was a white paper or webinar on wan optimization that directly addressed such under the hood behavior. I've got to find it....Anyway, I don't believe that this is correct. It might be that it loads ALL related records in a portal if the relationship or portal is sorted. I'll try to find the white paper/webinar link

Edit: Found it. It was Mark Richmond of Skeleton Key's webinar "Developing for Max WAN Performance". It's on TechNet.

[stri52]

Beverly,

 

are your scripts eventually available ?

[Davidatlamont]

Can someone provide a sample script for the "next 25 method"

[dansmith65]

I pulled the attached scripts out of a file - I accessed them slightly differently than how they are shown, so these exact scripts are untested.

GoToRecord.pdf

GoToRecord.zip