unstored calc not updating

[greerso]

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

[mr_vodka]

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

[greerso]

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

[mr_vodka]

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.

[greerso]

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

 

Thanks again for the help.