Sep 19, 2019 05:58 AM
Hello,
I have two fields that I want to update when one of them updates.
The fields are “EN Course” and “DE Course”. When “EN Course” moves to the status of Live (drop-down select) I want DE Course to update to “Evaluate For Translation”.
What is the best formula to do that?
Thank you!
Sep 19, 2019 07:03 AM
Hi @Courtney_Sembler - is the DE Course value always dependent upon the EN Course value? If so, then you can use a SWITCH() function to drive the DE Course Value:
SWITCH(
{EN Course},
'Live', 'Evaluate For Translation',
'In Development', 'Some other value here'
)
JB
Sep 19, 2019 10:56 AM
Thank you - the DE Course isn’t always dependent on EN but would be sometimes. But when the EN Course Fields switches or updates to LIVE I want the DE field to change to “Evaluate for Translation”
Sep 19, 2019 11:10 AM
OK, that’s a bit more tricky then as the DE field can’t be free text, for example, and a formula at the same time.
What I tend to do in these situations is have a DE “override” field (text, for e.g.), then have the DE proper field be something like the formula above except when the override field is populated, in which case take that value instead. Not sure if this will work in your case, but if it sounds like it might let me know and I can show you the formula
Sep 19, 2019 11:11 AM
Or potentially, the logic could be:
Show the override value unless the EN field is “live” in which case do the formula. Same idea and still requires the override field.
Sep 19, 2019 12:55 PM
Thank you for the response!
Mar 16, 2021 09:48 PM
Would it be possible to instead have an automation setup to check the changes in the fields and respond accordingly?