I am trying to use a calc field with a container result to display whether a phone number in a portal is selected as the primary number for the record.

 

I have a person table and a telephones table.  The person table has a field for "PrimaryPhoneID" that is populated by a script when the indicator icon next to the phone is clicked.  This part works.

 

I have a "isPrimary" field in the telephones table that uses ExecuteSQL to lookup the value in "PrimaryPhoneID".  This is where my problem is.  The result of that calc field does not update when I select a new primary number until after I click into another field on the portal.

 

In the example, you might ask why use ExecuteSQL?  My real database has a multi key field for the relationship between the tables so the result of a calc that uses the relationship would give results for more than just the current record.

 

Example attached.

PrimaryIndicator.fmp12.zip

Your portal results are being cached. You need to force a refresh via a script step in your ContactRecordLoad script.

Thanks for the tip, but that didn't fix the problem for me, same result.

Well based on the sample, that is my guess. Did you do a refresh window with flush cache? Your actual file may be needed to further troubleshoot.

Got it.  It was actually the other script on the button that needed the refresh.

 

Thanks again for the help.