My form has a Computed Field called xyzBenes which allows multiple values.
In it the compute says:
@Transform(Worklist; “x” ; @If(@Begins(x; “xyz”); x; @Nothing))
In the computewithForm creation of the document “Worklist” is unaltered,
When I do Edit/Save Worklist is altered.
Does the statement below imply that Field A changes while Worklist doesn’t?
Field A:= @Transform(Worklist; “x” ; @If(@Begins(x; “xyz”); x; @Nothing))
Subject: @TranSform behaves differently in edit/save vs. ComputeWithForm
Correct.
From Designer Help:
Applies a formula to each element of a list and returns the results in a list.
So, the list element (in your case, a field in the document) is used as the source of data but the result (if ignored) is not written back to the document. If you need to alter Worklist, you can do:
Field Worklist := @Transform(Worklist; “x” ; @If(@Begins(x; “xyz”); x; @Nothing))
There are also ways of doing this without using @Transform, using combinations of @Trim, @Right, etc.