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.

Limits to "set contents of cell"

Featured Replies

There seems to be a limit imposed on the amount of text that one can read into a cell from AppleScript in this way.

Does anyone know a way to get around this?

I have a text file that I read in and then copy into a text record in FileMaker. AppleScript reads 2500 lines, but then only transfers 85!

-- request the file containing the text 

set filePath to POSIX path of (choose file with prompt "Select text file for import" without invisibles)



-- get the text of file and put it in current FileMaker record

open for access file filePath

set fileText to read POSIX file filePath as text

close filePath



try

	tell application "FileMaker Pro Advanced"

		tell table "ImportTable"

			set contents of cell "filepath" to filePath as text

			set contents of cell "filetext" to fileText as text

		end tell

	end tell

end try

  • Author

Just a quick further note to say that it works fine when you manually transfer the text via the clipboard. If I try to copy and paste using AppleScript, I get the same limiting problem.

Create an account or sign in to comment

Important Information

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

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.