Can we use superscript text

Question

Hello,

I have been researching to no avail the ability to use superscript text within Survey123 and I'm guessing that we cannot do so? I have figured out a formula to breakdown Longitude and Latitude pairs recorded in decimal degree into decimal minute seconds, but I cannot add the superscript "o" to the Degrees, nor can I add the " ' " to the minutes. The second was easy, because I could use the designation of ' 'N'.

This the format that I would like to store within a calculated question - 5° 14' 4.416"

Any insight would be greatly appreciated.

Thanks!

Mike

JohnHasthorpe · Answer

Above opened as a new question here: https://community.esri.com/thread/194609-not-your-standard-note-question-email-link

Anonymous User · Answer

Jonathan,

This worked out for what I needed it to do. I have another question for you and it concerns a 'Note' question. I have figured out a way to create a hyper link for this note field that once clicked on will open up an email with some standard text and some answers from other form questions within the form. Everything works until I attempt to send the survey to my AGOL account. I receive an code 1000 "String or Binary data would be truncated. The statement has been terminated."

I know that this is being caused by this Note field, because when I remove it, the survey performs just fine. However, I will get the error when I place it into the form and republish it.

My first thought was to use an "if" calculation that states if Question "Did you send the email" is equal to No then the Hyperlink would be the result. However, if the question was answered "Yes", then a string of Sent would be displayed instead.

Do you know how to get around this? it would be awesome to get this work, because then we could also create a URL link that could potentially open and send data from one survey into a new survey.

Any information would be greatly appreciated.

Mike

JohnHasthorpe · Answer

Hi Mike - I have attached an XLS with a couple of options for getting this working. The concatenate function does not like the apostrophe unless it is passed in as a string. So i used string("' ") and passed it in via a question: (Q_Apps)

Not very elegant, but hopefully this will get you going.

ReformattingCoordinates.xlsx