I'm looking for a solution to pre-populate a column when editing a related table. We have polygon features with a related table (hosted feature service) and simply want a way to insert new rows into that related table, which we can use the Edit Widget or Smart Editor widget in a WAB app just fine!
However, we'd like to prepopulate a common attribute from the selected feature when creating a new related record.
I've exhausted attempts to configure the widgets to accomplish this and now looking to see if an arcade expression can solve this for us.
Thanks!
For better explanation:
1. I have the Smart Editor widget configured on the Hosted Feature Service that has a single related table. When accessing the widget and selecting a single polygon feature, it populates the widget and does not allow the feature attributes to be edited (that's what we want):
2. Now when adding a new record to the related table "StandAloneEditGUID - TxTable", we'd like to have the FuncionalLocation column pre-populated with the FUNC_LOC value of the selected feature (see above screen shot)
Update: I can get both the Edit widget and Smart Editor widget to work as expected if the feature service was originally published with a relationship class that had a 1-M relate between the FUNC_LOC on the feature class and FunctionalLocation on the many table to auto-populate the FunctionalLocation value when creating a new record on the many table.
However, this same feature service is the source to a Survey123, which requires that 1-M relate to be between a GlobalID on the feature class and a GUID on the many table.
I attempted to republish the feature service with two relationship classes with both 1-M relates specified above, but the Survey123 doesn't like that and will not publish.