<div dir="ltr">Changing field types is not easy. The best is to add a new field of the right type, copy the data to it and then delete the old field. There is no UI for copying from one field to another so you have to do that by writing code or using PhpMyAdmin.</div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Jun 1, 2014 at 8:21 AM, Ashley Hall <span dir="ltr"><<a href="mailto:knowledges33ker@gmail.com" target="_blank">knowledges33ker@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><span style="color:rgb(68,68,68);font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:14.399999618530273px;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)">I have a custom field on my user profile pages where users can enter their Twitter user name. When the user's profile is rendered (either on the user profile page itself or via views) I would like to rewrite this field so that it links to the user's twitter profile following the pattern</span><a href="http://twitter.com/%5bfield_twitter_name%5d" rel="nofollow" style="margin:0px;padding:0px;border:0px;font-size:14.399999618530273px;vertical-align:baseline;text-decoration:none;color:rgb(52,158,223);font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)" target="_blank">http://twitter.com/[field_twitter_name]</a><span style="color:rgb(68,68,68);font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:14.399999618530273px;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)">.</span><div>
<span style="color:rgb(68,68,68);font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:14.399999618530273px;line-height:14.5600004196167px;text-align:left;background-color:rgb(255,255,255)"><br>
</span></div><div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px">I discovered the twitter username project on DO yesterday (</span></font></span><a href="https://drupal.org/project/twitter_username" target="_blank">https://drupal.org/project/twitter_username</a><span style="line-height:14.5600004196167px;color:rgb(68,68,68);font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif;font-size:large;background-color:rgb(255,255,255);text-align:left">) and this would help me accomplish the objective, especially for new users. However, we currently have ~900 active users on our site. </span></div>
<div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px"><br>
</span></font></span></div><div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px">Is there a way to create </span><span style="line-height:14px">a</span><span style="line-height:14.5600004196167px"> new field and update its tables with the existing user's twitter names? Or is there a way to change the field type from it's current setting of "Text field" to the new type made available by the twitter username project "Twitter username"?</span></font></span></div>
<div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px"><br>
</span></font></span></div><div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px">Any help would be greatly appreciated.</span></font></span></div>
<span class="HOEnZb"><font color="#888888"><div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px"><br>
</span></font></span></div><div><span style="text-align:left;background-color:rgb(255,255,255)"><font color="#444444" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif" size="4"><span style="line-height:14.5600004196167px">Ashley</span></font></span></div>
</font></span></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div>