Help creating a SQL database trigger for automating IDs for Collector.

NDFAdmin — Fri, 22 Nov 2019 01:10:52 GMT

Hello,

I am attempting to create a database trigger that concatenates values from two different fields into an already existent empty field (or is set to null) for a newly inserted row. I'm not a DBA and I have no issue creating this type of statement in Python, but I am missing the mark in SQL. I am using an enterprise geodatabase as the backend for Collector and have used attribute rules or Python to accomplish this in the past (at a different job), but we really need this function to occur on submit and currently only have ArcGIS Server 10.5 and can't publish a feature service using ArcGIS Pro.

The basic structure would be something like:

IF [ProjectIDColumn] IS NULL

THEN CONCATENATE (FieldOne + "-" + FieldTwo);

Any help would be greatly appreciated, thanks!

topic Help creating a SQL database trigger for automating IDs for Collector. in ArcGIS Collector Questions

Help creating a SQL database trigger for automating IDs for Collector.