Discussions

Expand all | Collapse all

Need to rename the fields in a table

  • 1.  Need to rename the fields in a table

    Posted 09-19-2017 21:15
    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.

    Thanks,

    Gaurav


  • 2.  RE: Need to rename the fields in a table

    Posted 09-19-2017 21:21
    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.


  • 3.  RE: Need to rename the fields in a table

    Posted 09-19-2017 21:43
    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.


  • 4.  RE: Need to rename the fields in a table

    Posted 09-20-2017 07:02
    Thank you, Matthew and Mark!