Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Find more inspiration, events, and resources on the new Adobe Community
Explore Now