Latest Contributions by JoeLivoti

‎08-21-2020

Thank you.

‎08-21-2020

I have just recently run into a problem. I am using pulldata for the lat/lon of centroids of townships. I try to use the concatenate in the calculation and i keep getting this error: I've attached both the xls form and the csv for the pulldata. Any help would be greatly appreciated!!

‎08-07-2020

Thank you both for your help! I used this in the field = 'https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/{}'.format(!FACILITYID!)

‎08-07-2020

I am trying to add a hyperlink to a layer referencing another field in the layer. I'm using python3 expression type in the calculate field window. Below is the code: 'https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/!FACILITYID!' However, It is populating with: https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/u"00133" For some reason it is adding the u and the " " around my facility ID I need it to simply be: https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/00133 Any help is greatly appreciated!

‎07-29-2020

Thank you Dan!! The second one was exactly what i needed!

‎07-28-2020

Dan, Thank you that worked perfect. How would I augment that to change a different value in the string, say the second value to a 5? Again thank you!!!!

‎07-28-2020

Pretty simple question I'm sure for the Python people out there. I have a field, FACILITY ID, that is populated as string values as 00001,00002, 00003, and so on. All values in the field are 5 characters long. I want to change the first number in to a 1 so the values of the field look like 10001, 10002, 10003, etc. I'm pretty sure i should use the .replace(), but I cannot format it correctly. Any advice would be very welcome. Thank you.

‎07-23-2020

Xander Bakker‌, Thank you so much that did the trick exactly. While tedious, it formats the data exactly. Do you think there is a way to create a single arcade expression and then plug that into html for the formatting? Not asking you to figure it out, just if you think it is possible. If so, I may make that a project of mine to try and work on in the future. Again, thank you so very much for all of your help! -Joe

‎07-23-2020

Again Thank you Xander Bakker for your reply. I know it's seem quite unwieldy, but this pop-up is catered to an audience of one. So am I to understand I can write one long expression and include "TextFormatting.NewLine" after each field? Where would i put the formatting? I apologize as my arcade skills are practically nil. What would the below example look like and can it still be formatted with the field name bold (i've included the individual IIF statements along with the how I have it set up in the Attribute display below that): IIF(isEmpty($feature.status14), "", "Footer") IIF(isEmpty($feature.status14), "", "Status") IIF(isEmpty($feature.assignedto14), "", "Inspector") IIF(isEmpty($feature.other14), "", "Other Inspector") IIF(isEmpty($feature.date_approved14), "", "Date Approved") IIF(isEmpty($feature.notes14), "", "Notes") IIF(isEmpty($feature.status15), "", "Foundation") IIF(isEmpty($feature.status15), "", "Status") IIF(isEmpty($feature.assignedto15), "", "Inspector") IIF(isEmpty($feature.other15), "", "Other Inspector") IIF(isEmpty($feature.date_approved15), "", "Date Approved") IIF(isEmpty($feature.notes15), "", "Notes") {expression/expr5} {expression/expr0} {status14} {expression/expr1} {assignedto14} {expression/expr2} {other14} {expression/expr3} {date_approved14} {expression/expr4} {notes14} {expression/expr6} {expression/expr7} {status15} {expression/expr8} {assignedto15} {expression/expr9} {other15} {expression/expr10} {date_approved15} {expression/expr11} {notes15} Thank you again so very much for any help and advice!!

‎07-22-2020

Xander Bakker, Thank you for the reply. I was wondering if you could help on one other matter. I have gone and done things the LONG and TEDIOUS way. I have created over 200 individual IIF statements: ex IIF(isEmpty($feature.notes35), "", "Notes"). My popup currently looks like this: How can I get rid of those fields that are empty? Popup Expression currently is this: with a total of 210 lines. Any help would be greatly appreciated. I've looked at the other blogs and other questions people have asked and i just cant quite get it down. -Joe

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by JoeLivoti

Re: Concantenate not working for geopoint

Concantenate not working for geopoint

Re: Calculate field inserting extra characters

Calculate field inserting extra characters

Re: How do I replace the first character of a string using calculate field in ArcGIS Pro?

Re: How do I replace the first character of a string using calculate field in ArcGIS Pro?

How do I replace the first character of a string using calculate field in ArcGIS Pro?

Re: Conditional Field display with Arcade in Pop Ups (revisited)

Re: Conditional Field display with Arcade in Pop Ups (revisited)

Re: Conditional Field display with Arcade in Pop Ups (revisited)