I tried creating a formula field to link to Google Maps but got hung-up on using a dropdown menu item in the formula.
For data integrity, I try and use as many “fixed” option data points as possible when building a data system. It helps reduce user error in free text inputs. In this case, I used a dropdown menu for US states, then tried to use that in a formula, but could not.
Next I tried creating a “dummy” field with
state.toString() and planned on calling the dummy field in the Google Maps formula, but that did not work either.
Do the text formulas not support dropdown fields and/or
.toString() or am I have I missed something?