Prepopulate external table from feature class in Field Maps

Question

Hello everyone,

We are working in field maps with our water pumpstations with external tables related back to the feature class (pumpstation)

Is there a way to prepopulate certain fields in the external tables from fields in the feature class every time a new inspection is done? We are trying to eliminate repetitive work and save time with the inspection.

I've looked over any information I could find on this answer but I'm not able to come up with the solution I need.

Has anyone else been able to accomplish this and what did you do?

Thank you for your time,

dougbrowning · Answer

No need to copy the data over you can do a lookup with Arcade.  Always better to not double store data.

https://community.esri.com/t5/arcgis-collector-questions/dynamic-symbology-based-on-days-passed/td-p/474001

https://community.esri.com/t5/arcgis-online-questions/how-to-get-attribute-with-last-date-modified-from-related-table/m-p/293183/highlight/true

https://community.esri.com/t5/nonprofit-program-questions/how-do-you-reference-another-field-from-a-related-table-in/td-p/5094

Hope that helps.

gabrielriley · Answer

@DougMorgenthaler to answer you question about the pumpstation inspection, we are looking at transferring a simple copy of what is already in the feature class. Any help with this would be greatly appreciate.

Another question I might ask is, is there a way to transfer data from the inspection form back to the feature class. Example: we change symbology of pumpstations that have been inspected (e.g 2020 to 2021 would be different colors on our maps), is there a way to bring that data back from an inspection form to the feature class without them having to enter in repeat data on the inspection form from and then enter it again on the feature class?

happy to talk about this more over the phone if you can make the time and than you for your advice.

Gabe

DougMorgenthaler · Answer

@gabrielriley as @TravisSizemore mentioned we are planning to add support in the near future to perform calculations using Arcade as part of our forms capabilities. Do you want to transfer/duplicate the information from the pumpstation feature to the inspection, or just view this information while performing the inspection?

If you're interested in transferring that information and storing it in the inspection record, can you share any specific about what you'd want to transfer between the pumpstation and the inspection?  Would it just be a simple copy of the existing value?