Fusion Manage Forum
Welcome to Autodesk’s Fusion Manage (formerly Fusion 360 Manage) Forum. Share your knowledge, ask questions, and explore popular Fusion Manage topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Computed fields and Picklist

1 REPLY 1
SOLVED
Reply
Message 1 of 2
jpiggee
567 Views, 1 Reply

Computed fields and Picklist

I have a computed field that is referencing a picklist, but the computed field is not working as it should!

 

Example:

Field = TIME_OF_DAY

Picklist: Morning, Afternoon, Night

 

Script:

(CASE

WHEN (TIME_OF_DAY = 'morning’) THEN 'one'

WHEN (TIME_OF_DAY = 'night')THEN 'two'

ELSE 'three'

END)

Joseph Piggee
Fusion 360 Administrator
TPI Composites
jpiggee@tpicomposites.com
1 REPLY 1
Message 2 of 2
jpiggee
in reply to: jpiggee

Solution:

Computed fields reference picklist by the position of the picklist option, not the value of the choice shown

For your example the “Morning, Afternoon, Night” the position is based on the last item being equal to 1

 

Example:

Morning = 3

Afternoon =2

Night =1

 

Script to use:

(CASE

WHEN (TIME_OF_DAY = 3) THEN 'one'

WHEN (TIME_OF_DAY = 1)THEN 'two'

ELSE 'three'

END)

Joseph Piggee
Fusion 360 Administrator
TPI Composites
jpiggee@tpicomposites.com

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report