I have a 'Follow Up Date' in my contacts table as well as in my 'Call Data' table. I use the Follow Up Date (FU_Date) for my Follow Up script. It determines what records show in my layout. I use this if, for instance, I don't get to all my calls within a given period. By resetting the FU_Date I can have the record continue showing up until completed. On the other hand if I call a contact I set my 'Do When' field as the follow up date. I tried to create a calc where the 'FU_Date' would set to either the greater of the 'Do When' Date or the 'FU_Date.' See below:

Problem:

It will only reset the 'FU_Date' when I physically go into that field and attempt to set a date. How can I make it recalculate immediately? I have an "Enter Data' button which commits the record, but, that doesn't update the field.

Any suggestions would be appreciated.

Al

Edited April 1, 200817 yr by Guest

Anyone have any suggestions?

Since you're checking data in a related table, you can't use a Date field with an auto enter calculation. You need a Calculation field with a Date result and it needs to be set to unstored.

Or you could keep it a Date field and have your "Enter Data" button Set Field[] the field to the calculation instead.

BTW, I don't think Last() is the best function for what you're trying to do. Max() is a better choice.

Shouldn't this be solved with Ugo's method??

--sd

Soren:

What's Ugo's method?

DJ:

So I need to change FU_Date to a calc field? But, then the 'Do When' field is the only place to enter the FU_Date? I tried using scriptFire and zippscript, but, I can not get them to fire the script I want. Perhaps 'Event Script?'

I tried both these commands in the 'Do When' field:

"zippScript_PerformScript("SearchGroupDB"; "Set Follow Up Date")"

"SFire_AddScriptTask( "FU_Date"; "Set Follow Up Date")"

Soren:

What's Ugo's method?

Exploitation of tunneled relations, via the state of the data a record actually holds...

Take a look at the template:

--sd

aldipalo.zip

Soren:

Thanks, it's very interesting. I'll take it apart this weekend and see if I can grasp it.

Al