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
Can you share the code of that interface?
I assume you are using a foreach to iterate on the rows. Do you use fv!item to reference the values?
Sorry Stefan, i cannot share a code it's a organisation policy but for labels i am using fv!item and for values I am using local variables where values of document data is populating with fv! index in textbox
If you can share a code with above scenario what I have written how can be it is shown as sample with for each then i can use it as a reference in UI
Sorry, but without seeing your code, I cannot say anything.
okay, i will give you a logic of that code not whole code you can see what is need to be updated
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?
I am not understanding Konduru, i am using cardlayout for boxes
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] ) ) } ) ) ) )
It is not working stefan, I want without hardcoding values, i have shared a screenshot of document when file gets uploaded ER get called
The data structure I created should be quite similar to the one you have.