Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Calculated Fields Character Limits

Avatar

Level 3

Hello,

 

Is there a limit of character or lines you can put in Calculated Field syntax? I've build quite simple but extensive IF statement but am unable to save it due to what seem to be the amount of characters. 

 

Kind regards

Lukasz

1 Accepted Solution

Avatar

Correct answer by
Community Advisor


Hi @LukaszMa,

 

Yes, most large text fields (including custom parameter calculations) have a maximum of either 2000 characters or at 4000 characters, which you can confirm by pasting a string of text near those (database controlled) limits to see what saves, and what fails.

 

As a workaround, if you can shorten your syntax to fit, I’d recommend that first; otherwise, you may have to resort to chaining your logic by layering it across two or more calculations (which is harder to maintain, and might lead to stale data).

 

Regards,

Doug

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor


Hi @LukaszMa,

 

Yes, most large text fields (including custom parameter calculations) have a maximum of either 2000 characters or at 4000 characters, which you can confirm by pasting a string of text near those (database controlled) limits to see what saves, and what fails.

 

As a workaround, if you can shorten your syntax to fit, I’d recommend that first; otherwise, you may have to resort to chaining your logic by layering it across two or more calculations (which is harder to maintain, and might lead to stale data).

 

Regards,

Doug