Copy link to clipboard
Copied
Hello, i want to create an invoce.
I created fields with some values, A, B and C.
And simplified field notation (for example) for C is A+B.
Problem is here, when i copy all fields for next raw i still have same A + B = C, but i want a new one A1 + B1 = C1
How can i multiply all fields for 10 raws.
Thanks
Copy link to clipboard
Copied
And my fields also change names from A to A.0, ah god, its all mess here now...
Copy link to clipboard
Copied
Rename your fields to A1,B1,C1 and don't forget to change name of the fields in Simplified field notation also.
Copy link to clipboard
Copied
If your fields follow a consistent naming pattern then it should be possible to use a custom calculation script to automatically calculate the value of c.x based on the values of a.x and b.x, but it's not possible with the Simple Field Notation option.
Copy link to clipboard
Copied
Yes it is pattern. But how can i make that possible?
Copy link to clipboard
Copied
What are the exact names of the fields?
Copy link to clipboard
Copied
Fileds name are not important for me.
I ll show you this.
This red boxes i made in illustrator, just to make sure that i am good with space and everything.
Now, every horizontal line is for 1 article:
No, Name or article, unit, price, discount, price with discount, total ex VAT, vat, total included VAT.
And that i need to copy for about 20 products, and i need to write in formula for that. like if discount is 10, then price with discount is (price)-(price)*(discount)/100. And i need to do that for every single raw.
I hope that u understand me.
Copy link to clipboard
Copied
I do understand, but for the code the field names are crucial.
Copy link to clipboard
Copied
I think that i will do this in excel...
Copy link to clipboard
Copied
Cena sa rabom i iznos ti prikazuju istu cijenu?
Copy link to clipboard
Copied
Ne. Cena sa rabatom je cena sa popustom za jednu jedinicu, a iznos pokazuje izlaz (odnosno kolicinu)*cena sa rabatom. Samo ne znam kako da nastelujem imena da ih samo kopiram da ne bih pisao ponaosob za sve..
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more