Hi! I'm using an existing feature service on our ArcGIS Server pointing to data in Oracle - one spatial layer and two related tables for repeat questions. The number of repeat questions are set using the number entered from a previous question. I.e., a user answers there were 2 persons involved. Then the repeat question, using repeat_count, will open 2 repeats to fill in name and other details.
The repeat_count variable creates a calculated field in survey123 schema that was not present in our database. Image: Survey123_Schema_Repeat_Count_MixedCase.PNG.
So we created the field forcing it mixed case to match. Our published feature service shows the fields in mixed case. Image: Feature_Service_Repeat_Count_MixedCase.PNG
Trouble is, the survey web form is attempting to submit the record into a field in all caps. We can see this in the AGS server log. Image: ArcGIS_Server_Log_Repeat_Count_ALLCAPS.PNG.
How do I edit the xlsform's _count field so that it is all caps? Or is there a better way to utilize repeat_count in existing feature services to build surveys? Is the calculated field necessary and can I work around it?
An update to share. I reached out to Esri support for some guidance - Esri Case #03164448. This is a known issue and there are enhancement requests to address it. The following is a summary of our discussion:
After our call, I found the two following logged enhancements:
It would appear that other users have also run into this mismatch issue with Oracle databases where all field names are in uppercase but the field generated by Survey123 are in lowercase. So for now, I think I can't use repeat_count unless someone has a workaround. 🙏 @IsmaelChivite, am I correct?