Skip to main content
LukaszMa
Level 3
May 24, 2023 8:37 AM UTC
Solved

Calculated Fields Character Limits

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.
Doug_Den_Hoed_AtAppStore
Doug_Den_Hoed_AtAppStoreAccepted solution
Community Advisor
May 24, 2023 12:49 PM UTC


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

Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
View in thread

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
May 24, 2023 12:49 PM UTC


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

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
    Terms & ConditionsAccessibility statement

    Loading footer...