Latest Contributions by RhettZufelt

Thanks Mike, This is very similar to the way I worked it out as well, except didn't wrap it in a function. Want to choose a different 'input table' based on the user logged into Pro.  Was hoping there was a one liner to do this instead of a line for each 'option'. R_ ... View more

Thanks, that would explain why I couldn't figure it out 🙂 R_ ... View more

Thanks for the suggestion, I had not tried that.  But no, it validates, but give the ever so informative 999999 error when you try to save. R_ ... View more

This should work for you and give you an idea of the syntax: if(isempty($feature.ApexPoleNumber)){ var poles = FeatureSetByName($datastore,"Pole_NumberingTest",['ApexPoleNumber'],false) var polenums = [] for (var n in poles){ var nn = Number(n.ApexPoleNumber) Push(polenums, nn) } var maxnum = Max(polenums) var newnum = maxnum + 1 return newnum } So, it checks if the current feature ID field is empty, loads the feature class with ApexPoleNumber field, iterates through them all and adds the existing values to a list, finds the max of the list, adds 1 to it, and returns the new number.  Some of the lines could be combined, but I think it's easier to read like this. I should point out that this will fail if there is not at least one feature in the featureclass with a number in it's ApexPoleNumber field. Also, this link on inserting code will make things a lot nicer and easier to see what is going on in the future. R_ ... View more

I do something similar, but my ID field is text as I want the ID's prefixed with text (TTA0001, TTA0002, etc.). if(isempty($feature.ID)){ var vals = FeatureSetByName($datastore,"StripingPoints",['ID'],false) var TTAvals = Filter(vals, "ID LIKE 'TTA0%'") //filter to only apply to specific features var numarray = [] for (var n in TTAvals){ var nn = Number(Replace(n.ID, 'TTA','')) Push(numarray, nn) } var maxnum = Max(numarray) var maxtext = Concatenate('TTA',(Text(maxnum + 1, '00000'))) return maxtext } // example input for ID filed = TTA00001 Like I said, this if for text field, but should give you an idea of how to make it happen with numeric. First, check to make sure the ID field isn't already populated (unless you want to overwrite existing ID's), load the data layer, filter to matching features (not needed if you apply the same att rule to all feature in the feature class),  loop through all the features and strip of the 'TTA' and return a number (instead of text) that is pushed into the numarray. Then, find max value of the numarray, concatenate that back to text with formatting (again, not needed if text field), return the new, incremented number. R_ ... View more

Would be nice to be able to save them at all. "Locate configured features or records - In the Locate pane, you can configure layers or tables to search on specific fields. These settings are NOT saved with your project......" ... View more

Yes,  It should behave like any other Hosted Feature Service. R_ ... View more

you can select them with you mouse, copy/paste.  If you paste into Excel, will keep it in row and columns. R_ ... View more

Not sure if you can change this, but if your domain is sorted alphabetically, the "Starts With" values will appear at the top of the list. R_ ... View more

Good luck with that one.  It has been requested quite a bit, but I don't see any mention of progress towards it. As a workaround, you could calculate text fields with the format you want, but that is not very robust with dynamic data. R_ ... View more

How/where are you displaying the table? In Map Viewer, you can select the table, then the Fields option and change that on a per field basis:   R_ ... View more

Not sure what's going on then.  Thought in the past I had issues using '%V%' if there were no other characters before the 'V', but can't reproduce it.  Your query (modified slightly with my data) seems to be working as expected.  If LIKE won't select any of the  V's, maybe there is a character issue or something. As a test, you might try to edit a few of them manually and replace a few of the V's by typing over them and see if they get selected in case there is something weird with the characters. R_ I'm still on 10.6.1. ... View more