To show all fields in a record, add and configure a Display form control. To edit any field in a record (or to add a record) and save your changes back to a data source, add and configure an Edit form control.


Add a form, and show data

  1. Add a Drop down control, name it ChooseProduct, and set its Items property to this value:


    Note: If you're not sure how to add a control, rename it, or set a property, see Add and configure controls.

    The list shows names of flooring products from the data source.

  2. Add an Edit form control, move it below ChooseProduct, and then resize the form to cover most of the screen.

    Add a form

    Note: This topic describes the Edit form control, but similar principles apply to the Display form control.

  3. Set the DataSource property of the form to FlooringEstimates and the Item property of the form to this formula:

    First(Filter(FlooringEstimates, Name=ChooseProduct.Selected.Value))

    This formula specifies that, after you finish configuring the form, it will show the record that the user selects in ChooseProduct.

  4. In the right-hand pane, click or tap the checkbox for each field to show it.

    Show fields on form

  5. In the right-hand pane, drag the Name entry to the top of the list.

    Move a card

    The Edit form control reflects your change.

    Name at top

Set the card type for a field

  1. With the form selected, click or tap the card selector for Price in the right-hand pane.

    Select card selector

  2. Scroll down, and then click or tap the View text option to make the field read-only.

    View text

    The form reflects your change.

    Read-only number

(Edit form only) Save changes

  1. Select the form by clicking or tapping its scrollbar, and then rename the form EditForm.

  2. Add a Button control, and set its Text property to Save.

    Add a save button

  3. Set the OnSelect property of the Save button to this formula:


  4. Open Preview mode by selecting the play button near the upper-right corner (or by pressing F5).

    Open Preview mode

  5. Change the name of a product, and then click or tap the Save button that you created.

    The SubmitForm function saves your changes to the data source with which you configured the form.

  6. (optional) Select the close icon to close Preview (or press Esc).

    Close Preview

Next steps