Re: Pop-up menu should tricker date
- From: "Matt Wills" <I'm@xxxxxxxx>
- Date: Wed, 31 Aug 2005 12:03:24 GMT
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@xxxxxxxxxxxxxxxxxxxxxxxHi
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
.
- Follow-Ups:
- Re: Pop-up menu should tricker date
- From: Dan
- Re: Pop-up menu should tricker date
- References:
- Pop-up menu should tricker date
- From: D
- Re: Pop-up menu should tricker date
- From: Remi-Noel Menegaux
- Pop-up menu should tricker date
- Prev by Date: To Helpful Harry + Dan (about "Checkbox set")
- Next by Date: Re: FM 7 and counting records of similar criteria
- Previous by thread: Re: Pop-up menu should tricker date
- Next by thread: Re: Pop-up menu should tricker date
- Index(es):
Relevant Pages
|