Complex Calculation

Question asked by vincer on Nov 5, 2017
Latest reply on Nov 9, 2017 by vincer

Hello

I am trying to make the following simpler and smoother.

I have 9 Container Fields (Field_1, Field2, etc). Fields may (or may not, depending on previous calculations) have a shape with a specific orientation (up, down, left, right). The shape images have their own name previously designed with Photoshop. Therefore for example in case of arrows, the name of the images would be: "Up_arrow", "Down_arrow", "Left_arrow" and "Right_arrow".

Then I have a calculated field which should which should extract all the tags of the 9 fields based on orientation of the shape.

For each single field, extracting the name is simple using Case function:

Case (

leftwords (Field_1; 1) = "up"; tag1;

leftwords (Field_1; 1) = "down"; tag2;

leftwords (Field_1; 1) = "left"; tag3;

leftwords (Field_1; 1) = "right"; tag4; "")

But having 9 fields to be calculated and having the "tags" (1,2,3 and 4) values in 3 different languages makes the calculated field quite long.

Is there any function (that I am not aware) for having the calculation simpler and shorter ?

Many thanks,

Vince