Is there a way with Web AppBuilder Smart Editor widget to check ig the value enterend in the field Project Number, already exists in a table called ProjectsActive.
In general how can I check if a value entered is correct? I see that if the field has domains they show as a list box.
Based on your question it seems you may be able to use the option to only allow for unique values in your field? Please would you be able to provide some screenshots and more details on what you are trying to do?
I am looking for a way to check if the project number entered in a field "ProjectNumber" when digitizing a feature, already exists. Projects are created in another platform (eBuilder) so we would like to know if there is a way to use a lookup table to verify if the value entered exists.
This lookup table could be imported to GIS or Portal.
Ideally we will can a web API service to check if the project number already exists in eBuilder.
Are you trying to make sure a job number will not be duplicated for a new job (in other words, only allow for unique values), or are you trying to find a way to use existing job number values to link other features to a project using the job number as a key (re-use the existing job number value for other features)?