Script to change field name

[dstuchbury]

Dear All,

I'm looking for a way to change the name of a field within a script. The database is a CRM contact management system, with several user-definable fields. Currently, I have to make the changes to field names myself, a users do not have admin rights, but I was wondering if there is any way to automate this process.

Many thanks in advance for any suggestions, which are greatly appreciated.

Regards,

Dan Stuchbury

[comment]

As a rule, scripts cannot change the database structure. However, you could turn each user-definable field into a pair of FieldLabel and FieldValue fields. Or add one repeating text field to hold the labels for all the user-definable fields.

[dstuchbury]

Thanks very much. I've decided to go with the repeating fields option, and it's working a treat.

Regards,

Dan