topic SQL Triggers on Feature Classes for Survey123 in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/806909#M12328 <HTML><HEAD></HEAD><BODY><P>I created the trigger to access information from different tables and update in the feature class ( enabled with Attachments)&nbsp; and sending email notifications in trigger itself. when i try to insert/update records from SQL Server and ArcMAP and ArcGIS Pro . it is working as expected. But when i try to insert/update records from Feature Service or Survey 123 app . It is giving errors . if we keep insert trigger , it is working as expected. if we try to append UPDATE trigger to it. it is throwing error. my obeservation is whenever inserting records using REST Feature service , The update trigger is also firing. Why ? How to overcome with this issue ? The feature class is not versioned.</P></BODY></HTML> Wed, 20 Nov 2019 22:21:11 GMT vijaybadugu 2019-11-20T22:21:11Z SQL Triggers on Feature Classes for Survey123 https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/806909#M12328 <HTML><HEAD></HEAD><BODY><P>I created the trigger to access information from different tables and update in the feature class ( enabled with Attachments)&nbsp; and sending email notifications in trigger itself. when i try to insert/update records from SQL Server and ArcMAP and ArcGIS Pro . it is working as expected. But when i try to insert/update records from Feature Service or Survey 123 app . It is giving errors . if we keep insert trigger , it is working as expected. if we try to append UPDATE trigger to it. it is throwing error. my obeservation is whenever inserting records using REST Feature service , The update trigger is also firing. Why ? How to overcome with this issue ? The feature class is not versioned.</P></BODY></HTML> Wed, 20 Nov 2019 22:21:11 GMT https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/806909#M12328 vijaybadugu 2019-11-20T22:21:11Z Re: SQL Triggers on Feature Classes for Survey123 https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/806910#M12329 <HTML><HEAD></HEAD><BODY><P>Hi. It seems like this question is more appropiate for the <A href="https://community.esri.com/space/2100">ArcGIS Enterprise</A>‌ GeoNet group. Survey123 is&nbsp; using a feature service to add a record. Understanding why the feature service is not adding a record is key.</P></BODY></HTML> Wed, 20 Nov 2019 23:09:23 GMT https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/806910#M12329 IsmaelChivite 2019-11-20T23:09:23Z Re: SQL Triggers on Feature Classes for Survey123 https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/1137223#M39998 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/386769">@vijaybadugu</a>&nbsp; &nbsp;Did you every get an update trigger to work on an archived table in sql?</P> Wed, 26 Jan 2022 01:00:03 GMT https://community.esri.com/t5/arcgis-survey123-questions/sql-triggers-on-feature-classes-for-survey123/m-p/1137223#M39998 TL2 2022-01-26T01:00:03Z