Jump 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.

touching all 3117 records

hafnerd
in Calculation Engine (Define Fields)

Featured Replies

i have the ean converstion working fine. the thing have to export it to a particular application that does not see the field. i created a filemaker script. very simple one to do the job. below is the script.

Go to Field ['AMZean"]

Perform Script [sub-scripts, "eanconvert""]

Go to Record/Request/Page [Next]

Perform Script [sub-script, "eanconvert"]

Pause/Resume Script ["AMZean"]

i was hoping that this would touch all 31113 records, but it only touches the displayed record. i have to active the script to get the data from the ean field into the AZMean field. how can i have this convert to all the records so i don't have to visit all 31113 files in the DB?

Loop

Go to Field ['AMZean"]

Perform Script [sub-scripts, "eanconvert""]

Go to Record/Request/Page [Next] [Exit after Last]

End Loop

i don't have my fm up but this i believe would be the correct script for you.

if someone else can check my syntax if i'm wrong, i appologize!

Tina Marie

You may want Go to Record/Request/Page [First] and/or Show All Records before the loop, just in case.

Create an account or sign in to comment

https://fmforums.com/topic/25146-touching-all-3117-records/
Go to topic listing

Important Information

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

I accept

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.