Need to rename the fields in a table

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
Hi team,

Do we have any option where we can rename the name of all the fields?

I have around 553 fields in a table where I need to rename fields from clients to customers.

Please let me know if you need any additional information.


Photo of Gaurav Sharma, Certified Builder and Expert

Posted 2 years ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
If you change the Table name, it give you the option to pick the fields that you want to change.  

Try changing the table name from Client to Customer and then select which fields/forms/reports you want to change the name.
Go to Settings for the Application, then App Management and then Search and Replace in Schema
this is very powerful and designed exactly for what you need to do.

Be sure to choose the radio button to see what it will do before it makes the change.  You will be AMAZED as once you say OK, it makes the change in the blink of an eye.
Thank you, Matthew and Mark!