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

Survey123 If Then but no Else

JulienCHARBONNAUD

Hello

In my Survey123 form, I want to use the If expression in the Calculation column. By default, in the formula if (condition, a, b), you need a and b, in my case I will not want any action if the condition is not fulfilled.

Example if (format-date ($ {DateMeasure}, '% W') = 27, $ {Biom}, NO ACTION WISHES)

because it means that my cell is already informed and I do not want to overwrite its content

If anyone has a trick

Thank you very much

(Google translation)

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

JamesTedrick

Hi Julien,

Unfortunately, there is not a method to preserve the existing data as part of an if() calculation; the else part is required.

JulienCHARBONNAUD

Hi James

Thank you for this quick response

Pity

Maybe you have another idea?

Explanation: when typing with a repeat function, I test the date and I store a value in the main database with a variable that has the number of week (Week 37 for example) when re-entering the value can be assigned to week 40 for example but it does not do that the value of week 37 disappear.

Thank you

Julien

Suivi Croissance 2019-2020.xlsx

dougbrowning

You could try a second hidden var. Use once() if you need to. Then your If could say new week or load from hidden field.

JulienCHARBONNAUD

Hi Doug

I have a little research on this side, but I did not understand how works once() and I did not find much help on the subject
If you want to give me a hand it is with pleasure
thank a lot

Julien

marvin.davis

It would seem to me you need multiple fields to get exactly what you desire. Make a date field that is hidden from the user, then have a read-only field and have an if() statement that will populate the week number you need. This way it's only sourcing the original date, not showing it unless you state it in the if() statement.

NicholasDay

Hi Julien, the calculation I use is for a text field, where the users enter responses throughout the survey and then all the answers are concatenated into a single field for viewing and ease of use on a Feature Report. Here is an example of the calculation.

if(${L1Note}=0,””,concat(“L1: "+${L1Note})+”\n”)+if(${L2Note}=0,””,concat(“L2: "+${L2Note})+”\n”)

In this instance, 0 represents an empty text field. The "" is the DO NOTHING part of the code. So if the remark field has no entry, enter nothing, else enter the note tag, value, and a carriage return. This is repeated as needed.

FMGEngineering

Why is the false condition required? In other scripting I've used, the false condition isn't always a requirement. I think even Arcade scripting allows you to run an if statement without providing a false condition in ArcGIS Pro for stuff like labeling and/or attribute calculations.

For my form, I ask the user what type of a duct are you looking at. If it is vacant, I know there isn't an innerduct. But other options may or may not have have innerducts. This seems pretty significant. I thought if statements without false returns were rather common?

RobertAnderson3

I've definitely found myself encountering this more. Especially in repeats.

For mine it may be an activity defaulting the asset type, but it may not always be true, having the false argument of '' clears the default causing them to need to make a selection, or it changes as they scroll through. Stuff like that.

Is there really still not a regular option for no else @JamesTedrick ?

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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