Add, Map & Edit Data is a customized widget that combines two of Esri's out of the box widgets, Add Data and Edit, and drops a field-mapping step in between them. It came out of a recurring headache I kept running into. Someone has a spreadsheet or a layer they want to get into an existing editable layer, but the incoming field names never line up with the target, so the data has to be reshaped outside Experience Builder before anyone can edit it. I wanted the whole thing, add, map, load, and edit, to happen in one widget without leaving the app.
The user adds data the same way the stock Add Data widget works, from a file, a URL, or ArcGIS content. Then they map the incoming fields onto the target layer's fields. The mapping handles one to one, many to one, one to many, and many to many, so you can concatenate a couple of fields into one, split one field into several, coalesce, drop in a constant, or write a small expression when you need it. After a quick validate and preview, it loads the records into the target layer in batches, and then they can edit what they just loaded on the map with the regular Edit tools.
As with my other widgets, the target layer and the options all live in the settings panel, so you point it at your own layer without editing code. Mappings also export and import as XML, which means a mapping you build once for a recurring load can be saved and reused instead of rebuilt every time.
Read more...
