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%
6 replies
-
Not with simple choice fields. You have to use dynamic choice fields.
-
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.
-
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 -
But why have two fields that basically have the same data?
-
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.
-
-
'Issue type' := 1
as easy as this.
Content aside
- Status Answered
- 1 yr agoLast active
- 6Replies
- 85Views
-
2
Following