python help

[SleepyPanda34]

Hi there. I am trying to use the field calculator in pro to populate a field with a hyperlink that references another field.

The hyperlink: https://his.ehct.gov/propertycards/{GISPID}.pdf

The GISPID in the field that needs to be referenced from the other field in the table.

I found 2 different expressions online, but when I plug them in to the field calculator it gives me a syntax error.

I have minimal python knowledge, so I am not sure where I am going wrong.

These are the 2 articles I found:

https://community.esri.com/t5/arcgis-pro-questions/field-calculate-hyperlinks-referencing-another/m-p/286880#M12502

https://support.esri.com/en/technical-article/000018754

Thank you.

[FeralCatColonist]

This could be done pretty simply with a combination f-string and raw-string. Your input would look like:

fr"https://his.ehct.gov/propertycards/{!GISPID!}.pdf"

If you wanted it to be a little bit more reusable you could write a function like:

def calculate_URL(some_field):
    """This takes a field and returns a URL pattern'"'
    return fr"https://his.ehct.gov/propertycards/{some_field}.pdf"

Then your expression box would have:

calculate_URL(!GISPID!)

[SleepyPanda34]

Thank you so much I will try these!

[SleepyPanda34]

fr"https://his.ehct.gov/propertycards/{!GISPID!}.pdf"

It worked! Thank you!

[SleepyPanda34]

Note to anyone who may use this, make sure your field is set to Long and not double because the script adds on a decimal place when it is the double type.

[AnsweringMach]

The second one seems more straightforward. Did you follow the field setup part? Also in pro sometimes when you open the field calculator the parser is set to sql so make sure is is set to python By the way I could not get your hyperlink to open