Latest Contributions by DavidBuehler

‎06-14-2018

If figured it out based referencing this: Excel formula: Nested IF function example | Exceljet My examples if(${workorder_calc}> 1, "REPLACE", if(${workorder_calc} = 1, "OPTION TO REPAIR", if(${workorder_calc}=0,"REPAIR",''))) if(${joint_seperation}=16, 2, if(${joint_seperation}=8, 1, if(${joint_seperation}=0,0,0)))

‎06-11-2018

Nevermind, apparently I needed an extra zero at the end.

‎06-11-2018

Hi James, I figured out a simple calculation based on the value entered from the previous question, but I am having trouble with my nested if statement. if(${joint_separation}=16, 2, if(${joint_separation}=8, 1, if(${joint_separation}=0,0))) basically if the value from joint separation is 16 give it a value of 2, if it is 8 give it a 1, and if it is 0 give it 0. I keep getting an error of "the problem was located in calculate expression for ${join_calc}. if requires 3 arguments, only 2 provided. What am I missing?

‎06-07-2018

Hi James, The best way I can describe one of them is parallel calculations. Based on the way the questions are answered gives a total score. based on that total score tell me if it is a high priority, medium priority, etc. based on a value range. I would like to display the high, medium, low, etc. message based on the value ranges. These fields will be integer scores. The other calculation is going to give the user a option message. Based on the values of the questions give some secondary fields values then calculate those into another message based a value range. my calculation would if(${spalling} = 1, "1"), if(${spalling} = 0 , "0") and there will be a series of these values that get added up Is that possible?

‎05-22-2018

In my Survey123 form, I have a calculation that totals the values of several questions give the calculation a total score. What I would like to do next is calculate if the value is between 0 and 5 give it a text description of X, if the value is between 6 and 2 give it a different text description and so on and so forth. Is this possible, and if so how would I do that?

‎01-18-2018

I don't know if I missed something or if this is an enhancement type thing. I would like to better navigate the shortlist's tabs. I am using the Shortlist Builder Beta. I would like to click a tab and have it zoom to said tab's area, as well as have the home button. This doesn't seem possible. I see you can add bookmarks from the underlying web map in separate button, but it is disconnected from a tab. In my case, I would like to set up a tour of several different historic districts, and each tab is a different district. It would be great to zoom to that district when the tab is clicked or the location from the device is in/near that district. Did I miss a setting?

‎01-05-2018

Did you figure this out?

‎10-13-2017

General Update - More Windows 10 users were affected. Similar symptoms mostly related to database connections. A mild symptom is the database connections missing. Remedy - restore database connections. More extreme is trying to make a database connection and crashing. The most extreme is the ArcMap not opening an .mxd. With the last two extremes a repair worked. I am pretty sure it is linked to some update pushed out for Windows 10, as it only affected those users with Windows 10 in my organization. No idea which one, as our IT staff pushes them out in bulk every month.

‎10-11-2017

The reset of the ArcGIS profile in combination was part of the issue, and worked temporarily. I also did a repair of the ArcDesktop installation with a restart of the computer because it did bleed over into the other profiles and work temporarily with the new profile, and it is working now and have not had any issues since. Thanks Rebecca for the information.

‎10-10-2017

I should add this is a Windows 10 computer.

‎10-10-2017

Using ArcGIS Desktop 10.3.1. A user reported that both ArcMap and ArcCatalog crash when double clicking add database connection. I saw it crash, and then logged in with two different users with no problems. I ran a repair just to be sure with no success resolving the users issue. I am pretty sure it is a user profile issue. Any suggestions on how to fix this issue?

‎09-22-2017

Solved this problem with a reporting service (SSRS).

‎09-19-2017

I get the time stamp of editor tracking. What I cannot figure out is in the report designer, how do I get the box in the header to list the most recent edit change time stamp for which ever record had the most recent change. Is there a formula that needs to happen in the properties that I am not seeing?

‎09-18-2017

I am working on a report that will display benchmark elevations from a database table. A helpful display field in the header would be the last time something was modified. That way a user can quickly see if their copy is out of date. I am not seeing a way to put the most recent time stamp for all the records in a text box in the header of a report generated through arcmap. The end goal would be to automate the updating of this report periodically and put the report out for public to use. I don't think doing it this way is possible, but I am open to suggestions and better ways to automate a report with custom headers via python. Any help would be much appreciated.

‎08-30-2017

Thanks. I did indeed miss that. It works. thanks for you help.

Online Status	Offline
Date Last Visited	‎04-03-2024 11:21 AM

My Ideas

Latest Contributions by DavidBuehler

Re: If calculated value is between give it a text value Survey123

Re: If calculated value is between give it a text value Survey123

Re: If calculated value is between give it a text value Survey123

Re: If calculated value is between give it a text value Survey123

If calculated value is between give it a text value Survey123

Shortlist Builder Beta - Click tab and zoom to tabs contents

Re: Convert VARBINARY (BLOB) to Base64 String using T-SQL

Re: ArcDesktop crashes when trying to add a database connection

Re: ArcDesktop crashes when trying to add a database connection

Re: ArcDesktop crashes when trying to add a database connection

ArcDesktop crashes when trying to add a database connection

Re: Custom report with a spot displaying the most recent change to the data

Re: Custom report with a spot displaying the most recent change to the data

Custom report with a spot displaying the most recent change to the data

Re: Pass Search Parameter in URL

Hosted Feature Layer Editability No Honored

Re: Widgets in Development

Delete empty folder says 1 item in it

Convert hosted feature class into separate items f...

Re: Calculating Max and Second Max with counts of ...