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 Lead Developer

    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()
            )
          )
        )
      )
    )

Reply
  • 0
    Certified Lead Developer

    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()
            )
          )
        )
      )
    )

Children