Go to next PAGE, not next record

[Ronald Cree]

I understand that FileMaker 8 only shows five records at a time in list view on the web. If the status area is showing, you can click the "book" and it jumps the list forward to the next five records.

How do I build a button that does the same thing? I want to hide the status area, but any button I make only moves to the next record, not to the next page.

Any help would be much appreciated.

[CobaltSky]

I understand that FileMaker 8 only shows five records at a time in list view on the web.

Hi Ronald,

Actually, that was FIleMaker 7. In Instant Web Publishing with FileMaker 8, List View displays 25 records at a time and Table View displays 50.

How do I build a button that does the same thing? I want to hide the status area, but any button I make only moves to the next record, not to the next page.

I suggest that you assign your button to the Go to Record/Request/Page[ ] command and choose the "by Calculation..." option. Then enter a formula along the lines of:

Get(RecordNumber) + 25

The users will then jump forward 25 records and therefore onto the next page in list view when they click the button. ???

[Ronald Cree]

Thanks for the info. It'll make things easier, that's for sure.

About the calculation... Say I have 100 records and can only display them 25 at a time. How would it work then? And can it be done without any user intervention?

Thanks.

[CobaltSky]

Thanks for the info. It'll make things easier, that's for sure.

About the calculation... Say I have 100 records and can only display them 25 at a time. How would it work then?

It will take the user through them in four pages of 25. To advance to the next page they will have to click your button.

And can it be done without any user intervention?

I'm not sure what you mean by this, as your initial question was about a button for the user to click.

However the answer is yes, insofar as the process can be scripted. So it would be possible to have the database cycle through the pages of records one page (of 25) at a time - eg from the start-up script of the file in question. ???

[Genx]

Um, wouldnt Get(RecordNumber) + 25 take you to the corresponding record on that other page?

i.e. if you were on record number 7, and you did get(recordNumber) + 25 it would take you to record 32 right? I dont use iwp but ill assume thats the way it works so we can modify the function a bit to get what we want.

Go to Record/Request/Page[(Cieling ( Get(RecordNumber) / 25) * 25 )+ 1]

~Genx

Edited February 25, 2006 by Guest
forgot to multiply

[CobaltSky]

Um, wouldnt Get(RecordNumber) + 25 take you to the corresponding record on that other page?

Yes, that is what it would do - and as such it is still the simplest solution.

However users may or may not want to go to the first record in the next block of 25. So you are assuming what is not stated.

Go to Record/Request/Page[(Cieling ( Get(RecordNumber) / 25) * 25 )+ 1]

Perhaps, but if you're really not sure how to spell "ceiling" you might use:

Div(Get(RecordNumber) - 1; 25) * 25 + 26

...or perhaps even:

Let(x = Get(RecordNumber); Mod(-1 * x; 25) + x) + 1

:wink2:

[Genx]

I knew that i before e rule didnt work... oh oops, its i before e except after c, but point taken cobalt, i was just throwin out a suggestion

~Genx

[CobaltSky]

I knew that i before e rule didnt work... oh oops, its i before e except after c, but point taken cobalt, i was just throwin out a suggestion

~Genx

Yeah - kind-of off topic, but even with "i before e except after c" as your guide, there are rather a lot of exceptions:

abseil

deity

their

freight

neighbour

weight

apartheid

vein

beige

reign

...and around a thousand others - and no shortage of exceptions in the other direction either:

efficient

glacier

ancient

science

species

society

prima facie

deficient

financier

concierge

Don't you just love "rules" that only apply sometimes...

Anyway, Ronald may well appreciate your suggestion. If he wants users taken not just to the next page, but simultaneously to the top of the page, he now has some ready-made options to do that. :thumbup:

[comment]

I'd think you have enough examples there in English, even without apartheid (Dutch), beige, concierge (French) and prima facie (Latin). And abseil? Where do you find that (and how does one work abseil into a conversation)?

[CobaltSky]

I'd think you have enough examples there in English, even without apartheid (Dutch), beige, concierge (French) and prima facie (Latin).

Hi comment,

Whatever their origins, all those words (and with those spellings) are accepted English and can be found in any decent (and relatively recent) English dictionary. Nearly all words in English came from somewhere else (directly or indirectly) originally.

FWIW, the word "comment" came from Latin (commentum), while "cobalt" came from German and "sky" came from Scandinavian. In fact the word "word" itself came from German (wort) and before that from Icelandic (ordh). But they're all English words now.

And abseil? Where do you find that (and how does one work abseil into a conversation)?

Abseiling is climbing (usually down) with a rope and harness, so its pretty common usage in conversations about wilderness treks, rescues, scaling rough terrain, mountaineering etc. But you knew that, right? :wink2:

[comment]

--- WAY OFF TOPIC ---

I am not a semantician, but I see a difference between words that have been adopted (and sometimes modified) into a language, and words (or phrases) that are recognized as foreign, although used, even commonly. I believe that is true for any language, so even though "rock'n'roll" may appear in a French dictionary, I am quite sure no Frenchman would think it "a French word". Conversely, I don't consider "glasnost" or "jihad" to be English words - even if both are listed in American Heritage.

As with all things semantic, it is debatable when a transition is complete. I don't think of "psychology" as Greek, or "nickel" as German. I might even concede "beige". But "prima facie" is as Latin to me as "in vitro" or "sic transit gloria mundi".

[CobaltSky]

--- WAY OFF TOPIC ---

Interesting comments, comment.

I don't think we should continue the discussion here, because as you say, it's way off topic. However suffice to say I agree with some of what you are saying... :wink2:

[Genx]

I reserve the right to be ignorant of everything off topic

~Genx