Unstored calcs -- freezing file

[Steven Cappiello]

I have quite a few unstored calculations that generate a whole bunch of status information on the fly.

I just realized that if I remove a date from one of the fields (an acceptance letter date field), when I try to commit the record, Filemaker freezes.

Sorry, I can't upload the file ... there are too many things going on to explain all the fields, relationships, and what they do...

can anyone provide a general explanation of why this might be happening ?

Thanks.

[Steven Cappiello]

I pinpointed the cause of the problem.

After commenting the three lines in this calc, my problem goes away.

I need the functionality of this unstored calc.

The value list that the commented calc is a related value list that looks at a table occurrence of the same table to generate it's values from the context of the first table.

Case (

not IsEmpty(Rejection Letter); TextColor ("Rejected"; RGB ( 255 ; 0 ; 0 )) ;

not IsEmpty(Acceptance Letter); TextColor ("Offer Accepted"; RGB ( 255 ; 255 ; 255)) ;

((not IsEmpty(Offer Letter)) and (not IsEmpty(Withdrew date))); TextColor ("Offer Declined"; RGB ( 255 ; 255 ; 255 )) ;

((not IsEmpty(Withdrew date)) and ((IsEmpty(Offer Letter)) )); TextColor ("Withdrew Application"; RGB (255; 255; 155));

(not IsEmpty(Offer Letter) or not IsEmpty(Going_to_SKICAP)); TextColor ("Position Offered or Going to SKICAP"; RGB (75; 75; 155));

summary_queued_status = "queued"; TextColor ("Queued for Rejection"; RGB ( 255 ; 0 ; 0 )) ;

((not IsEmpty(Sem Date)) and (not IsEmpty(forwarded_on))); TextColor ("Application Forwarded"; RGB ( 255 ; 255 ; 255 )) ;

not IsEmpty(Sem Date ); TextColor ("Invited"; RGB ( 0 ; 255 ; 0 )) ;

not IsEmpty(forwarded_on); TextColor ("Forwarded"; RGB ( 255 ; 255 ; 255)) ;

/--> all commented

//(PatternCount(ValueListItems ( Get ( FileName ) ; "rejection_queue_status_translated"); "invited") ≥ 1 ); "Deactivated";

// (PatternCount(ValueListItems ( Get ( FileName ) ; "rejection_queue_status_translated"); "position_offered_or")≥ 1); "Deactivated";

// (PatternCount(ValueListItems ( Get ( FileName ) ; "rejection_queue_status_translated"); "accepted_or") ≥ 1); "Deactivated";

---commenting ends here //

TextColor ("Application in Review"; RGB ( 255 ; 255 ; 30 ))

)

[-Queue-]

How many items are currently in the value list?

Try using this calculation.

Let([ O = IsEmpty(Offer Letter); W = not IsEmpty(Withdrew date); S = not IsEmpty(Sem Date); F = not IsEmpty(forwarded_on); V = ValueListItems( Get(FileName); "rejection_queue_status_translated" ) ];

Case (

not IsEmpty(Rejection Letter); TextColor( "Rejected"; 16711680 );

not IsEmpty(Acceptance Letter); TextColor( "Offer Accepted"; 16777215 );

W; If( O; TextColor( "Withdrew Application"; 16777215 ); TextColor( "Offer Declined"; 16777215 ) );

not (O and IsEmpty(Going_to_SKICAP)); TextColor( "Position Offered or Going to SKICAP"; 4934555 );

summary_queued_status = "queued"; TextColor( "Queued for Rejection"; 16711680 );

S; If( F; TextColor( "Application Forwarded"; 16777215 ); TextColor( "Invited"; 65280 ) );

F; TextColor( "Forwarded"; 16777215 );

Position( V; "invited"; 0; 1 ) or Position( V; "position_offered_or"; 0; 1 ) or Position( V; "accepted_or"; 0; 1 ); "Deactivated";

TextColor( "Application in Review"; 16776990 ) ) )

[Steven Cappiello]

Wow.. thanks Queue!! if possible, could you tell me why this works ?