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; } } }

I tried using a formula in the repeat count column, and it generates circular references. How I can fix it?

AFSIG

I have a form where I want to apply a restriction to a question within a repeat group (begin repeat). I'm trying to set it so that when 'motivo_encuesta' is answered with 'Monitoreo', the repeat at the tree level is exactly 30. If the answer is different, there should be no restriction on the number of entries. I'm using this formula: if(${motivo_encuesta} = 'Monitoreo', 30, .). However, for some reason, this is generating a circular reference, and I don't understand why, as I've reviewed the entire file.

I hope someone can help me!

Relevamiento Sanidad.xlsx

MatthewParkman_1-1736863925608.png

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

Announcements

Accepted answers

JA7

You might want to try using a constraint on a count of the repeats instead of the repeat count field. That way you can make that count field relevant only when Monitoreo is selected.

Calculation: count(${fecha_relevo_arbol})

Constraint: ${field}=30

Relevant: ${motivo_encuesta}='Monitoreo'

dougbrowning

I am not sure you can. And I would not as changing the repeat count on the fly tends to have issues.

What I do is instead have a field that does count(${somerepeatfield}) and then put a constraint on that. This constraint can then be a formula like you want. It is much more reliable. Note it will let them add one too many then they have to delete that last one. I added a note red warning for this and our users are ok with it.

Hope that helps

All comments

JA7

Try this instead:

if(${motivo_encuesta} = 'Monitoreo', 30, '')

The dot represents the current field, so your statement was saying, 'for this field, if this other field is Monitoreo, add a repeat count of 30, otherwise use a repeat count of this exact field'.

The formula I provided instead goes, 'for this field, if this other field is Monitoreo, add a repeat count of 30, otherwise don't set a repeat count'.

AFSIG

Hi Jen,

Thank you for the formula you provided; it worked well for the "Monitoreo" option. However, I'm now having an issue when I select a different option from "Monitoreo." The field appears empty, and it won't let me add any records. I also tried using null, but that leaves the field empty as well. How can I make it so that when I select something other than "Monitoreo," I can add as many records as I want without any restriction?

I really appreciate your help!

JA7

You might want to try using a constraint on a count of the repeats instead of the repeat count field. That way you can make that count field relevant only when Monitoreo is selected.

Calculation: count(${fecha_relevo_arbol})

Constraint: ${field}=30

Relevant: ${motivo_encuesta}='Monitoreo'

dougbrowning

I am not sure you can. And I would not as changing the repeat count on the fly tends to have issues.

Hope that helps

AFSIG

Hello Doug,

Thank you for your response.

I was researching the Esri documentation, and as you said, I can't apply a restriction for one condition or another in the repeat count column. So, I followed your advice and created the restriction in another field. I really appreciate you taking the time to look into this case and give me a hand.

AFSIG

Hi Jen,

Thank you so much for your response. You were very kind, and I truly appreciate you taking the time to review and answer my question.

Připojte se ke konverzaci

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.