EPDM Card - SI Function

PDM
1

Hello

I want to create a variable from another on EPDM but I don't know if it's possible.
In fact, I have a variable, which appears in read on my file cards named "CATEGORY". This is a list that appears in a prior pop-up that can have the value "Automotive", "Military"... etc

However, I was asked to change this to English. I wouldn't want to change these values at the risk of blowing something up, and furthermore, it would require me to manually change all the values already entered.
The user could continue to choose the category in French, it's not a problem for me. But in my search result columns, I would like it to be displayed in English.

Wouldn't there be a way to create a variable "CATEGORIE_ANGLAIS", which, on the file card, would have a condition like If CATEGORY="Automotive", then "CATEGORIE_ANGLAIS"="Automotive"? I tried something like this with formula aliases but I don't really understand how it works and it didn't work...

If anyone has an idea, it's with pleasure.

Thank you in advance!

2

Hello

It sounds simple but it's not really.
A possible lead: the lists in EPDM.
The list tool is quite powerful (since you can put SQL queries in it).
Not sure that it is enough on its own to answer the problem though.

Hopefully, someone else will have an obvious solution.

1 Like
3

Hello

In your map you must have a read-only text field that will be "driven" by the drop-down list in FR.
You assign it the variable you want, and then in the input formula field you enter something like this:
%CATEGORY(Automotive=Automotive,...) %
Don't forget the percentages on both sides of the text.
Personally, I use Excel to concatenate the text because I have a lot of criteria. I do this on two text fields that are read-only.

3 Likes
4

Hello Cyril,

Thank you, it finally works! Super!

Have a nice day!