Jump to content

Calculated Container Field in IWP

This topic is 5744 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 1 month later...

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.

  • Like 1
Link to comment
Share on other sites

This topic is 5744 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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