Field calculator code not working when using text field as a parameter
Hi everyone! I'm fairly new to using the ArcGIS API for Python and Python in general. I'm trying to write a script to populate a "Client_Status" field based on my company's "Internal_Status" field. There are no errors popping up when I run this, however it is not actually updating any rows as shown in the screenshot below.
I then tweaked the code and set the where clause equal to and OBJECTID, since that's the field that was used in all the ESRI documentation I saw, and it worked! So I'm guessing using the "Internal_Status" field in the where clause is what went wrong.
However I really need this calculation to be based on the "Internal_Status" field, since these statuses are input from a list by field agents and I just need to convert them to the format/exact wording the client wants. Can anyone help with identifying what else might be wrong in the first screenshot? Does the calculate function only work with certain field types? If so, can someone point me in the direction of a workaround for this? Any guidance would be very appreciated!
Accepted Solutions
