Date Calc

[aldipalo]

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, 2008 by Guest

[aldipalo]

Anyone have any suggestions?

[David Jondreau]

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.

[Søren Dyhr]

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

--sd

[aldipalo]

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")"

[Søren Dyhr]

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

[aldipalo]

Soren:

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

Al