How to change field-type of an existing field from Data To Link?

Hello there,
I have a field of Data type, now I want to make it into a Link type, but I am not able to do through customize form. Field is in the doctype ‘request for quotation’ so I am using customize form as it is internal ERPnext model

But I am not able to do it. I am deleting the field and adding again then it shows that field already exists (because the field is added in the database as the column name and no way to change it)

I thought of deleting the column manually from the database, but then there are two other tables, customize_field and property setter which are getting in the way. Is there any easy solution for this thing?

I even tried Custom Field List and tried to edit from there.
I am getting same issue

At the end, I just changed the database directly and then exported those changes through customize form.
If anyone has any other idea, do let me know as I also don’t suggest directly editing database columns when developing under such a cohesive framework.

use property setter

@519_Hamza_Habeeb
Can you help me exactly what they are and where I can find their documentation?

I can’t find any documentation about Property Setters in the Frappe documentation.

just search property setters in your erpnext app

wont find much documentation on it, it allows you to change the property of a standard field
*this is not advised to do as it can damage the integrity of the application.
create a custom field instead

I have created custom_field. now i am not able to change doctype for that custom_field only. So what to do?

delete and create another one

Still the issue is same as i can’t delete the field only. I have told that in my question.

Since even after deleting, ERPnext does not actually delete the column from the database.

@519_Hamza_Habeeb What about this now?