June 6, 200619 yr 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
June 6, 200619 yr 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.
June 6, 200619 yr Author Thanks very much. I've decided to go with the repeating fields option, and it's working a treat. Regards, Dan
Create an account or sign in to comment