AnsweredAssumed Answered

'Do nothing' as part of a calculation

Question asked by JodieWeston on Aug 23, 2018
Latest reply on Aug 23, 2018 by PeterDoern


Help, please

 

I have a text field with an 'Auto-Enter' calculation this is based on the content of another field. It's set to replace existing value.

 

Act field (this is the field with the auto-enter option)

When the record is created, a value is entered into this field.

 

Status (this is the field Act is based on)

This field has a value list with a number of entries:

CBB

Final

Omit

On Hold

 

The calculation currently changes the 'Act' field if Omit, or On Hold are selected. However, if CBB, or Final are selected the contents of the Act field is deleted. I would to update the script, so If the status is changed to CBB, or Final it does nothing...

 

Here's my script -

 

If ( Shot Status = "Omit" ; "Omitted" ; If ( Shot Status = "On Hold" ; "On Hold" ))

 

Thanks!!!!

Outcomes