Latest Contributions by CCWeedcontrol

I made some changes to my arcade expressions and was able to get to work like I wanted to with the color but the issue I am having now is that if the "days" are "0", what I have as return"IN PROGRESS" doesn't work/popup. how can I get to return ""IN PROGRESS" if the there is zero days?   Expression 1 var startDate = Date($feature["Received_date"]) var endDate = Date($feature["PI_DecisionDate1"]) var age = DateDiff(endDate, startDate, 'days'); // return "Response time:" + " " + age + "days"; if (age >= 0){ return "Response time:" + " " + age + "days"; } else if (age <= 0){ return "IN PROGRESS"; }   Expression 2 var days = Round(DateDiff($feature["PI_DecisionDate1"], $feature["Received_date"], 'days'),0); var result = "" if (days <= 31){ //Less than result = "#0a75ad"; //Greater } else if (days >= 31){ result = "#fe015a"; } return result;   HTML <p style="color:{expression/expr2};"><font size="4">{expression/expr1}</font></p>‍ ... View more

In Map View Classic. ... View more

All I have configured on my popup is {expression/expr1}. Not sure how to set it up, I've been looking for some video or blogs but I haven't' found one that explains how to configure the pop with the arcade expression. I was trying to originally wanted to display this in a Dashboard, to get an average of all, but couldn't figure out how so I thought I would try this on the map.   I was able to get the popup to work with the following     var startDate = Date($feature["Received_date"]) var endDate = Date($feature["PI_DecisionDate1"]) var age = DateDiff(endDate, startDate, 'days'); return "response time" + " " +age + " " + "Days";       But just a simple response time "10" days.     With yours     var startDate = Date($feature["Received_date"]) var endDate = Date($feature["PI_DecisionDate1"]) var age = DateDiff(endDate, startDate, 'days') var age_str = Iif( !IsEmpty(endDate), `Response time: ${Text(age)} Days`, 'IN PROGRESS' ) var age_color = When( age <= 30, "#2986cc", age > 30, "#d21c06", "#f9905d" ) return { type : 'text', text : `<font color=${age_color}>${age_str}` }       I get the following when I hit the Test button. Result Value Result text <font color=#2986cc>Response time: 22 Days type text Type Dictionary   Map popup display.   [object Object] ... View more

I have looked into it, but this snip-it of code will be part of a larger code and it would be nice to not have to create new files then have to join them back. ... View more

When you say that I don't have a column with a unique Value, doesn't the OBJECTID in the feature class and table count as unique columns? ... View more

My apologies, I might have complicated things. I removed fields to make the files smaller. I hope this makes sense and thank you so much for trying to help. The feature class and the table only have the PermitNum field as unique identifiers. I adding fields to the feature class to match the tables fields. So I can transfer attributes from the table to the feature class.The table can have multiple permits with more than one parcel associated with that permit. For example in the table PermitNum Parcle CR2020-0005 34252 CR2020-0005 34263010 CR2020-0005 34263012 : The feature class only has the following the PermitNum. PermitNum Parcel CR2020-0005   CR2020-0005   CR2020-0005     And when I run the code on my first post I get the following PermitNum Parcel   CR2020-0005 34263010   CR2020-0005 34263010   CR2020-0005 34263010     I need to transfer the table attributes to the feature class like below. Feature class after the code PermitNum Parcle CR2020-0005 34252 CR2020-0005 34263010 CR2020-0005 34263012 ... View more

I used the following. took me a while to figure out that ")" went after the $feature.percentage.   IIF(Text($feature.percentage) == '25', 'background-color:#1987bb', 'background-color:#DDDDDD') ... View more

I was able to accomplish this with the following but it only works for "Text" fields. My fields is a Long field. How can change the Arcade code to accept the long field? Arcade IIF($feature.PercentCom == '25', 'background-color:#1987bb', 'background-color:#DDDDDD')   HTML <span><b><br /><br /><br />Phase</b></span> <table style=" border-collapse: separate; border-spacing: 6px 4px; width: 100%; table-layout: fixed;"> <tbody><tr height="16"> <td style="{expression/expr0}"></td> <td style="{expression/expr1}"></td> <td style="{expression/expr2}"></td> <td style="{expression/expr3}"></td> </tr> <tr height="24" style="text-align: center;"> <td>25%</td> <td>50%</td> <td>75%</td> <td>100%</td> </tr> </tbody></table>   ... View more

Jeffk, thank you very much for the help and my apologies for the corrupt data. I have attached new data and have verified that it should work. I have changed the TablesView field name from 'Par' to 'Parcel_1'  and the feature classes field name'Par' to 'Parcel'  as it was getting confusing. I have the following based on you provided but the 'Parcel' field is being populated in the Case_lyr feature class. The valueDict prints- 'CR2021-0006R2957001100': 1, 'OR2021-0008R3014800000' The concatenatedKey - prints CR2022-0001R3301700000 CR2022-0001R3301901000   sourceFC = "C:/Temp/Cases.gdb/Table_View" valueDict = {} with arcpy.da.SearchCursor(sourceFC, ['OBJECTID', 'PermitNum','Parcel_1']) as sCur: for row in sCur: # str(row[sCur.fields.index('AppS')]).replace('/', '') <- use this to convert the dates in the App fields to strings concatenatedKey = row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('Parcel_1')]) if concatenatedKey in valueDict.keys(): print(f'duplicate concatenation: {concatenatedKey}') else: valueDict[concatenatedKey] = row[sCur.fields.index('OBJECTID')] fc_dest = "C:/Temp/Cases.gdb/Cases_lyr" with arcpy.da.UpdateCursor(fc_dest, ['OBJECTID', 'PermitNum','Parcel']) as uCur: for row in uCur: if row[2] is None: lookupKey = row[sCur.fields.index('PermitNum')] + str(row[sCur.fields.index('Parcel')]) if lookupKey in valueDict.keys(): print(f'{lookupKey} found, setting Par to: {valueDict.get(lookupKey)}') uCur.updateRow(row)     ... View more

Jeffk. Thank you for the reply. I would like to being all values but I didn't want to type them all out in my example. I guess I am not sure how to proceed with the construction of the code as I am not familiar with "keys" on how your example is showing them. Is there a complete example of the process you are describing? ... View more

Unfortunately they are not lined up like on the pictured I attached, I was trying to give an example. I have attached some sample data if anyone is kind enough to help me out as I am not sure how else to accomplish what I need. ... View more

Base on the PermitNum, For example permit 2020-0014 has 7 records in the Par field in the table I need it to transfer the tables Par field records to the feature classes Par field if they don't exits in the feature class, 2020-0013 has 4 permit records in the table I need to only transfer  the two Par records to the feature class since it already the feature class already has two populated. I don't need to transfer ones that already in the feature classes Par field. Hopefully this makes sense.  I can attach some data if that would help? Thank you for responding I am very appreciative.   ... View more