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

Calculated Container Field in IWP

Featured Replies

In my table, I have three container fields. I have a fourth Calculated field, which using a case statement and numeric values in other fields, will set itself equal to one of the three container fields. Eg:

Case(Value=1; Image1;

Value=2; Image2; ...etc)

This seems to work fine when the application is accessed through FileMaker. The probelem arises when trying to view the calculated field through IWP. I just get the "broken image" icon.

Can you not use a calculated field set to return a container type inside IWP? Any help would be appreciated.

first why not use a choose statement:

Choose ( Value+1 ; Image1 ; Image2 ; Image3 )

its much simpler. (ps the plus 1 is because the first result is 0)

Second are you storing the images as references or are they embeded?

  • Author

The images are embedded, not just references.

It works correctly when accessing through a FileMaker client. It's only when accessing through IWP that there is a problem.

Now though, I have discovered another quirk. The image displays just fine on the "Default" layout that was created when I built the table. But, on a different layout, I have a portal to this table. In that portal, all the other fields are displaying, except my calculated container field is showing as a broken image.

  • 1 month later...
  • Author

As a follow up for those who are interested, I have solved this problem.

Let's say you have three tables: A, B, and C. A has a relation to B, and B to C. If you are in a layout showing records from table A and on that layout you put a portal to table B, container fields from table B will show fine.

If, however, you have a portal to B, and inside that portal use a container field from C, it will not display properly in IWP. They will display just fine from inside FM, but not IWP.

Thanks for the help and insight, everyone. Hope this helps somebody.

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.