topic Re: How to get variable value inside IF Condition in Discussions

How to get variable value inside IF Condition

UserID16644 — Sat, 10 Jun 2023 20:50:49 GMT

Hi all,

I am stucked in this IF Condition, where I need to get the variable value(color) based on another column value (:Fruit). It always return an empty variable color. Please help

Here's my sample code:

If( :Fruit == "Apple",
color= "Red"; Target = {50};,
:Fruit == "Grapes",
color= "Violet"; Target = {50};,
:Fruit == "Cherry",
color= "Red"; Target = {54};
);

Re: How to get variable value inside IF Condition

Thierry_S — Tue, 14 Jun 2022 01:22:14 GMT

Hi,

It is unclear what you are trying to do given the limited context. Is this part of a JSL script or a column Formula? If it is the latter, you need to specify what the expression returns as shown below:

If(
	:Fruit == "Apple",
		color = "Red";
		Target = {50};,
	:Fruit == "Grapes",
		color = "Violet";
		Target = {50};,
	:Fruit == "Cherry",
		color = "Red";
		Target = {54};
);
color;

Also, are you sure that the column's content :Fruit matches precisely the values in your expression (i.e., no leading or trailing spaces)?

An example of the usage context for this expression would help figure out what may be going on.

Best,

Re: How to get variable value inside IF Condition

Mark_Bailey — Tue, 14 Jun 2022 13:53:38 GMT

You might consider the more specialized conditional function Match(). It is a nice alternative that is perhaps clearer as far as the intent and the result

Match( :Fruit,
	"Apple",
		color = "Red";
		Target = {50};,
	"Grapes",
		color = "Violet";
		Target = {50};,
	"Cherry",
		color = "Red";
		Target = {54};
);