Select to view content in your preferred language

Repeat Always Creating Record

7158
29
Jump to solution
01-03-2018 08:16 AM
ShawnRoberts1
Occasional Contributor

I'm just experiencing a weird issue that hasn't occurred in the past. Normally, for a repeat a record would only be created in some data was actually entered into the repeat( or an image added). However recently I've experienced an issue with any new surveys that no matter what a record will be created in a  repeat, no matter is it is completely blank or no image has been attached ect. Has anyone ever experienced anything like this before?

I created a really simple survey to test with two lines and this still seems the be happening. The main table (0 index) will be created as expected, then no matter if there is no image or not a record will be created in the related table. 

This is causing alot of headaches as I run scripts/workflows against the survey results and it keeps returning blank records (or in this case records with no attachments).

Any advice/guidance would be greatly appreciated.

Thanks, 

Shawn

0 Kudos
29 Replies
by Anonymous User
Not applicable

Hi Suddha,

Thanks, I got the file. You can also attach it via the GeoNet post by using the "advanced editor" option which is available when you reply when you open the entire post (not just from Inbox).

The reason a new record is being created in the related table (repeat) even thought you are using minimal appearance with no calculations, is due to the geopoint question. This is a known issue with geopoint questions in repeats, and I have added your comments to the issue. We hope to address this in a future release.

Phil.

0 Kudos
SuddhaGraves
New Contributor III

Thank you Phil!

ShanaGail1
Occasional Contributor

Hi Philip,
 Has there been a decision on a release date to fix the problem?  I set the repeat count based on a previous question, so we're stuck with blank rows for awhile.  In our scenario, a QA/QC Auditor can be inspecting either our own company crew or a contract crew on a construction job.  There are separate repeats ( 2 tables), so if we are inspecting 3 members of a contract crew, 3 blank rows in the company crew table are inserted.  We have an FME that will clean up the tables periodically, but it's a hassle.

Thanks,

Shana

0 Kudos
by Anonymous User
Not applicable

Hi Shana,

At this stage we do not have a planned release date for this fix. Will update you when it is resolved.

Phil.

ShanaGail1
Occasional Contributor

Thanks Phil!

0 Kudos
JohnathanHasthorpe
Esri Regular Contributor

This bug will be fixed in 3.1.

ShanaGail1
Occasional Contributor

Thanks for the update Johnathan .

PaulPetersen1
Occasional Contributor

@JohnathanHasthorpe @Anonymous User ,

I am using the current version of S123 (3.15), and this issue is driving me absolutely bonkers. Basically I've got a nested repeat within a repeat. I've got both the repeat and the nested repeat appearance set to Minimal, yet I get blank records created for this nested repeat every time I submit the form, even though I don't manually create the record by hitting the "+" button.

I don't have a repeat_count on either, but I do have calculations inside the nest repeat that reference the other repeat and also the parent. I've figured out through this thread plus some trial-and-error that the calculations are causing this unwanted behavior.

This thread is now 4 years old, but I'm wondering if there are any workarounds that would allow me to keep calculations in the my nested repeat and honor the Minimal appearance (ie, not create new records automatically upon submittal).

Thanks,

0 Kudos
dannigart
New Contributor II

I am also still wondering if there is a solution for this issue. Setting appearance of a repeat to minimal, or setting relevance of a repeat does not prevent blank rows from being created. Maybe there is a solution by now?!

0 Kudos
PaulPetersen1
Occasional Contributor

I'm afraid not. I worked with Esri support on this a couple months ago, and never got it resolved. They have submitted it as an "enhancement" request.

0 Kudos