Create 2 values based on a list of values

[dudumoscona]

Hi all,

i have a field that contains "leaving data" - if the employee left or fired and the reason.

left starts with V and Fired start with I .

Example V - Employee found a better place

                    I - Employee didnt do his job

i want to create a list box that will show only 2 values of "Fired" and "left" out of all the 100 reasons and also to show the Fired/left in the table i've built - is it possible?

[tresesco]

Try expression like:

If(Left(trim('leaving data'),1)='V', 'Left', If(Left(trim('leaving data'),1)='I', 'Fired'))

[dudumoscona]

Hi ,

Script wise it went fine , but i could not see the new field when i created a list box i added the syntex that i've wrote

[tresesco]

Are you saying that the field is not created or no value is there in the field?

[dudumoscona]

there is no field at all, i cant choose it (not there) on the fields list

[tresesco]

Did you run reload after modifying the script?

[dudumoscona]

yes 🙂

[tresesco]

Could you share screen shot of expression with just =<new field name>?

[dudumoscona]

yes sure

[tresesco]

Add one more field and see if that appears post load.
...
1 as test2,
...