Hi Folks,
I need to limit the size of TextArea fields to 4k characters because of some downstream impacts. In studio, there is no Maximum Size value. Does this mean that Text Area fields cannot be character limited and do not have a limit? If not, any idea how I could adjust it outside of Studio? I have not seen anything definitive in any of the documentation.
Thank You!
Using Sell Advanced Version 25.1.0
Hi Alex,
Although it’s not available directly in Studio, you can control the maximum length of a TextArea field by editing the len column in the fields_meta_data table in the database.
For example, I created a custom field named only_5_chars_c and ran the following SQL query after creation:
UPDATE fields_meta_data SET len = '5' WHERE name = 'only_5_chars_c';
As a result, when attempting to save a record with more than 5 characters in that field, the system throws a validation error, confirming the limit is enforced.
Let me know if this helps!
If you’re on SugarCloud, you’ll need to open a support case to have the query executed by the support team.
Cheers,
André
Hi Alex,
Although it’s not available directly in Studio, you can control the maximum length of a TextArea field by editing the len column in the fields_meta_data table in the database.
For example, I created a custom field named only_5_chars_c and ran the following SQL query after creation:
UPDATE fields_meta_data SET len = '5' WHERE name = 'only_5_chars_c';
As a result, when attempting to save a record with more than 5 characters in that field, the system throws a validation error, confirming the limit is enforced.
Let me know if this helps!
If you’re on SugarCloud, you’ll need to open a support case to have the query executed by the support team.
Cheers,
André
