How do I add a subtable to the detail form of my app?

I have a use case for my application where I’d like to store a small subset of data on the detail form of my application. What’s the best way to configure this?

If you already have a subtable on your main table, you can skip this step. Otherwise - create a Subtable with the fields you’re interested in tracking, then create a Data Item of type Subtable and link it to the subtable you’ve created, then add that data item to your main table.

In Application Builder for your application, you can navigate to the Detail form using the Configuration panel on the left side. You can create a new row, page, and/or column using the selections in the center Viewer panel, then simply click and drag the subtable field from the Fields section of the left panel over the new space in the application. You can alternatively use the right Field Properties panel after selecting the subtable field and select a row, column, and page without dragging.

  • Note: there is no ability to define which fields from the subtable appear on the application
3 Likes

In addition to what Ross said above, you can select which fields from your subtable are visible / not visible on your application. Please see the following steps depending on which release you’re working in.

25.1

  • Ensure you are on the detail form in visual app builder by selecting the “Detail” form from the Forms drop down in the upper corner of the middle panel in visual builder.
  • Click on the desired subtable in middle panel which should be showing a visual layout of the Detail Form.
  • In the Field Properties panel on the right-hand side, toggle the “Subtable Fields” toggle, which will change the left-hand panel to be a list of all available fields
  • Drag and drop any desired fields from that panel onto the visual builder.
  • Save.
  • Generate.

25.2

  • Ensure you are on the detail form in visual app builder by selecting “Detail” in the left-hand configuration panel.
  • Click on the desired subtable in middle panel which should be showing a visual layout of the Detail Form.
  • In the Field Properties panel on the right-hand side, toggle the “Subtable Fields” toggle, which will change the left-hand panel to be a list of all available fields.
  • Drag and drop any desired fields from that panel onto the visual builder.
  • Save.
  • Generate.
2 Likes