The Wonderful World of Tables in ArcGIS Online

Recent updates to ArcGIS Online have brought more of the table functionality from Desktop into Online. These enhancements now allow you to edit tables within your browser, use domains to allow for drop-down boxes within your data and have related tables. The following sections will show you how to get up and running with this new functionality.

Editing Tables Online

Our users voiced, through ideas.arcgis.com, the fact they were very keen to see the Field Calculator and the ability to add fields to a table within ArcGIS Online. We are glad to say this functionality is now available Online.

The field calculator allows you to do calculations on your existing columns. This is useful for tidying up the formatting of fields and calculating statistics. To access this functionality within your webmap, click on the arrow on your layer and select Show Table. From here, click on the column heading and select Calculate which will bring up the field calculator. 

The Add Field functionality means you no longer have to go back to your original data to add the field and then republish it. Instead you can do it within the browser, saving you lots of time. To do this: go to Show Table and go to Table Options on the right-hand side of the table and click Add Field. 

Domains

Domains are a useful way of maintaining data integrity by only allowing users to input data using drop-downs. ArcGIS Online now allows you to publish data that has domains from ArcMap. So now when users are editing this data within the browser or Collector, they only have the choice of what is in the drop-down.

For those of you unfamiliar with how to set up domains:

  1. You will need to save all your data as feature classes within a File GeoDatabase. Domains are set at the File GDB level so you can have data integrity across multiple datasets.  

To set these up, go to the File GDB’s Properties and go to the Domains tab. In the top section, name all your domains you want to include and a description. For example: Trees – types of trees. Then in the middle section specify the type of field it is and in the bottom section specify the allowed values eg. Larch, Oak and Birch.


      2. You will need to assign this domain to the field within your feature class you are interested in.

To do this, right-click on the feature class within your File GB and go to the Fields tab. Click on your field of interest and in the bottom table section, assign the name of the domain you want to use.


For more info on setting up domains see here.

Now if you publish this data to ArcGIS Online, when you enter an edit mode, only drop-down options will be available.

Related tables

Related tables allow you to do one-to-many relationships between data rather than joins which are one-to-one relationships. These allow you to link various datasets based on key fields.

To do this:

  1. Save both your feature class and table within the same File GDB.
  2. Right-click the File GDB and create a new Relationship Class
  3. Follow the wizard to create a relationship between your feature class and your table.
  4. Drag and drop both your feature class and table into the table of contents
  5. Publish the data to ArcGIS Online

Now when you add the map to a webmap in ArcGIS Online and click on a point on the map, it’ll display Show Related Records at the bottom of the pop-ups and filter the related table to show the matching records.