Script Editor Field Name Length

The field name set in the script editor can not exceed 50 characters and any characters over this will be truncated down to 50 characters.

If a field of the same name (first 50 characters) exists in the script already a SQL loop will occur as the Script Editor will append and _ and the field id (ie: _254) to the end of your new field name which is then truncated off. This will affect your servers performance.

 

The solution is to not use such long field names and we recommend a maximum of 40 characters field name length. 

This way if a duplicate field name exists the auto renaming process of adding _ and the field id on the end will not cause issues.

Generally a shorter precise field name is more appropriate than a full sentence style field name.