AnsweredAssumed Answered

Selection on a Value List triggers a date, help

Question asked by AAgraphics on Nov 6, 2009
Latest reply on Nov 6, 2009 by david_lalonde@d-cogit.ca

Title

Selection on a Value List triggers a date, help

Post

We are using FMP10 

 

I have a value list that is a very important value list in our database.  The value list has different events and as one key event is selected in the value list, I want the selection of a specific value in the value list to trigger the entry of a date in another field.  However, as different events are selected on the value list, I do not want the previously entered dates to be modified.  Here is a simplified summary of what the value list looks like:

 

Concept

Concept Approved

Pre-Production

Pre-Production Approved

Production Started

Production Completed

 

Now when "Concept Approved" is selected, I want the field that is titled "Concept Approved" to have the date of when "Concept Approved" was selected.  However, as other values are selected on the value list, I do not want this date to change.  There are other dates that I want to be triggered by the value list, like "Pre-Production Approved".  How do I write a calculation for this?

Outcomes