Known Participant

Question

Text Field Properties How to write an IF formula

Forum|Forum|2 years ago
August 24, 2023
3 replies
951 views

Hello,

I would like to know if it is possible use Calculate to add text fields but leave them blank if they are not used. For example:

Using, say, an expenses form ... The first receipt total box will have data entered, then the running total. If the second and third etc. are not used then they should remain blank and not calculate anything. I have attached a picture, I hope what I'm saying makes sense.

I appreciate your time and help with this.

This topic has been closed for replies.

Community Expert

Community Expert

Read these two articles:

https://www.pdfscripting.com/public/How-to-write-an-If-statement.cfm

https://www.pdfscripting.com/public/How-to-Write-a-Basic-PDF-Calculation-Script.cfm

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

Community Expert

Community Expert

So you only want Total_2 to show a value if Total is not empty?

If so, you can do it using this code as the Calculation script of Total_2:

var total = this.getField("Total").valueAsString;

if (total=="") event.value = "";

else event.value = Number(total) + Number(this.getField("Amount 2").valueAsString);

Known Participant

Screenshot_2023-08-24_143308.png