Latest Contributions by XanderBakker

Don't worry jborgion , this will probably happen again in the future. It has happend to me countless times and when I have errores in my expressions it is the first thing I look for.  ... View more

Hi Joe Borgione  and Karina Livingston , I guess you could use something like the expression below (this will only return a value when both attributes are not empty): if (!IsEmpty($feature.LOCATIONID)) { if (!IsEmpty($feature.EQUIPMENTID)) { return $feature.LOCATIONID + "-" + $feature.EQUIPMENTID; } } ‍‍‍‍‍ Some reasons why Joe's code did not work is: When using a variable it should always be declared: so line 1 should be var joinChar = "-" When using if the condition should always be inside brackets. For Karina's expression, it is important that you access the attributes using either $feature.FieldName or $feature["FieldName"]. It is not possible to use [FieldName] in Arcade. ... View more

Hi Michaila Musman , That was what I expected. In that case the geometry does not change, and you are interested in maintaining a history of when the trees were watered. We have implemented similar workflows for a client and ended up using a 1:n related table to store the history. When doing this it will affect the way you can interact with the data. It is a little harder to visualize data based on values stored in a related table.  ... View more

Hi Administrátor Jihlava , Thanks for clarifying that you need to have a continuous range of values. It is important to realice that your current Arcade expression will not do that. It will take the highest number and take the next number. If any intermediate value will be deleted this will remain a gap. To get the first available number is to use something like this (I did not test it so it probably will need some tweaking): // use any additional logic before this var stanoviska = OrderBy(FeatureSetByName($datastore,'gisdata_sde.gis.UUP_zavazna_stanoviska_p',['cislo'], true), 'cislo ASC'); var i = 1; // specify where the cislo code starts, I assumed 1 for (var f in stanoviska) { cislo = f.cislo; if (cislo > i ) { return i; } i++; } ‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi mmusman_CaseyTrees ,  I am glad it works. Could you mark the post that answered your question as the correct answer? Thanks! ... View more

Hi mmusman_CaseyTrees , In you want to maintain the history of the edits, you might want to consider using a related table (assuming that the geometry does not change). This way you would be able to calculate the number of edits using a simple Arcade expression o the related records of a feature. As you have noticed when you have editor tracking enabled on the service, you will only have information about the create date and user and the last edit, but none about the intermediate edits. In Enterprise you would be able to use an attribute rule that records a record of what change has been done by what person and at what moment in time. This is not currently available in AGOL.  Maybe you can explain a little more about what type of data you have and why multiple fieldworkers are changing the data. This might provide some insight to your specific use case and could help to detect other alternatives. ... View more

Hi valerie.squire_slcgov ,  If it is a single URL you could obtain the URL in an Arcade expression and use a custom HTML configuration of the pop-up to create the URL link with the text that you want.  ... View more

Hi Jana Košábková , In this specific case I would recommend to contact Esri Support to have them check what is happening. I have not seen this behavior before, and it almost looks like two requests are made when using a WAB. I am also wondering why you don't make use of a database sequence: Create Database Sequence—Data Management toolbox | Documentation  then you can use Arcade to get the next number from the sequence. In this link you can see how it is used in combination with the NextSequenceValue function Attribute rule script expression examples—Geodatabases | Documentation  ... View more

Hi Dan Patterson ,  So the language is kind of proprietary, although it leans heavily on a subset of JavaScript. It really lives in the ArcGIS ecosystem rather than just in the Pro ecosystem. I can imagine that not being able to use Python at the same places you can use Arcade limits the possibilities, but I understand that one of the reasons for introducing Arcade was being able to have something "light" yet powerful expression language that could be used across the platform no matter if you use it in desktop, web or inside mobile apps. There is still a long way to go to get there achieving the same support no matter what device or app you use, but that is where it is heading and from what I understand and Python would not have been the best way to achieve that. But this is my interpretation and not an official statement.  ... View more

Hi OakdaleGIS , Can you confirm that you used the exact same expression that I posted? If I look carefully at the result below, it would mean that the expression is executed only partially, since there should be a blank line between "RESIDENT" and ", MN". ... View more

Hi Kelly Armstrong , Thanks for sharing the link, but it seems that the server is not responding. Also thanks for confirming that the field is indeed string. The problem with spaces is that they are difficult to detect visually. If there is a space we could use Trim function to strip them from the field before testing if it is empty. That would change the expression like this: if (IsEmpty(Trim($feature["building_number"]))) { return ""; } else { return "Resident" + TextFormatting.NewLine + Concatenate([$feature["building_number"], $feature["street_name"], $feature["street_type"], $feature["street_direction"]], ' ') + TextFormatting.NewLine + $feature.city + ", " + $feature.state; }‍‍‍‍‍‍‍ If indeed there is a string this could resolve the issue. ... View more

Hi jborgion , He is using the same approach as I mentioned at the end of my initial answer (check for the count after using a filter), although his rule is properly formatted as a validation rule.   ... View more

Hi Joe Borgione ,  Thanks for the additional explanation on your use case. You are right, scrolling through a long list of street names is not very user-friendly. If you would have the area subdivided in areas, you could use contingent values to reduce the list of streets based on the area selected by the user.  ... View more