It is becuase if files in blank it counts that as not equal to 0 so does the calculation. try:if (files > 0) then      Sum(60/files) else $ = ""endif

To specifiy when to run the presence code you can use the Date2Num function. This will translate a date into a number and then you can say that when the Date2Num result is equal to the date you want then the presence will change.

You could do an if statement where if the field fails its validation the field becomes "" (blank) and validate.nullTest="error" (makes the field mandatory).

Sounds a bit complicated. I will find another way. Thanks for your help.

It is because you can't divide by zero which is what would be happening if one of the fields was empty so perhaps the calculation of the third box should be (in formcalc):if (NumericField1.isNull == 0 and NumericField2.isNull == 0) then    $ = NumericField1/NumericField2else $ = ""endifthis is sayin...

There is probably a fancier way of doing this but one way is to make the textbox the entire width of the form and make sure it is center aligned. That way no matter how long the string is that you enter it will always be centered.

transport. I need to use it to extract data from a database to prefill some fields in my form. Thanks.

Does anyone know if you can use Json to connect a database to a form in Livecycle?

what about using + for yes and - for no in your dropdown list? would that work for you?

the basic script (in formcalc) is:$ = Date2Num(endDate.formattedValue, "DD/MM/YYYY") - Date2Num(startDate.formattedValue,"DD/MM/YYYY") // the DD/MM/YYYY part should be whatever format you have set your date fields to.You put this script in the calculate field of the textbox. You may want to put in s...