Skip to main content
Participant
March 3, 2024
Question

Fillable PDF form Calculations

  • March 3, 2024
  • 1 reply
  • 410 views

Hello!

 

I need help with a fill form I created.

It's to be used as an order form for candles.

 

I have a "total" field and figured out how to calculate the unit cost x the quantity number but then, I also have a column of "testers" that the customer can choose to add to their order.

 

I've tried several different ways to be able to have the "total" field calculate those 2 fields but can't figure it out. Basically I need (unit x qty + (tester) qty)

 

Thanks. 

This topic has been closed for replies.

1 reply

Nesa Nurani
Community Expert
Community Expert
March 4, 2024

Did you try to use simplified field notation (SFN)?

In SFN you just enter field name: field1*field2+field3, if you have space character in your field name escape it with backslash like this "Unit cost1" write like this: Unit\ cost1.

If you have "sequential naming" of your fields: price1, price2, price3...etc you can use a custom calculation script in total field to loop over all fields and calculate price for each item and total with one script.