I want to use either Replicas or Versions on my data collected by Survey123 to prevent any updates on my Main Database and to put a quality control layer first and check coming data before entering Main DB.
I am using Suvey123 connect and field app 3.6.143.
Data is on SQL Server DB.
I use an existing published service fields and build the survey using those fields in the excel sheet to build the survey.
I recognized that [ ApplyeditswithGlobalID ] must be true and to do this data cannot be Versioned.
My Question is there any way to make a middle layer so no data enter the Main DB direct from the field app.
Any help is greatly appreciated.Thanks.