Creating a BoxLayout

Question

Hi Team, 
 In Excel sheet, as per rows I want separate BoxLayout with the separate entries into it. For Example, 
 I have a 3 rows with column firstname, lastname and city as per first row of data I want to put in 1st BoxLayout , 2nd row of data in 2nd BoxLayout, 3rd row of data in 3rd BoxLayout without hardcoded. 
 I am getting 3 seperate BoxLayout with column name firstname, lastname and city that I am satisfied I am getting in UI but result for all the rows of records in excel sheet is showing in all the three BoxLayout not showing in 3 different entries in 3 BoxLayout. 
 So if you can suggest it how to do it per records will having seperate BoxLayout with rows of records in excel sheet? 
 I am sharing a screenshots for reference 
 
 In 1st BoxLayout data would come firstname - rakesh, lastname - sharma, city - mumbai 
 In 2nd BoxLayput would come firstname - rahul, lastname - dongre, city - gondia 
 In 3rd BoxLayput would come firstname - priti, lastname - kataria, city - delhi

Konduru Chaitanya · Accepted Answer

In the items, get rid of [1] . That should do.Also define the first a!forEach in a correct format. But where is the box layout?

Stefan Helzle · Answer

a!localVariables(
 local!result: {
 {
 values: {
 "firstname",
 "lastname",
 "city"
 }
 },
 {
 values: {
 "rakesh",
 "sharma",
 "mumbai"
 }
 },
 {
 values: {
 "rahul",
 "dongre",
 "gondia"
 }
 },
 {
 values: {
 "priti",
 "kataria",
 "delhi"
 }
 },
 },
 a!forEach(
 items: remove(local!result, 1),
 expression: a!localVariables(
 local!row: fv!item,
 a!boxLayout(
 marginBelow: "STANDARD",
 contents: {
 a!forEach(
 items: local!result[1].values,
 expression: a!textField(
 label: proper(fv!item),
 value: local!row.values[fv!index]
 )
 )
 }
 )
 )
 )
)

Creating a BoxLayout

Top Replies