How to Force Portal Refresh???

[Brett W]

Good day too all,

I have a question with a portal refresh issue I have run into. I am using two DataBases(DB), one as a calendar, another as my LeadManagement table. What I am trying to accomplish is to display records from the LeadMgnt DB on the Calendar for any given day, through a portal.

Because I don't have a different database for Appointments, the LeadMgnt file has appointment dates in it, and these records are of families, so multiple people from one family can show up on one date, annoying! That problem is fixed with a custom function, but the issue now is Portal Refreshing. When I move to a different date, the portal stays at the date I started with even though the field in both DB's have changed. The only way to get the portal to update is to go into the Define DB and evaluate the calculation I had made, even though I don't change anything, and then press ok. The portal refreshes!!

How do I accomplish this every time I change the date? Would the relationship between a List field and single records be an issue? Any help would be appreciated.

[Ender]

You might try the Refresh Window [ Flush Cached Join Results ] script step. If that doesn't do it, then there might be an issue with the way the key fields are defined.

[Brett W]

Thank you Ender, works perfectly!

[MetaSys Software]

Hi.,

I have a similar problem ... refreshing portals on the network

I have a DB where I create or edit records on one layout (A) and these records are viewed thru a portal on another layout (. While on the network, one user is on layout B and another user creates or edits a record in layout A ... BUT the problem is the record created in layout A on one computer does not immediately get displayed in the portal in layout B on the other computer. Or if while editing the field values change as required by the relationship, the record remains displayed in the other portal/computer.

And this is not only while creating records ... It happens even when a value of some particular field changes thru some process and that field is part of the relationship for that portal.

I am also using Commit record, wherever appropriate in the scripts.

If I move out of layout B and come back or just toggle between some tabs (on layout B itself), then this new record gets displayed.

I have also checked with the "Refresh Window" script step using both the options - Flush cache join results ON & OFF, but still the portal does not get refreshed immediately/dynamically.

I am using global fields (constant values) for the relationships ... BUT this could not be the reason as I checked by changing these to normal fields also.

Hope the problem is clear ... Any suggestions from anyone.

Thanks & regards,

ANAND MOHAN

Edited January 30, 2007 by Guest

[dbrowdy]

Ahh NM, the "Commit Record" script step seems to solve my issue!

Edited February 8, 2007 by Guest