Change datatype from Extra long text to Text

Question

We have some fields with extra long text type in our records. Seems only 3 fields are allowed with extra long text data type and we had 4 fields. We assume this warning is coming because of the recent upgrade. Its showing warning that only 3 fields can have extra long text and its not allowing us to add any column. And we are unable to change datatype from extra long to text from record side. I changed the column from text to varchar in db side but still getting this error. Please let us know how to resolve this issue.

Sarathkumar R · Accepted Answer

Update on this issue Seems this issue goes away once we update the database from text to varchar and go to map record fields and click on finish. Shubham Aware Harsha Sharma Thanks for your inputs

Shubham Aware · Answer

From version 25.1 added the 3 Extra Long Text field limit. I know it's very frustrating when platform updates break existing functionality that was working fine before. 
 Sarathkumar R said: And we are unable to change datatype from extra long to text from record side. I changed the column from text to varchar in db side but still getting this error. 
 When you change a column from TEXT to VARCHAR in the database, record doesn't automatically update the field type due to caching. Remove the 4th Extra Long Text field from your Record Type, save, then re-add the same field. It will now correctly show as "Text" type instead of "Extra Long Text" since record will read the updated VARCHAR type from the database. This remove-and-re-add approach is the standard solution for this issue. Note : When you delete and re-add a field, Appian does NOT automatically update references - you'll need to manually remap the field in all dependent objects. Consider documenting all dependencies first, then update each one after re-adding the field.

Change datatype from Extra long text to Text

Top Replies