I have been stuck with this problem for quite some time, and after searching forums, couldn't find an apt answer to my problem. Here goes the story:
There is a form with four fields, A, B, C and D. A and B are essentially two different kind of editable fields and the value of editable fields C and D is decided by value of A and B subsequently.
I have to display this document in a view. The first column is a categorized one with a formula as below:
@If(@Explode(dispStr;",") = "";"NotAvailable" ; @Explode(dispStr;","))
Consequently the same document is displayed in two rows, if both A and B have a non empty value.
In the next column in the view, I have to display either C or D based on the category in the earlier column i.e either A or B respectively.
But I am unable to meet this requirement. I cannot display individually C and D for the respective parent fields A and B.
I have tried using programmatic name to obtain the appropriate value but in vain. The first column was named $x and following formula used in the next column:
but it displays both the values for that column which I cannot implement.
Can anyone suggest a fruitful outcome? I have succinctly explained the problem, I have around 10 fields like A, B and corresponding fields like C and D in reality.