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.
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.
Stefan and Konduru, code is working, thank you