Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Format Field with formula to not show negative numbers

Avatar

Level 1

Hello,

I am very new to adobe livecycle designer (es3), and even newer to calculate scripting. I created a formula in form calc language (see below) in a form, and it works as it's supposed to. However, the when no data is entered in the oct[0] field, it automatically calculates in the calculate scripted field and shows a negative number. I do not want to confuse the users of this form. Is there any way for me to format the calculate scripted field, so that it only shows 0 or nothing (preferably) when there is no data entered. Any help you can provide would be greatly appreciated.

Formula:

if(oct[0]>250)then

120

else

oct[0]-130

endif

0 Replies