Re: Pop-up menu should tricker date

Another possibility is to use an auto-enter calculation rather than a
calculation.

So Auto-enter, replace existing value

Case(GetActiveFieldName) = "PopUpField and PopUpField = "Finished";
Get(CurrentDate);"")

Whenever the PopUpField is changed the auto-enter will be triggered and
assuming you do not change it again after "Finished" the date will
stick.

Matt Wills wrote:
> More likely
>
> Case ( PopUpField = "Finished" ; Get(CurrentDate) ; "" )
>
> Except that this will always show today's date. If your idea is to
> show the date on which the status was set to "Finished" and keep it
> that way, consider using EventScript (free plugin from
> http://www.softs4humans.com) to trigger a script which sets the date
> when the status changes.
> Just out of curiosity, what is the difference between "Begun" and "In
> Process"? Without specifics to the contrary, I would assume they are
> one and the same.
>
> Matt
>
> Remi-Noel Menegaux wrote on (8/31/2005):
>
>> NewField = Case(PopUpField = "Finished", Status(CurrentDate), "")
>> Set it 'unstored'.
>> Remi-Noel
>>
>>
>> "D" <d@xxxxxxx> a icrit dans le message de news:
>> 43158bc6$0$197$edfadb0f@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi
>>>
>>> I have created a pop-up menu in a FileMaker 7 database.
>>>
>>> The pop-up menu displays values from the value list called Status,
>>> which contains the following custom values:
>>>
>>> * Begun
>>> * In process
>>> * Finished
>>>
>>> When a user set the menu to "Finished", todays date (//) should be
>>> written in another field.
>>> So that this date can be recalled in the database.
>>>
>>> How can that be done?
>>>
>>> Thanks
>>>
>>> Daniel

--
Dan
Using
FMP7.03, WinXP SP2


.