Hi,
I'm working on an order form and I have some scripting that I can't figure out how to make work. I need to be able to have a customer choose per item from 1-4 colors, enter a quantity, and then based on the number of colors chosen and the quantity ordered, have the form auto-populate with the correct price points (price points change based on the number of items ordered AND the number of colors). For example, they could choose:
1 color, less than 500 qty = price 1
1 color, between 500 and 1,000 qty = price 2
1 color more than 2500 qty = price 3
2 color, less than 500 qty = price 4
2 color, between 500 and 1000 qty = price 5
2 color more than 2500 = price 6
etc., etc. up to 4 colors. I can get the form to work when it's just 1 color using a script like this:
var v1 = +getField("qtyWhite_1").value; if (v1 < 500) event.value = 2.30;if (v1 >= 500 && v1 < 1000) event.value=2.25;if (v1 >= 2500) event.value = 2.20;
But I can't figure out how to make it work if the customer chooses 2, 3 or 4 colors of the same item and have that reflect in the unit price. Any advice? The fields I have to work with are "Quantity", "1 Color", "2 Color", "3 Color", "4 Color", "Unit Price", and "Total". Do I need rearrange the fields and/or combine the colors to make this work?
Thanks
Multi value, multiple options - how to auto-populate?
2011-10-17 13:18:08
My Product Information:
Acrobat Pro 9.4.3, Macintosh
Acrobat Pro 9.4.3, Macintosh
2011-10-18 07:09:31
#2
I can set up the color selection to happen in whatever way lends itself best to the form, but right now it's set up as a drop down menu.
2011-10-18 08:26:25
#3
So you need to do a two-tier system, first check the color selection, and then inside of each option you do another check for the quantity. So it will look something like this:
var colorSelection = this.getField("Color").value;
if (colorSelection=="1") {
// do the checks for the first color
} else if (colorSelection=="2") {
// do the checks for the second color
}
etc.
var colorSelection = this.getField("Color").value;
if (colorSelection=="1") {
// do the checks for the first color
} else if (colorSelection=="2") {
// do the checks for the second color
}
etc.
2011-10-18 08:43:48
#4
That makes sense, thanks. Since I'm still new to javascripting, where exactly would I place the code to check the quantity and subsequent pricing for each color, after "if (colorSelection=="1")"?
Thanks for your help!
Thanks for your help!
2011-10-18 08:47:36
#5
Yes, inside the curly brackets after the if-statement. I've used the values "1", "2", etc. as an example. You need to adjust them to the actual values of your combo-box, of course.
2011-10-18 09:08:13
#6
I must be missing something yet, this is what I have so far, but it's not working yet:
var colorSelection = this.getField("Colors").value;
if (colorSelection=="One Color") { if (v1 < 500) event.value = 2.30;if (v1 >= 500 && v1 < 1000) event.value=2.25;if (v1 >= 2500) event.value = 2.20;//
} else if (colorSelection=="Two Colors") {
// if (v1 < 500) event.value = 2.40;if (v1 >= 500 && v1 < 1000) event.value=2.35;if (v1 >= 2500) event.value = 2.30;
}
Where did I go wrong?
var colorSelection = this.getField("Colors").value;
if (colorSelection=="One Color") { if (v1 < 500) event.value = 2.30;if (v1 >= 500 && v1 < 1000) event.value=2.25;if (v1 >= 2500) event.value = 2.20;//
} else if (colorSelection=="Two Colors") {
// if (v1 < 500) event.value = 2.40;if (v1 >= 500 && v1 < 1000) event.value=2.35;if (v1 >= 2500) event.value = 2.30;
}
Where did I go wrong?
2011-10-18 09:09:53
#7
The "//" marks the start of a comment, so the text in that line will not be executed. You need to remove those symbols from your code.
Also, be more specific. Doesn't work *how*? Are there error messages in the JS console?
Also, be more specific. Doesn't work *how*? Are there error messages in the JS console?
2011-10-18 09:15:59
#8
It doesn't work as in when I choose a color, and plug in a quantity, nothing appears in the unit price field. All that changes is my "Colors" field, which is changing from one color to say 2.3 (or 2.4 depending on if I chose one color or two). No error messages on the JS console.
2011-10-18 09:19:51
#9
Strike that, I got it to work a bit more, but it's only pulling up the first pricing option for each color choice, I can't get it to auto-populate with the lower price points as the quantities increase. It's almost there! :-)
2011-10-18 09:24:27
#10
Post your full code, please.
2011-10-18 09:43:38
#11
Here is the full code that is applied to my "unit Price" field. I've only done the first two colors right now until I get those working, then I'll add the additional 2:
var colorSelection = this.getField("Colors").value;
if (colorSelection=="One Color") { if (v1 < 500) event.value = 2.30;if (v1 >= 500 && v1 < 1000) event.value=2.25;if (v1 >= 2500) event.value = 2.20;
} else if (colorSelection=="Two Colors") {
if (v1 < 500) event.value = 2.40;if (v1 >= 500 && v1 < 1000) event.value=2.35;if (v1 >= 2500) event.value = 2.30;
}
var colorSelection = this.getField("Colors").value;
if (colorSelection=="One Color") { if (v1 < 500) event.value = 2.30;if (v1 >= 500 && v1 < 1000) event.value=2.25;if (v1 >= 2500) event.value = 2.20;
} else if (colorSelection=="Two Colors") {
if (v1 < 500) event.value = 2.40;if (v1 >= 500 && v1 < 1000) event.value=2.35;if (v1 >= 2500) event.value = 2.30;
}
2011-10-18 09:47:01
#12
Where are you defining "v1"?
2011-10-18 09:57:50
#13
Ahh....perhaps that is the problem, I missed that step. Do I write that "v1" = a drop down choice from my "Colors" Field, like this:
var v1 = this.getField("Colors Dropdown_1").value;
var v1 = this.getField("Colors Dropdown_1").value;
2011-10-18 09:59:17
#14
I thought that was the "quantity" value... "Colors Dropdown_1" is probably the name of the field that corresponds with colorSelection.
2011-10-18 10:02:57
#15
No, the quantity value is a separate field not linked to the "Colors" field. If it's easier, I can just email you the actual PDF I'm working with?
2011-10-18 10:03:58
#16
Sure, no problem.
2011-10-18 10:15:58
#17
Just sent it - thanks again! :-)
- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com