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
Discussion posts and replies are publicly visible
In Given Manner You Can Achieve the Following Requirements .
a!localVariables( local!result: { { values: { "firstname", "lastname", "city" } }, { values: { "rakesh", "sharma", "mumbai" } }, { values: { "rahul", "dongre", "gondia" } }, { values: { "priti", "kataria", "delhi" } }, }, local!data: a!forEach( items: local!result, expression: a!map( firstname: fv!item.values[1], lastname: fv!item.values[2], city: fv!item.values[3] ) ), local!columnsName: { "firstname", "lastname", "city" }, a!forEach( items: local!data, expression: if( fv!isFirst, {}, a!localVariables( local!indexData: fv!item, a!boxLayout( contents: { a!columnsLayout( columns: { a!forEach( items: local!columnsName, expression: a!columnLayout( contents: { a!textField( label: fv!item, labelPosition: "ADJACENT", value: index(local!indexData, fv!item, null), readOnly: true() ) } ) ) } ) }, isCollapsible: true() ) ) ) ) )
thank you daisymanmohansingh, your code is working