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.

Using Calculations in a Container Field

Featured Replies

Sorry about posting a total noob question, but for some strange reason I can't get the calculations to work properly for a container field. I want to display some images using a pathname from another field.

So I created a field called Imagepath that holds the following text:

"image:images/product.jpg"

Where images is a subfolder in the folder where my database resides.

So I created a container field called Image with the Auto-enter Calculation as simply

"Imagepath"

When I jump back to my layout, there is absolutely nothing in the container. I'm I doing something wrong??

Try inserting a new pciture into the Container field or even the same picture. Since you created the auto-enter calculation after the container field was populated, there is no change to the container field to trigger the auto-enter. Also, you might want to uncheck the "do not replace existing value (if any)" option so the auto-enter updates when the container value is changed. Otherwise, once the auto-enter occurs, it won't replace the existing auto-entered value.

  • Author

yeah... I don't know what’s wrong. I tried doing that, and it didn't work.

Here's exactly what I'm doing.

1. I'm starting with an empty database with no information.

2. I have all of my fields set up including the Container Field with the Auto-enter calculation.

3. I’m importing about 2500 records for another database, including my Imagepath field as the text "image:images/product.jpg"

Shouldn't the container field update it self once I do the import?

I believe a calculation field with the result set to type Container would make more sense. If that doesn't show your image, then your path (or path syntax) is incorrect.

  • Author

Thanks dood!

It worked. OMG FM is so corny. I can't believe it was so simple as to just doing a calculation with my Imagepath with the the result of container. Meh!

  • Newbies

I found this thread discussing exactly what I wanted to do with a library of scanned music. Thanks everyone. I was able to get it working quickly.

I'd like to add that after getting it to work, I managed to simplify it. There's no need to have a separate calculation field or an auto-entry item. Just make the image field a calculation which calculates the path with result as a container. That way it's always updated automatically and you have one less field to clutter up your database.

John

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.