AnsweredAssumed Answered

Script Help - Change X when date X exceeded

Question asked by ChristofferRexen_1 on Jul 2, 2014
Latest reply on Jul 2, 2014 by philmodjunk

Title

Script Help - Change X when date X exceeded

Post

     Hello everyone

     All new to FileMaker Pro Advanced, but i'm catching up pretty good I think..

      

     I have this database, see attached image.

     I would like the field "Status" to place an X within one of the tree boxes under Status: "Tilmeldt", "Afmeldt", "Barn", if a person, in this case "John Doe", is employed or not. Furthermore I would like the field "Status" to update whenever a new entry has been made and then re-set the X in the correct box, let's say he gets re-employed.

     I got this far with the script, but am i'm missing something, the field is "Unstored".

     Case ( Resigned  ≥ Get ( CurrentTimeStamp ) ; Status = "Afmeldt" ; Resigned   ≤ Get ( CurrentTimeStamp ) ; Status = "TIlmeldt" ;
     "" )
      
     Thanks in advance.
     CR

Sk%C3%A6rmbillede_2014-07-02_kl._09.56.24_kopi.jpg

Outcomes