Arcade: How do I find the first empty field?

neomapper — Sun, 29 May 2022 13:15:21 GMT

How do I get the variable loopResults to find the first empty field and return it back to the stages variable for id:0, labeled Engineering? When I load the script, loopResults always returns project_designed if it's not empty

var Project_Design = Date($datapoint["Project_Designed"]) var PA_Sent = Date($datapoint["PA_Sent"]) var PA_Recvd = Date($datapoint["PA_Recvd"]) var loopResults = When(!IsEmpty(Project_Design), Project_Design, !IsEmpty(PA_Sent), PA_Sent, !IsEmpty(PA_Recvd), PA_Recvd,'') var stages = [ { id: 0, label: "Engineering", completionDate: loopResults, threshold: 60 }, { id: 1, label: "CSR", completionDate: $datapoint["App_to_Processing"], threshold: 60 },{ id: 2, label: "Operations", completionDate: $datapoint["To_Operations"], threshold: 5*60 },{ id: 3, label: "Construction", completionDate: $datapoint["To_Construction"], threshold: 22*60 },{ id: 4, label: "Done", completionDate: $datapoint["PA_Recvd"], threshold: null } ];

Re: Arcade: How do I find the first empty field?

JohannesLindner — Mon, 30 May 2022 06:56:55 GMT

How do I get the variable loopResults to find the first empty field

You're currently looking for !IsEmpty(), so it returns the value of the first non-empty field. Remove the bangs:

var loopResults = When(IsEmpty(Project_Design), Project_Design, IsEmpty(PA_Sent), PA_Sent, IsEmpty(PA_Recvd), PA_Recvd, '')

topic Arcade: How do I find the first empty field? in ArcGIS Online Questions

Arcade: How do I find the first empty field?

Re: Arcade: How do I find the first empty field?