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
The data structure I created should be quite similar to the one you have.
I think what Stefan has mentioned is just what you have asked for here in this space. It is working perfectly for me. What is that you are seeing on screen when you are using Stefan's code? You can just update the local with your ER or the source of the data. That should definetely work.
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() ) ) ) ) )
Stefan and Konduru, code is working, thank you
thank you daisymanmohansingh, your code is working