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

Een nieuw kenmerk maken op basis van een lijst met velden met JA- of NEE-vermeldingen via de expressie-editor voor pop-ups

Anonymous User

Hallo allemaal,

Ik heb een webkaart op ArcGIS Online die gegevens ophaalt uit een REST-service. De REST-service toont actieve boerenmarkten in mijn staat en vermeldt op een erg omslachtige manier in welke maanden elke markt open is. Op de bijgevoegde schermafbeelding is te zien dat voor één markt in het pop-upvenster 12 keer een waarde JA of NEE wordt weergegeven. Ik wil al deze JA- en NEE-waarden samenvoegen tot een nieuw kenmerk waarin eenvoudig staat in welke maanden de markt open is.

Dit is de pop-up voor deze markt, zoals die wordt weergegeven in een dashboard. Dat wordt de uiteindelijke toepassing van deze kaart.

Ik wil alleen dat de pop-up voor elke markt waarop je klikt iets weergeeft als: "Open in: juni, juli, augustus, september".

Ik moet erbij vermelden dat ik via mijn organisatie geen toegang heb om wijzigingen aan te brengen in de REST-service(s). Daarom heb ik een tijdelijke oplossing nodig.

Misschien gebruik ik het woord "kenmerk" niet goed als oplossing voor mijn probleem, dus corrigeer me gerust. Mijn idee voor een tijdelijke oplossing was om de functies feature of featureset in de expressie-editor te gebruiken en zo een nieuw kenmerk te maken dat verwijst naar de bestaande 12 kolommen met maandgegevens voor alle ongeveer 360 markten. Ik probeer al een paar dagen te leren hoe ik een Arcade-expressie schrijf die dit doet, maar al die verschillende functies maken me duizelig en ik heb hiervoor nog nooit iets in een programmeertaal geprobeerd te coderen. Ik loop nog vast op het begrijpen van de syntaxis, haha!

@XanderBakker Ik hoop dat je het niet erg vindt dat ik je heb getagd! Ik zag dat je hier een vergelijkbare oplossing voorstelde. Ik dacht dat jij misschien de aangewezen persoon was om hulp te vragen!

Vind meer berichten getagd met

Content Management

Data and services

Arcade

Accepted answers

XanderBakker

Hi @Anonymous User ,

I think you could use something like this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// start with an empty result string
var result = "";

// loop through field names in dct
for (var fldname in dct) {
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = "Open in: " + dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;	‍
‍

XanderBakker

Hi @Anonymous User ,

A simple fix could be this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// simple fix, use a list of field names with the right order
var lst = ["OpenJan", "OpenFeb", "OpenMar", "OpenApr", 
		   "OpenMay", "OpenJun", "OpenJul", "OpenAug",
		   "OpenSep", "OpenOct", "OpenNov", "OpenDec"];

// start with an empty result string
var result = "OK";

// start with an empty result string
var result = "";

// loop through the list of field names
for (var i in lst) {
    var fldname = lst[i];
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;

All comments

XanderBakker

Hi @Anonymous User ,

I think you could use something like this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// start with an empty result string
var result = "";

// loop through field names in dct
for (var fldname in dct) {
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = "Open in: " + dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;	‍
‍

Anonymous User

You're a wizard! It worked perfectly besides listing a couple months in the wrong order, but I can manage fixing that myself I think.

One more piece of help please! It lists the months in alphabetical order instead of by the order of months in a year. I try and type some solutions to this into your code but I can't seem to do anything other than break it. What to do? @XanderBakker

XanderBakker

Hi @Anonymous User ,

Glad to hear that it helped. If you run into problems with making the required changes just let me know.

About your questions:

For example, why use this method instead of creating an entire new feature?
- I wonder how you would create a new feature if you are not the owner of the data. You could with a notebook access the data, transform it the way you need it, and write a local feature layer and use that. This is more complex to implement.
What was the purpose of starting the logic part of the expression with "an empty results string?"
- Any variable you want to assign a value needs to be initialized. This is done using "var NameOfVariable = InitialValue". Perhaps this could be omitted and line 21 could start with "var ". However, sometimes this could create an error when compiling the code, so I prefer to initialize the variable before the loop.
Finally, what exactly do the "{" and "}" symbols do in this expression?
- The "{" and "}" are used to contain logic that needs to be executed. It also helps the readability of the code. To learn more about Arcade you could follow the learn path: https://learn.arcgis.com/en/paths/try-arcade/

Anonymous User

Thanks for your explanations. I will be sure to explore the resources you linked to asap.

One more piece of help please! It lists the months in alphabetical order instead of by the order of months in a year. What to do? @XanderBakker

XanderBakker

Hi @Anonymous User ,

Can you share the expression you have now?

XanderBakker

Hi @Anonymous User ,

A simple fix could be this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// simple fix, use a list of field names with the right order
var lst = ["OpenJan", "OpenFeb", "OpenMar", "OpenApr", 
		   "OpenMay", "OpenJun", "OpenJul", "OpenAug",
		   "OpenSep", "OpenOct", "OpenNov", "OpenDec"];

// start with an empty result string
var result = "OK";

// start with an empty result string
var result = "";

// loop through the list of field names
for (var i in lst) {
    var fldname = lst[i];
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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