topic Re: Survey123 Calculation - Multiple If Parameters in ArcGIS Survey123 Questions

Survey123 Calculation - Multiple If Parameters

dgray — Mon, 22 Mar 2021 23:35:12 GMT

Hi,

I was wondering how to deal with multiple if conditions in a Survey123 calculation. I know you can embed an if within in if but I'm not sure if this can handle all the if circumstances. Basically, in my case, depending on which region you pick from a Select One list, a different formula will be used to crunch the same value parameter. I have four different formulas, and one of them has two if's within it, so a total of five possible formulas used to crunch the same parameter.

How could I structure this?

Re: Survey123 Calculation - Multiple If Parameters

Jim-Moore — Tue, 23 Mar 2021 01:43:16 GMT

Hi @dgray it sounds like you want to nest five if() statements in one expression, is that right? That's definitely doable. As demonstrated in this reply, you can nest multiple if() statements, remembering to ensure each if() contains three arguments. The following example tests five conditions:

if(condition, value if true, if(condition, value if true, if(condition, value if true, if(condition, value if true, if(condition, value if true, value if false)))))

It's often easier to construct each if() statement separately first and check that each one works, before merging them into one expression.

Hope this helps. Best, Jim

Re: Survey123 Calculation - Multiple If Parameters

DougBrowning — Tue, 23 Mar 2021 15:05:14 GMT

The other way is to have 4 calculate fields that always do all 4 calcs. Then use the if to pick out which one to use. Easier to write.

If say the multiplier changes then I use pulldata for that. I do a lookup to get the value then use that to say multiply.

Hope that helps

Re: Survey123 Calculation - Multiple If Parameters

dgray — Tue, 23 Mar 2021 16:09:54 GMT

Great, both are useful pieces of information. Thanks!

Re: Survey123 Calculation - Multiple If Parameters

KellyArmstrong — Thu, 06 May 2021 16:41:53 GMT

How would you deal with dates? If there is a date selected/entered....if there isn't a date selected/entered.

If there is a date entered in field A, I want field B to be "Completed". If there isn't a date entered in field A, I want field B to be "Open"?

Re: Survey123 Calculation - Multiple If Parameters

DougBrowning — Thu, 06 May 2021 18:13:48 GMT

if(${datefield} = "", "Open", "Completed")