topic Re: Auto populate attributes in a layer using data entered in a related table in ArcGIS Online Questions

Auto populate attributes in a layer using data entered in a related table

ACA — Wed, 09 Mar 2022 00:15:36 GMT

I have a TREEINVENTORY layer connected to a related INSPECTION table, both are used in a FieldMaps map. When I enter information in the INSPECTION table in Field Maps, I would like to have some of the data that is entered automatically populate a few fields in the TREEINVENTORY layer. Is this possible and if so what are the steps.

Thanks

Re: Auto populate attributes in a layer using data entered in a related table

jcarlson — Wed, 09 Mar 2022 13:26:46 GMT

It really depends on where you're trying to do this, and what you want it to look like.

If you mean that a literal field should have its values updated in one table based on values in the second, there's no way to do that "automatically", though you can get a Python script to run on a schedule that can accomplish close to the same thing.

But if it's acceptable to simply show that value, so in a popup or a dashboard, then Arcade can return those values and display them without needing a separate field in the main table.

Can you elaborate on the end goal here?

Re: Auto populate attributes in a layer using data entered in a related table

ACA — Wed, 09 Mar 2022 23:33:59 GMT

My goal is to keep track of species, size (diameter) and health information over time in the INSPECTION table. The TREEINVENTORY layer table would contain the most recent inspection data.

My initial thought was to enter this data in the form for the TREEINVENTORY layer, and then using the inspection form automatically 'grab' and copy over some of the data to the INSPECTION table.

Thanks