Latest Contributions by JoshuaSharp-Heward

Hey Rach, Yeah so if you go into configuration for the table and look at "actions" you can set it to filter the details widget based on the current selection!  ... View more

Yeah I don't think so unfortunately, the only other way I could think of would be formatting it in another column using HTML, but I suspect that HTML isn't actually supported for attribute tables. ... View more

What sort of a web application are you using this in, an ArcGIS Dashboard or something else? I think you'd be able to do this in a data expression in a dashboard, but if you're aiming for a table in a Web AppBuilder or Experience Builder application you may have to settle for adding another field to your feature service and calculating it with the base URL and REG_ID value. ... View more

Hi Sara, Would you be wanting to have the URL differ for each value by appending the RegID value on the end? I would recommend having an arcade expression that concatenates a base url with the RegID value and has that as a field in the features popup, something like: var RegID = $feature.RegID var BaseURL = "yourUrl" return BaseURL + Text(RegID) Or you can have custom text in the popup with a hyperlink, so it displays the RegID with the hyperlink being "yoururl{RegID}" ... View more

Hi, I've wanted to do this in the past and the best solution I found was to have an integer field outside of the repeat with a calculation set to count(${question_in_repeat}), and a constraint set to .<7. This means the user can do as many repeats as they want, but if they try to submit and they've completed more than 6 repeats it will stop them due to the calculated field being more than the number of repeats you want to limit them to. You can also set the integer field to bind::esri:fieldType = null to prevent it from being created as a field in the resulting feature class for tidiness. ... View more

No worries 🙂 glad I could help out! Do you want to mark this as solved so people know we've got a resolution? ... View more

Hi, It needs to match the 'code' not the 'description', as the code is what's stored in the database and the description is what it's shown as. That'll be why it's failing for you. ... View more

Can you post a picture of the domain as well as some of the input data that should match the domain?  ... View more

Oh I thought the calculate field was failing, not completing with warnings. And it's not working for any of the records, even ones that look like they should work? Does your input data match the codes or the descriptions in the domain?  ... View more

Hi, I've tested it on my end and it seems to work - have you set "allow null values" to no on your field with the domain? If so then it would be trying to set non-domain values to Null and then stop working as it's not allowed. If not, can you post a screenshot of the error message? ... View more

No worries 🙂 have a nice rest of your day! ... View more

Hi, I've gone for a slightly different approach to the problem as I think with that many if/else if clauses it can be tricky to work out what's going on. var RESF1Score = $feature.PR_RESF1_SCORE var RESF2Score = $feature.PR_RESF2ENG_SCORE + $feature.PR_RESF2NAT_SCORE var RESF3Score = $feature.PR_RESF3_SCORE function isTwenty(i) { return i == 20 } var num20s = Count(Filter([RESF1Score, RESF2Score, RESF3Score], isTwenty) When(num20s==3,20,num20s==2, 10, num20s==1, 5, 0) To summarise what this is doing: Adds ENG/NAT together as one is filled in each time and the other is 0, for the purposes of this calculation I believe they can be lumped together because ENG and NAT are treated equally Assigns a variable for the above plus the RESF1 and RESF3 score Create a function that returns true if the input is equal to 20 Uses the Arcade Filter function with the list of scores from above, to get rid of any that aren't 20, and returns the count of the number of 20s Uses the When function to return the 20 if there are 3 20s, 10 if there are 2, 5 if there's 1 and 0 if there are none Hope this works for you! Seemed to be working fine in the Arcade playground for me. Cheers, Josh ... View more