Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

5 record display limit in list setting of IWP

Featured Replies

  • Newbies

I haven't seen a resolution of this issue in other posts. Is there no way to display more that 5 records in the list setting? Why would they limit you to just 5 records? Because of this I'm not much better off that I was with Filemaker 5.5.

  • 2 weeks later...

I agree with you 100%! I can't believe they are limiting us to 5 records. I just talked with FMP tech support and here is their reason for doing it: We set it to 5 records because we did not want to overburden users machines if they had a ton of records that could possible show up on a layout. So they compromised at 5 records?!? Why not let people who know they have the horsepower behind the database set the limit higher? I have several layouts that are viewed as lists and the users are not going to like the fact that they can only see 5 records at a time. FMP's response to this was to go to custom web publishing. We don't want to. One of the benefits of IWP is it is so easy to put a simple database up on the Intranet. We don't have the manpower to start doing custom web publishing for every simple database that comes along. </Stop rant/>

John

They limited it for the same reason they don't let you run reports in IWP and the same reason they limit 100 users in IWP.

MONEY!!!!

Its about the all mighty dollar. They want to say they have IWP but don't want anyone creating real applications with it and taking away from there sales of desktop version.

  • Newbies

excuse for my english.

It's possible to send URL with var from FMP to a page xslt and return

with some result for make a liste in xslt?

  • Newbies

Up Up Up

--------------------------------

Fmp 2.5=>7.02 Dev FMSA PIV 2.6 1/120Go XP Pro Win 2000 SP4

  • 2 weeks later...

I work around this by displaying data in a portal. Portals can be any size with instant web publishing. You can use a self join relationship if you want to view the data from the same record.

Ironic isn't it. We have to capture a found set, then paste into a global, to show in a portal, in order to display a "reasonable" list (which I would put at 25, like the CDML default used to be); all because FileMaker is trying to protect us from straining our poor little machines. Ridiculous (nor credible). They have created the first really usable IWP, then shot themselves in the foot.

How do you create a script to go to the next page (next 5 records)? I need a button that does the same thing as clicking the little right hand page in the Status Area, but I want the Status Area hidden and locked.

  • Newbies

Just make two scripts with:

Go to Record [No dialog; Get ( RecordNumber ) + 5]

in the one going forwards and the same with a minus in the script going backwards.

  • 2 weeks later...

Thanks. That does the trick.

  • 2 months later...

iwp puts out 5 records in table view and we like table view because we can control the header don't we...

however you can get a prety good list like view from the new table view and not list view.

in layout setup, under the table view properties, include a header part and footer part if you want. fix up your header your way and slam in any buttons for web scripts that you want.

go to your layout and to reorder the columns and resize them to match your header.

back in the layout setup, table view properties, Set the row custom height and add grid lines Horiz or Vert.

Now the magic. Turn off the stinking column headers... Now it looks like a list view and iwp will pump out 20 lines, not 5, not more or less....

It made me happy to find this solution.

error above. First line should read.

iwp puts out 5 records in list view and we like list view because we can control the header don't we...

the rest regarding the new table view properties is still true. and table view will still return 20 lines from iwp...

Nice! Thank you for a reasonable workaround!

  • 4 weeks later...

Great solution!

But, Do Buttons not work in table view? I have been using a graphic button in List View that just goes to a different layout in the same file(for each record), but it does not show in Table View.

I tried making a field into a button. The field-as-button works in List View but, even though it shows in the Table view, it is inactive.

Any way to use buttons in the records of table view?

Thanks

  • 2 months later...

With Patch V3.. problem solved. Filemaker actually realise their mistakes.Well done.

  • 2 weeks later...

With Patch V3.. problem solved. Filemaker actually realise their mistakes.Well done.

I must be missing something. I have v3 and am still only getting 5 records per page.

Any ideas?

Thanks,

Brad

Just make two scripts with:

Go to Record [No dialog; Get ( RecordNumber ) + 5]

in the one going forwards and the same with a minus in the script going backwards.

Rabe,

I am attempting to duplicate your solution here, but I am having trouble with the scdript. How can I edit the actual script to reflect your suggestion? This is what I am coming up with:

newproductscript.jpg

Thanks,

Brad

They have fixed the problem in Server Advanced v3, which was released more recently. Hopefully they will release a FMP 7v4 patch soon which addresses this issue for paupers like me who aren't using Server Advanced yet.

Dana

For those interested, FMI has issued a patch to IWP for FMP and FMD that changes list and table views to 25 and 50 records respectively.

  • 3 months later...
  • Newbies

Can someone help me.

I'm looking for a way to display only 19 records in list view and not 25.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.