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

IF Statement Priority Dependency Cycle

Adam_Bourque

Hello all,

Is it possible to use two different fields to generate values and have one field be priority / overwrite?

I am using an IF statement that looks at two previous fields to determine if water service line needs replaced based on bothsidestatus. That part works fine; however, I am wanting the "length(${scheddate}>0 Scheduled Replacement" to overwrite / or take priority over the bothsidestatus.

In better words, if the user schedules a replacement date in either utility or customer side with this schedule date field, I want the calculation to show the status as "Scheduled Replacement" rather than "Still Identifying Material Types / Needs Replaced / Doesn't Need Replaced" options. I tried to move the string-length option to the front of the calculation but kept getting the error "If statement needs 3 conditions, and you only have 1 condition".

Calculation:

if(${bothsidesstatus}='Unknown' , "Still Identifying Material Types", if(${bothsidesstatus}='Non-Lead' , "Doesn't Need Replacement", if(${bothsidesstatus}='Galvanized Requiring Replacement', "Needs Replacement", if(${bothsidesstatus}='Lead', "Needs Replacement", if(string-length(${custscheddate}>0 or if(string-length(${scheddate}>0, "Scheduled Replacement", "Still Identifying Material Types"))))))))

Thank you, if you need a copy of my survey or anything else please let me know

Encuentra más publicaciones etiquetadas con

Accepted answers

dougbrowning

You have some syntax errors still here. Its string-length() you are missing the ) Lets try

if(string-length(${custscheddate}) > 0 or string-length(${scheddate}) > 0, "Scheduled Replacement", if(${bothsidesstatus}='Unknown' , "Still Identifying Material Types", if(${bothsidesstatus}='Non-Lead' , "Doesn't Need Replacement", if(${bothsidesstatus}='Galvanized Requiring Replacement', "Needs Replacement", if(${bothsidesstatus}='Lead', "Needs Replacement", "Still Identifying Material Types")))))

All comments

Adam_Bourque

Last question in regards to this, is it possible to have the calculation overwrite / update without having to use the refresh button? I am using "autocomplete" but I am opening this survey via inbox method which I think might have something to do with it. It's not the end of the world to have to click the refresh button occasionally, but was curious if you knew any fixes to this.

Adam_Bourque

Thank you so much @DougBrowning I thought about the syntax / putting parenthesis bracket, but have been spoiled at always putting them at the very end. This opens up more avenues for surveys, 😁

dougbrowning

You have some syntax errors still here. Its string-length() you are missing the ) Lets try

Adam_Bourque

Awesome @DougBrowning you definitely solved that part of my situation, true MVP; however, the code still prioritizes the Unknown - Still identifying materials option because it is first in the equation. When I try to put the string length cust schedule date option first like here I still get the "Only 1 provided of 3 statements S123". If I put it last in the order like my existing code with the fixed code, still does not "overwrite" prioritize which I guess makes sense given the order. Not sure why it is still being picky at the code below, any additional work around? Maybe I will need to implement a repeat field or something if this doesn't work.

Thank you for spending the time to help us out here at the forums.

if(string-length(${custscheddate}>0 or string-length(${scheddate}>0, "Scheduled Replacement", if(${bothsidesstatus}='Unknown' , "Still Identifying Material Types", if(${bothsidesstatus}='Non-Lead' , "Doesn't Need Replacement", if(${bothsidesstatus}='Galvanized Requiring Replacement', "Needs Replacement", if(${bothsidesstatus}='Lead', "Needs Replacement", "Still Identifying Material Types")))))))

dougbrowning

This part here you would not have two if statements the or will be enough.

if(string-length(${custscheddate}>0 or if(string-length(${scheddate}>0,

Change to

if(string-length(${custscheddate}>0 or string-length(${scheddate}>0,

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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