Form Layout with Grid and Additional Sections

Hi All,

I am trying to create a form with a grid and other fields (in addition to the grid).  I got some sample SAIL code, modified it and I've now gotten the grid to look and function as I want it to, however, I am now trying to add sections to my form using the Design Mode, but the interface does not allow me to add any section or fields either at the top or at the bottom of the grid.  I have attached my interface code here so that you can take a look and advice what I might be getting wrong.  How can I add more sections either above or below the grid?

Thanks.

 

------

=load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 20
   ),
  with(
    local!datasubset: a!queryEntity(
      entity: cons!CSHV_LINE_ITEM_CDT,
      query: a!query(
        selection: a!querySelection(columns: {
          a!queryColumn(field: "itemName"),
          a!queryColumn(field: "amount"),
          a!queryColumn(field: "qty"),
          a!queryColumn(field: "total"),
        }),

       
        filter: a!queryFilter(
       field: "cashAdvnaceId.id",
       operator: "=",
       value: ri!CashAdvanceData.id
       ),
       
        pagingInfo: local!pagingInfo
      )
    ),
    a!gridField(
      totalCount: local!datasubset.totalCount,
      columns: {
        a!gridTextColumn(
          label: "Item",
          field: "itemName",
         
          data: index(local!datasubset.data, "itemName", null)
        ),
        a!gridTextColumn(
          label: "Amount",
          field: "amount",         
          data: index(local!datasubset.data, "amount", null),
          alignment: "RIGHT"
        ),
        a!gridTextColumn(
          label: "Qty",
          field: "qty",
          data: index(local!datasubset.data, "qty", null),
          alignment: "RIGHT"
        ),
        a!gridTextColumn(
          label: "Total",
          field: "total",
          data: index(local!datasubset.data, "total", null),
          alignment: "RIGHT"
        )
      },
      value: local!pagingInfo,
      saveInto: local!pagingInfo
    )
  )
)

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    with() and load() can only have one element after all of the local variable definitions. In the case of your code it is the gridfield(). You can either place {} around the gridfield() and any other components you add, as was suggested previously, or you can place the gridfield() and any other components inside of a layout component such as a dashboardLayout() or formLayout().

Reply
  • 0
    Certified Senior Developer

    with() and load() can only have one element after all of the local variable definitions. In the case of your code it is the gridfield(). You can either place {} around the gridfield() and any other components you add, as was suggested previously, or you can place the gridfield() and any other components inside of a layout component such as a dashboardLayout() or formLayout().

Children
No Data