how to Changs a text field to URL

You can ADD the new URL field into your table... Then write a quick script that will copy the contents from your old field to your new url field..   You can run this script either from the console... OR.. create a temp table and add a button to it and put the script behind the button.. 

Does that make sense? 

Hello, do you have an example of the script to run in the console?

Thanks for your help. 

Have a nice day,

David W. 

Here is a snapshot of the table  AFTER I added a URL field to it. 

The code..   In this case. my table name is ... Job  .. and do not forget to click the top right wrench icon so you can open up the console 

The results.. You can go into the data model and remove "Text URL" when you are done. 

Nice!

Thank you.