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 Reply
  • 0
    Certified Lead Developer
    in reply to Yash Gandhi

    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]
                )
              )
            }
          )
        )
      )
    )

Children