Creating a BoxLayout

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

Parents
  • 0
    Certified Senior Developer

    Hi ,

    Try using grids

    a!columnsLayout(
          spacing: "NONE",
          columns: {
            a!columnLayout(
              contents: a!gridField(
                data: local!result,
                columns: a!gridColumn(value: fv!row.values[1])
              )
            ),
            a!columnLayout(
              contents: 
              a!gridField(
                data: local!result,
                columns: a!gridColumn(value: fv!row.values[2])
              )
            ),
            a!columnLayout(
              contents: a!gridField(
                data: local!result,
                columns: a!gridColumn(value: fv!row.values[3])
              )
            ),
          }
        ),

    It looks like this

Reply
  • 0
    Certified Senior Developer

    Hi ,

    Try using grids

    a!columnsLayout(
          spacing: "NONE",
          columns: {
            a!columnLayout(
              contents: a!gridField(
                data: local!result,
                columns: a!gridColumn(value: fv!row.values[1])
              )
            ),
            a!columnLayout(
              contents: 
              a!gridField(
                data: local!result,
                columns: a!gridColumn(value: fv!row.values[2])
              )
            ),
            a!columnLayout(
              contents: a!gridField(
                data: local!result,
                columns: a!gridColumn(value: fv!row.values[3])
              )
            ),
          }
        ),

    It looks like this

Children