topic Re: Is it possible to create condition based on already existing records ? in ArcGIS Survey123 Questions

Is it possible to create condition based on already existing records ?

אלכסנדרהסביצקי — Tue, 23 Jul 2019 11:10:37 GMT

the question is:

in my table I got report id and cause for the report

can I deny insert of a record by checking if there's already record with the same 2 parameters ?

Re: Is it possible to create condition based on already existing records ?

Anonymous User — Wed, 24 Jul 2019 01:51:10 GMT

Hi there,

No, you can not check values from other existing records in the same feature layer. You can only check existing records in a repeat table or layer in the same feature service, if you have added those related tables to your survey as a repeat. Then you can use calculation to check if those values have been added before and use constraints or relevant expressions to hide or show to the user, or warm them with a message.

The only other way you could query the existing records that are not part of the current survey record you are adding or editing, would be to use a custom javascript function. Please refer to the Early Adopter Community for more information on javascript function support.

Phil.

Re: Is it possible to create condition based on already existing records ?

אלכסנדרהסביצקי — Wed, 24 Jul 2019 06:10:45 GMT

Thanks for the reply Phil, the records I want to compare with the same records that the survey produce, so is it possible to prevent unwanted duplicates without javascript ?

Re: Is it possible to create condition based on already existing records ?

Anonymous User — Thu, 25 Jul 2019 01:34:12 GMT

Hi, no it is not possible if they are other features in the same feature layer, only if they are repeat records in the same parent layer, and all are loaded as part of editing via the Inbox and available in that survey record.

Phil.