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.

How do get data of field in CURRENT RECORD?

Featured Replies

I can't figure out how to get the data of a field of the current record. I want to store it and pass it on to another script.

Here is my FM script that returns data from all of the a particular field in the database:

tell application "FileMaker Pro"

get data of field "Assets_title" as string

end tell

another script in filemaker or external to it?

  • Author

Actually I would like to just paste the other apple script into the one posted here. So I would just tell FM to perform an external script which would call the Applescript that gets the data I need and uses that to print the barcode.

My barcode printing script is already written, I just don't know how to get the field data from the current record, hold onto it, and use it in the rest of the printing Applescript.

I am open to other suggestions.

get data of field "Assets_title" as string

You do not want that, cell is the identifier, field gives all values in such as:

{"14", "41", "104", "11942", "11943", "11944", "11945", "11946", "11947", "11948", "11949", "11954", "11964", "11974", "11984", "11994", "12004", "12014", "12024", "12034", "12040", "12041", "12042", "12043", "12044"}




Which is the values of EACH records field x ....To get a value from a record use cell.



So what your script should look like is:




tell application "FileMaker Pro"

cell "Assets_title" as string

set X to result.

end tell

--sd

  • Author

Thanks for that. My code was a little different. How do you grab the cell data of the record that is currently being viewed? When I switch records, then run either your scipt or my script, the result still gives me the cell data of the first record.

Below is my code. All I have to do is figure out how to get FM to give me the data of the current record, and tell the Dymo app to print.

By the way, do you know how to do a return line and add text using applescript? The applescript generates the barcode from the cell data, but I'd like to take the cell data and print it below the barcode as well.

tell application "FileMaker Pro"

set the field_content to get data of cell "Assets_title" as string

end tell

tell application "DYMO Label"

loadPlugin name "Tape Editor"

openLabel in "/Applications/DYMO Label/DLS SDK/SDK Examples/Empty12mmTape.DLF"

tell current plugin

addbarcode with "2000" position top size large type Code128B

end tell

end tell

  • Author

OK, I got the first issu solved. I just had to add "of current record" after "Assets_title"

Still need help with the others.

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.