Latest Contributions by AndresCastillo

If you are using a database view, it may not like to participate with geodatabase objects. You might try to register the view with the geodatabase, starting at 10.5, or ArcGIS Pro. https://community.esri.com/groups/geodatabase/blog/2016/12/14/new-at-105-registering-a-database-view-with-the-geodatabase ... View more

method 1: Try adding a domain to the 'SIC_ID' field at the geodatabase level, and assign coded values to the domain for each ID that exists in your table. If you have a lot of ID's, this task might get done faster by using the batch mode of the 'add coded value to domain' tool. In WAB, this should force the user to pick the ID from the drop-down of coded values. Let me know if this works to see if we use a different strategy. method 2: Is the table that contains the 'SIC_ID' field a feature class, or non-spatial table? If you can make it a feature class, you can use the attribute actions (command of the smart editor widget) on the fc the user is inputting an ID field to copy over the 'SIC_ID' field into the user's ID field, based on an intersect between the two feature classes within approximately 10ft. For this to work, you will add the specific index of the map service (for example, http://...../mapserver/2, rather than http://.../mapserver)  to the web map, so that the widget can read the layer. method 3: See the Reviewer dashboard widget. https://doc.arcgis.com/en/web-appbuilder/create-apps/widget-reviewer-dashboard.htm I personally have not used this, but might be helpful. ... View more

If I understand you correctly, you want to have a parent table that is related to a child table, one to many. Then, the child table, related to a grandchild table, one to many. In other words, you have nested relationships. Based on this article, I think that the widgets should support your workflow:  See 'Related Data in ArcGIS' Blog post by Michael Kelly on geonet: o   https://community.esri.com/people/MKellyesri-ireland-ie-esridist/blog/2016/11/18/related-data-in-arcgis-online Try testing it in the wab widget. The related table should be visible under the 'Actions' heading> table icon (view related layers and tables) Click the table icon to see the first related table. Click the table icon again to see the second related table, if possible. My personal experience is to have a parent feature class that is related to a child table, one to many. Then creating attachments on the child table (which to me, is very similar to having a related grandchild to the child) This workflow works in wab smart editor widget. The exception is that I cannot drill down to see the attachment table in the widget, but that may be different for you since, yours is a regular table, not a table like the attachment table, which was auto-created by the geodatabase. ... View more

The easiest way I know how to do this is to make the relationship from a parent Global ID field, and a child GUID field in a one to many relationship. Doing this will autofill the child GUID field with the parent's Global Id. The smart editor widget should be set to only display, not edit, these fields. ·         See 'Related Data in ArcGIS' Blog post by Michael Kelly on geonet: o   https://community.esri.com/people/MKellyesri-ireland-ie-esridist/blog/2016/11/18/related-data-in-arcgis-online This is my workflow: Relationship Properties ·         Relate using 'have' as part of name. ·         Composite Relationship o   Once asset is removed from the parent fc, related inspections are also removed. §  Clients agreed that once an asset becomes abandoned, no need to keep inspection history about it ·         Origin FC to Destination table label: History ·         Destination table to Origin FC label: ssNameOfFC ·         select 'None' for the message direction. ·         1-M ·         No, I do not want to add attributes to this relationship class. ·         pk= GlobalID ·         FK= RELATEDGLOBALID     General Structure ·         FC ·         related to ·         Inspection History Table ·         via Parent Global ID, Global ID Data Type/Child RELATEDGLOBALID, Guid Data Type ·         relate to ·         Attachment table ·         via Parent Global ID, Global ID Data Type/Child RELATEDGLOBALID, Guid Data Type ... View more

I encountered this situation, and was able to find a solution: https://community.esri.com/thread/217206-how-to-use-smart-editor-to-require-user-to-populate-field How to use Smart Editor to require user to populate field? Question asked by Andres Castillo on Jul 2, 2018 How to use Smart Editor to require user to populate field? ... View more