Map Columns

Before you begin

Add textbox widgets (where the app will deposit the data from the external data widget) to your app.

Add a supported data import connection to the app. The External Data widget pulls information from this source.

  • CSV
  • Google Sheet
  • Microsoft Excel
  • OneDrive Sheet

About this task

The Map Columns action automatically populates the field of a linked widget (such as a textbox) with content that an app user selects from an external data widget. You can map different columns in the external source to different widgets.

The textbox is updated or cleared as the new external data widget selections are made by the app user.

Note: This action is not supported if the Allow multiple value selection setting is enabled on the External Data widget.

To configure the Map Columns action:

Procedure

  1. On the Events tab of the External Data widget, with the On Select/deselect event selected, click Add and select Map Columns from the Add Action list.
  2. Select a Data Import source and select Map Fields.
  3. Click Next. Drag and drop a Column (from the data import source) to an App Field.
    Whenever the app user makes a selection in the external data widget, the value from the mapped column is placed in the mapped app field.

    You cannot map multiple columns to the same app field.

  4. Optional: You can also map columns to variables. Click Manage to add a new variable if you don't already have any created for this app.
    Whenever the selected value changes, the variable is updated throughout the app. Read more about global variables at Global Variables.
  5. Click Finish to close the Map Columns wizard and then click Add to add the action to the widget.
  6. Click Save to save your changes.