Calculated Fields Character Limits | Community
Skip to main content
L
LukaszMa
Level 3
May 24, 2023
Solved

Calculated Fields Character Limits

  • May 24, 2023
  • 1 reply
  • 1153 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed_AtAppStore


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

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
May 24, 2023


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

    Terms & ConditionsAccessibility statement

    Loading footer...