nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Blank rows in 'hidden' repeat

ColinCampbell

I have a survey with a repeat in it that I've published from Connect but is being used as a web form. The repeat is optional and is triggered by people selecting a particular value on the main record. It is entirely hidden until that value is selected and this is done using a relevant statement in the 'begin repeat'.

This all looks great and works well in the web form, except for one thing. For records where the required value to unhide the repeat isn't entered a blank record in the repeat is still created.

I've seen some posts suggesting this is expected behaviour in slightly similar circumstances but I wondered if it was also the case here - or whether there was a way to stop the blank records from being created?

Najděte více příspěvků označených jako

Accepted answers

All comments

SFM_TravisBott

I'll reply to my own post here in case anyone comes looking since I found a workaround that seems to function in 3.20.63.

In my case I have nested photopoint repeat. There's a geopoint question, an image question, and a few others. The repeat has a relevant condition on a proceeding question, 'NeedPhotos' (${NeedPhotos} = 'Yes'). The NeedPhotos question is itself subject to a calculation...if a previous question (PositiveImpact_YN) is set to 'Yes' then the NeedPhotos question is automatically set to 'Yes' and photos are enforced.

I noticed this behavior: If in the course of the survey PositiveImpact_YN is set to 'No', the photo repeat does not appear (desired behavior) but it sends a ghost record (undesirable behavior). However, if I set PostiveImpact_YN to 'Yes' (photo repeat appear), then back to 'No' (photo repeat disappears), then it doesn't submit a ghost record. It's like the survey needed some positive affirmation do the right thing, and it fires appropriately and strips out the photo.

For my case I changed the NeedPhotos calculation and added a calculation in the 'Visible' column...so the user can't see it but behind the scene the 'NeedPhotos' gets defaulted to yes, but is invisible, and then the above chains of calculations from PositieImpact_YN will push it back to 'No', and the ghost record gets killed.

SFM_TravisBott

Holy moley it's be six years and this still isn't resolved:

https://support.esri.com/en-us/bug/if-a-relevant-field-is-configured-on-a-repeat-to-only-s-bug-000123943

I sure hope somebody can suggest a workaround.

SébastienLétourneau

Any updates for this bug? Reported since 2018 and very annoying.

newwollyka

Same here. I have a household listing inside a unit listing. Empty households records are being created even if the unit is inhabitant and it is causing inconsistencies and headaches!

dougbrowning

Also checking on update since have been 20 months now. We now have thousands of them. Getting harder to work around.

Thanks

HNoakes

I am also seeing this with no geopoint in the repeat section. I only have two text fields.

Is there any update on the Bug?

BrunoGomes_de_Souza

Hey James, I have the same problem.

But some repeats have no spatial information and occurs the same as described.

ColinCampbell

Hi James,

That's really helpful to know. Thanks again for looking into it.

JamesTedrick

Hi Colin,

I'm able to reproduce the behavior you describe with your survey. It appears that we have an existing BUG for this behavior, BUG-000123943. I did a little more testing and it appears related to the presence of the geopoint question in the repeat.

ColinCampbell

Hi James,

The repeat becomes relevant if the user selects one of two values in a single select (I've attached the .xlsx for the survey and you can see the live form here). The question 'Did you observe willow tit or marsh tit during your visit?' is the one that triggers the repeat (when you select 'Yes').

Just in case it helps, I've also attached a picture to show how the blank rows are appearing in the repeat.

Many thanks for your help looking into this.

Colin

WT Survey.xlsx

JamesTedrick

Hi Colin,

I am not seeing the behavior you are describing with a simple form with repeat that is relevant based on a question. What types of questions are present in the repeat section?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.