Latest Contributions by DougBrowning

Ok thanks for the info. What about - Is it possible to access a {relationships/1/objectid} field in Arcade? These are simple check boxes to turn on in the web map but Collector is ignoring them. thanks ... View more

I missed this survey but for me I use Arcade in my web map to summarize related records. In my latest use I am using it for QA. Like out crew must do lines 1, 2, 3. var msg = "" var sql = "PlotKey = '" + $feature.PlotKey + "'"; var tbl = Filter(FeatureSetByName($map,"GAP"), sql); var txt = '' for (var f in OrderBy(tbl,"LineKey")) { txt = txt + Right(f.LineKey,1) + '-' } txt = Left(txt,Count(txt)-1) if (txt != '1-2-3') { msg = "\nLine Number Issue! Found: " + txt } var sql = "PlotKey = '" + $feature.PlotKey + "'"; var tbl = Filter(FeatureSetByName($map,"Plot Char"), sql); var tblCnt = count(tbl) if (tblCnt < 1) { msg = msg + "\n----No Plot Char form found!" } else if (tblCnt > 1) { msg = msg + "\n----More than 1 Plot Char form found!" } if (msg == '') { return 'Everything Looks good!' } else { return msg } ... View more

Oh I was doing it in the return statement. That is where I use my \n. I do this so that I have a return of '' it does not leave a blank like for no reason. Adding HTML is a bit of a pain. Whenever I go back in to edit the popup it changes back to just text and then wipes any custom HTML. Thanks ... View more

I tried using this trick to set the font color. But every single time I go back in to edit the Popup it changes back to not showing HTML and wipes my html tag changes. ... View more

Arcade says Invalid string when I try that. This is an Arcade popup not python. ... View more

Is it possible to access a {relationships/1/objectid} field in Arcade? Can I access other Arcade expressions? Like {expression/expr0} ? I would like to have a master check like If {expression/expr0} == 1 and {expression/expr1} == 1 and etc} Arcade will not let me use {} at all so how do i access these fields? Thanks ... View more

I do understand this post. ... View more

Yes I am using that version. Also tried the recent beta. Other stuff works just not FeatureSetByName. Also Relationship counting does not work {relationships/1/objectid} ... View more

I tried \n\t\t\t\t\t\t\a and got this a--!!! Line Number Issue! Found: 1-3 No space or bell. ... View more

Change it from a note to text for widthnote. Then use a calculation column of if(${widthcal}='','',${widthcal}). (So you can use calculation even if the type is not calculate.) Basically you prepopulate it but then let the user change it if they need to. Then make it required. That way if pulldata finds it - it uses it - else it is blank and then required will trip for the user if they try to skip it. ... View more

How can I do leading spaces? It keeps striping them out when using Arcade in a Pop up. This return "\n" + " Line Number Issue! Found: " + txt Does this - notice no spaces - I want to indent it. Ideas? Thanks ... View more

Our Users also hate the new large and centered Update Point button. We keep having users change a Attribute then tap Update Point - which then moves the point on us! It should really say Update Point Location or something like that. With Submit hidden way at the top right it seems to the user the only way to save. I would personally hide that Update Point Location button down at the bottom or something also. Changing a location should not be that easy. ... View more

Also tried using FeatureSetByName($map,"Name") but that did not work in the app either. Thanks ... View more

Same question. I switched mine to use $map so it theory it should work. But I just get blank. if ($feature.EvalStatus == "Eval") { var sql = "PlotKey = '" + $feature.PlotKey + "'"; var tbl = Filter(FeatureSetByName($map,"GAP"), sql); var txt = '' for (var f in OrderBy(tbl,"LineKey")) { txt = txt + Right(f.LineKey,1) + '-' } txt = Left(txt,Count(txt)-1) if (txt != '1-2-3') { return "\nLine Number Issue! Found: " + txt } else { return '' } } else { return '' } Thanks ... View more

Use an if statement. So one field does a pulldata. The next field does an if on that pulldata field to check if it found anything. So something like if(q1='','use value since feature not found",q1) Number of questions is not really a concern for the user. If you can get the form fast the backend does not matter. I did have a form that did some calcs like the above. In the end we took them back out because 1 - it did slow down the form since my lookups were huge and 2 - people were then using these temp calcs in actual analysis without doing QA and all that. Also just to check - are your lookups and lookup values inside of a repeat? I found a speed bug with that. ... View more