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.

Featured Replies

I have a container field in a table that contains pictures that are linked only. I would like to make the file more portable by having the pictures embedded instead of linked as I don't always have network access to the server where the pictures are stored. I have tried to run a loop script that copies and pastes from the original container field into a new one but it only copies the link. Insert picture function dialogue box only seems to give you the option of adding a file path and not a field itself. Is there a way of doing this or will I need to do it manually?

In your looping script, use a variable as path for Insert Picture. For each loop iteration, set this variable dynamically to your stored file path.

  • Author

use a variable as path for Insert Picture.

Thanks for your reply, could you give me a little more info on how to do this please? I haven't got round to using variables yet.

Basically (meaning: without error trapping and the usual script paraphernalia) it looks like this:

Go to Record/Request [ First ]

Loop

Set Variable [ $path ; Value: yourTable::imagePathField ]

Go To Field [ yourTable::yourContainerField ]

Insert Picture [ "$path" ] // that's how it shows in the script, but you write/insert the variable name without quotes. Also make sure to uncheck the Store only a reference option

Go to Record/Request [ Next ; Exit after last ]

End Loop

Maybe best to experiment with a subset of a few records until you've got it right.

  • Author

Basically (meaning: without error trapping and the usual script paraphernalia) it looks like this:

Go to Record/Request [ First ]

Loop

Set Variable [ $path ; Value: yourTable::imagePathField ]

Go To Field [ yourTable::yourContainerField ]

Insert Picture [ "$path" ] // that's how it shows in the script, but you write/insert the variable name without quotes. Also make sure to uncheck the Store only a reference option

Go to Record/Request [ Next ; Exit after last ]

End Loop

Maybe best to experiment with a subset of a few records until you've got it right.

Thanks for the detailed explanation, I'll try it at work tomorrow.

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.