Strange number format when using lookups in sublists
Hi everyone
I just came across a weird behavior when dealing with lookups. Maybe others have experienced the same.
I'm trying to get a field value (a Number) from a sublist item using this statement:
[[EHRACISelectedImplemTasks.EHSubsequentImplemTask]]
Where EHRACISelectedImplemTasks is the field value on the current form which is a lookup column to a sublist.
Manually i select some of the items out of this sublist.
The EHSubsequentImplemTask is the field value i'm interested in (a number field), which is also a lookup to the same sublist.
My intention here is to have a reference between the items using a manually entered number.
Manually i select some of the items out of this sublist.
The EHSubsequentImplemTask is the field value i'm interested in (a number field), which is also a lookup to the same sublist.
My intention here is to have a reference between the items using a manually entered number.
The result of the code above looks like this:
Successful evaluation with result: "421.000000000000,422.000000000000,423.000000000000"
Successful evaluation with result: "421.000000000000,422.000000000000,423.000000000000"
In fact i expect the result to be like this: "421, 422, 423"
Where do these trailing zeros come from and how to get rid of them?!
Best wishes
Dieter
0
-
Hi Dieter
Can you try this expression instead of yours as workaround:
[[EHRACISelectedImplemTasks.EHSubsequentImplemTask.NUMBER_COLUMN]]
where NUMBER_COLUMN is the column name you want the value fromIt seems the returned value is not the actual form field value (bad formatted list item/lookup value instead) if these nested lookups are used.
Please let us know the result0
Please sign in to leave a comment.
Comments
1 comment