Arcade Pop-Up. First two functions work, while third fails.
Accepted Solutions
If I'm understanding this correctly, you have a list of 30 values that should be removed?
While I can't be sure exactly why your code isn't working, you should know that the Replace function returns a string. Without assigning the results of that function to a variable, Arcade is going to treat that as having an implicit return. Meaning, it will read that function as providing the output of your full expression. This applies specifically when it's the final line of your expression.
In any case, those multiple Replace functions won't be doing what you think they will, and it's not the best approach.
Try something like this:
- Establish a list of values to exclude
- Check if your field is empty
- If it is not empty, check if it's in the "excluded" list
- If it's not in that list, assemble the string and return it.
This has the benefit of not needing to do a series of find/replace functions when the field is empty. If the field is empty, or it's in the exclude list, the expression simply stops there and doesn't return anything. Here's the code:
// List of items to exclude
var excluded = [
'a',
'list',
'of',
'values',
'to',
'exclude'
]
var asbuilt = $feature.AsBuiltFileName
var urlstart = 'https://asbuilts.ci.missoula.mt.us/water/'
// Check if not empty
if(!IsEmpty(asbuilt)){
// Check if excluded
if(!Includes(excluded, asbuilt)){
return `${urlstart + asbuilt}.pdf`
}
}
Here's me testing it against a couple of static values and a null value.
If I'm understanding this correctly, you have a list of 30 values that should be removed?
While I can't be sure exactly why your code isn't working, you should know that the Replace function returns a string. Without assigning the results of that function to a variable, Arcade is going to treat that as having an implicit return. Meaning, it will read that function as providing the output of your full expression. This applies specifically when it's the final line of your expression.
In any case, those multiple Replace functions won't be doing what you think they will, and it's not the best approach.
Try something like this:
- Establish a list of values to exclude
- Check if your field is empty
- If it is not empty, check if it's in the "excluded" list
- If it's not in that list, assemble the string and return it.
This has the benefit of not needing to do a series of find/replace functions when the field is empty. If the field is empty, or it's in the exclude list, the expression simply stops there and doesn't return anything. Here's the code:
// List of items to exclude
var excluded = [
'a',
'list',
'of',
'values',
'to',
'exclude'
]
var asbuilt = $feature.AsBuiltFileName
var urlstart = 'https://asbuilts.ci.missoula.mt.us/water/'
// Check if not empty
if(!IsEmpty(asbuilt)){
// Check if excluded
if(!Includes(excluded, asbuilt)){
return `${urlstart + asbuilt}.pdf`
}
}
Here's me testing it against a couple of static values and a null value.
Josh want another one?... When attempting to populate a related record within a pop-up, in this case sewer ditchcard hyperlinks I know that I'm missing a section of code which specifies the field within the related table to populate from.
It might be worth noting FeatureSetByRelationshipName function is for one reason or another not available so I'm calling the table from $map.
1. var ServiceType = $feature;
2. if (Find('Sanitary', ServiceType, 0) > 0);
3. var Hyperlink = 'https://asbuilts.ci.missoula.mt.us/scards/' + FeatureSetByName($map,"Ditch Card Links - ConnectionTEST - Connection Data Table") MISSING FIELD FUNCTION + '.pdf'
4. return Hyperlink
