Case ( Resigned ≥ Get ( CurrentTimeStamp ) ; "Afmeldt" ; Resigned ≤ Get ( CurrentTimeStamp ) ; "TIlmeldt" )This must be defined as the calculation for the field "status" or assigned via script by using this as the calculated result part of a set field step.status = "Afmeldt" is a Boolean expression that will return the value 1 (True) if the two parts are equal and 0 (false) if they are not.
I'm not sure I'm with you here? (New at FileMaker)
I take my existing Case function and replace it with you're Case function.
Although I have to make the field "Status" a calculation first?
I'm not sure if I got the whole thing with here.
When entering a new employe in the Database, the field "Status" ; "Tilmeldt" will get an X by default, if the field "Signed" is the same date/exceeds current date.
At the same time, "Status" will have to look at the field "Resigned" and check if the specific date "Resigned" is the the same date/exceeds current date.
By changing existing X from "Tilmeldt" to "Afmeldt" and vice-versa, so there's only one X pr. employe record.
I hope it makes sense.
Status will need to be one of the following:
- a calculation field. With this option, the field can no longer be edited directly. That may or may not be a problem.
- a text field with an auto-enter calculation. I can be possible to still directly edit the field.
- A text field updated with a script performed by a script trigger whenever you modify the value of the resigned field. This option works, but only on layouts where you set up such a script trigger and is needlessly complex unless it, for some reason, is the only option that works for you.