Latest Contributions by JoeLivoti

‎02-10-2022

Is it possible to automatically code the background by time? I've seen it down by coded domain, changing the background for different statuses, but can it be done for time? My example: An employee fills out a survey123 form stating where and when they are going somewhere. The the the list widget on the dashboard would then highlight the employee's name as red or green for the availability status based on the time back out and in (red for the time between out and in and green for any other time not accounted for)

‎01-18-2022

Gotcha!!!! that works too... i was just looking to change the word color, but this is more dynamic!!! thank you very much!!!

‎01-18-2022

where in the code do i put that (please forgive me i'm pretty new to arcade in the dashboards)... as i've done in the picture??

‎01-18-2022

If someone could please help me with the code and how to implement it. I have a list with status field in it. I would like to color code the status based on choice that was made. the field name is status the options are - submitted (color to be red), received (orange), inprogress (yellow), resolved (green) i believe i need to go to the list and advanced formatting, but that's all i know at this point. any help would be greatly appreciated!!! Thank you

‎08-26-2021

in this details box. as you can see they are currently ordered by date with newest on top. I'd like to make the next bigger if the date = today's date so as to draw attention to it.

‎08-26-2021

In the details box, How might I code something so that if the date equals {today} that the text would change size? thank you

‎07-14-2021

Hello all, I have created a dashboard to monitor the citizen complaints of our community. What I would like to be able to do is calculate the average number of days from the time a complaint was submitted from the current day. This will then eventually extend into the average number of days between submission and completion. I'm positive this can be done somehow, but I am unsure of the how and where. Any help would be greatly appreciated! -Joe

‎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

Online Status	Offline
Date Last Visited	‎09-11-2023 10:54 AM

My Ideas

Latest Contributions by JoeLivoti

filter based on time

Re: color code list using arcade

Re: color code list using arcade

color code list using arcade

Re: Code to change field date size if equal to today

Code to change field date size if equal to today

Dynamic Date Difference

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: Concantenate not working for geopoint

Concantenate not working for geopoint

Dynamic Date Difference

Survey123 and Power Automate (formerly MS Flow)