Some help with formula

Hi There are any way to change the value of a Choice field depending on another field with the same information.

The Choice value have :

10% Start

35% 1er Drawing

65% Issue A

80% Issue B

100% Final Review

The another field is a Formula field the result could be: 10% or 35% or 65% or 80% and 100%

- Fred
- 1 yr ago
- Reported - view
Not with simple choice fields. You have to use dynamic choice fields.
- Rafael Sanchis
- Rafael_Sanchis
- 1 yr ago
- Reported - view
Hi Fred.

Ok I change the The Choice field with the Choice dynamic easy because I have a table with the Milestones 10% 35% 65% 80% and 100%.

Now I need when the other field formula change to one of this values the Choice dynamic change to the same value.
- Fred
- 1 yr ago
- Reported - view
oops, I mis-read your post. You can use one regular choice to set the value in another regular choice. I thought you wanted the choices to change, which can't be done with a regular choice.

To set a choice field you can do something like this in the Trigger after update of choice1:

switch choice1 do case 1: choice2 := 1 case 2: choice2 := 2 etc. end
- Fred
- 1 yr ago
- Reported - view
But why have two fields that basically have the same data?
- Rafael Sanchis
  
  Rafael_Sanchis
  
  1 yr ago
  
  Reported - view
  Fred
  
  Hi Fred The idea is
  
  When I place the Date on 'Real 3 Rev A' the Issue type change to Rev A
  
  Then when place Date on 'Real 4 Rev B' the Issue type change to Rev B
  
  And the same on ' Real 5 Rev. 0'
  
  For what ? To follows a Notes a follows the Issues. Like the second image.
- Rafael Sanchis
- Rafael_Sanchis
- 1 yr ago
- Reported - view
'Issue type' := 1

as easy as this.

Content aside