Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

loop through the records from xml data file in formCalc script

Avatar

Not applicable
Hi
I have a xml data file which contains a sequence of repeating applicant data like given below


US





II


CEO
Mr

111111111

0000000111
GuarantorA


111

IN
11111





WILLIAMS1
R3

KENNETH1
City1GU
PA
1934-03-14
abcdefgh@xyz.com

GU

R

113 Lazlo LaneCA
Suite 3500CA
OaklandCA
TX
11345
AL


I want to assign a textfield with a value based on the value of coap_flag.
So i need to loop through all the record and check the value of coap_flag and then assign the textfield a value based on that.

I am new to Adobe livecycle...Please help me how it can be done.

I have developed something like this
foreach Item in ($record.applicant[*].coap_flag) do
test.value=Item
if(test.value=="MA")then
concat($record.applicant.first_name,$record.applicant.middle_name)endif
endfor
0 Replies