0

how to Changs a text field to URL

I have defined a feild at the start as text. but would like to change it to a URL/. How do I do that?

4 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    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? 

    • David_WILLOX
    • 4 yrs ago
    • Reported - view

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

    Thanks for your help. 

    Have a nice day,

    David W. 

    • Mconneen
    • 4 yrs ago
    • Reported - view

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

    theFields

    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 

    theScript

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

    theResult

    • David_WILLOX
    • 4 yrs ago
    • Reported - view

    Nice!

    Thank you. 

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 1656Views