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.

Script to go to next/previous record?

Featured Replies

I haven't found a way to go to the next, previous, first or last record using a script. If I want to change a field in found records, I find them, make a change and omit the record and repeat. Is there a better way?

Larry

Are you changing the same information in the same fields? If so, you sould look at using a loop in your script, along with Set Field, Insert Calculated Result, etc.

Lee cool.gif

  • Author

I still don't know the command to goto the next record.

Larry

Go to Record/Request/Page [Exit after last, Next]. It's in the Navigation script section underneath 'Go to Layout'.

Hi Larry,

If you're on a Form layout and just want buttons (or arrows) to move forward and backward through your record set, an easy way...Insert > Button. Then right-click and 'Specify Button.' Left-side under Navigation Go To Record (as everyone says). Type your button label and you're done. You can get fancy with Arrow graphics also but you can type << < > >> for the effect and it only takes a second. smile.gif

LaRetta

LaRetta,

Macs don't have right and left buttons.

smile.gif

The key combination is Control Up Arrow Key (Previous Record) and Control Down Arrow Key (Next Record).

Lee

The macs I work on have left and right buttons.

Some older 7500s and some iMacs came with that stupid unimouse. We promptly replaced them all.

Ctrl + click will bring up the contextual menu on Mac.

Hmmm, post subject was 'Script to go to next/previous record.'

I haven't found a way to go to the next, previous, first or last record using a script.

I don't know how you reach Specify Button for a Mac. Right-Click on Windows. Is that clearer? smile.gif It's where ever you find Field Format.

Specify Button ... A script-step assigned to an object or button, via generic script (without having to create one in ScriptMaker). Creating your four navigation buttons is very quick this way. Surely Macs have Specify Button? wink.gif

LaRetta

As a rule -- not just in FileMaker -- Control-Click is the process that works wherever "right-click" would work for PC (because it's command/apple, not control, that does the bulk of the keyboard shortcut work). But indeed, there are few serious Mac users who don't buy a good aftermarket mouse to replace the standard-issue....

But I've always wondered why "Specify Field..." can *only* be accessed in this way. It's a bit odd that it's not in the format menu, say...

Maybe FM will have an object-oriented palette someday, besides for object size!

ESpringer said:

But indeed, there are few serious Mac users who don't buy a good after market mouse to replace the standard-issue....

There are other alternatives to using a mouse, and still be considered a "serious Mac user". I prefer to use FileMaker's own keyboard combinations where available, to supplement those with Quickeys modules. However, a WACOM pad will eliminated the need for a mouse altogether.

ESpringer also said:

But I've always wondered why "Specify Field..." can *only* be accessed in this way. It's a bit odd that it's not in the format menu, say...

Specified Field can be reached by double clicking on the field when in layout mode. However, if it is a button, then the easiest way is to use the Control Click.

HTH

Lee

Hi ESpringer,

This thread seems to be confused! Maybe it's the pre-holiday spirit. smile.gif

But I've always wondered why "Specify Field..." can *only* be accessed in this way. It's a bit odd that it's not in the format menu, say...

I thought we were talking about Specify Button - which CAN be accessed also from Format > Button to assign a quick script. And Lee is correct that Specify Field can be accessed by double-clicking the field but we're not talking about Specify Field at all. crazy.gif

And the original question wasn't about using arrow keys to move through records (as a wheel mouse will also do that) but how to attach a script to allow easy navigation between records, or so I thought. grin.gif

Well, I think it's time for a holiday drink, as Stephen's Forum colours have just put me in the Christmas spirit. smile.gif

LaRetta

Ho Ho Ho.

Happy Holidays then (hiccup!)

Anyone got a refill?

I got a refill, unfortunately it's for Augmentin XR, not booze. I can't drink whilst taking my other meds either. Ay! And to top it off, the pharmacist said this new stuff is sure to give me some Montezuma's Revenge! I replied that I think I'll need another perscription to deal with the first one. Blah.

Yo &%*!ing ho! Merry freakin' Christmas, and please pass the TP. crazy.gif

What did I tell you about messin around with those "working girls" ???

Now you messed around and got hit with gonorrhea! ooo.gif

Just kidding - what, did you get a bronchiole infection or pneumonia?

Ken

PS - drinking while taking medications makes the world a better place grin.gif

Well, this year it was bronchitis and a sinus infection. The bronchitis is apparently gone (yay!); but the infection seems to be getting stronger (yuck!).

I think it might be better to have gonorrhea. At least then my head wouldn't be congested. Errr. You know what I mean. wink.gif

PS to your PS - not when taking a narcotic cough syrup shocked.gif

Hi Ken

grin.gifgrin.gifgrin.gif

IROTFLMAF - I got half way through your post before I realized you were posting to -queue- and not Ugo refering to his new image.

Lee

Could have been that too though. laugh.gif

Specially the PS thing....

Glad you all came through that earthquake with no little bobos...

See you next year.

I'm sure you NoCals felt it - but nothing down here.

Heard the "Governator" was in Paso Robles where 5 people were killed. Doesn't suprise me. Paso Robles is this little po-dunk town on the central coast where the Wal-Mart is the best thing goin'.

  • Author

Queue has the answer I needed. I just couldn't find it. That lets me use it in a script for repetition or a button.

Thank you

Larry

  • Author

What the heck did I start here? I think my question was so simple it confused everybody! Have a happy holiday everbody.

Larry

We were just killing time waiting for your reply. cool.gif

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.