# Crystal Quote Form

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-02-06 15:00 UTC
**Views:** 302
**Replies:** 0
**URL:** https://www.epiusers.help/t/crystal-quote-form/2163

---

## Post #1 by @system

<div id="ygrps-yiv-411681721">Good Afternoon,<br/>
<br/>
I am on V4.0 and have customized the quote form to allow us to add an<br/>
additional unit of measure pricing field. We use the standard Vantage<br/>
quantity and Unit price field for sheet price or a Linear Foot price but<br/>
most of our customers also like to see a price per thousand square<br/>
inches(MSI). I have created a VBForm in the Quote Detail screen that has a<br/>
field for up to five thousand square inch prices for different quantities.<br/>
The fields are called QDMSIPR, QDMSIPR2, QDMSIPR3, QDMSIPR4 and QDMSIPR5. If<br/>
there is just one quoted quantity you plug in the unit price, open the<br/>
VBForm and plug in the thousand square inch price in the first field<br/>
&quot;QDMSIPR1&quot; and it will print on the quote form directly beneath the standard<br/>
Vantage unit price field. My problem begins when there are multiple<br/>
quantities for the same line. I cannot get the form to pick up the values<br/>
from the next four fields of the VBForm, QDMSIPR2, QDMSIPR3, QDMSIPR4 and<br/>
QDMSIPR5. The standard Vantage Unit Price prints correctly but the MSI price<br/>
will not. I currently use the following formula:<br/>
<br/>
if {quoteqty.QTYNUM} = &#39;  1&#39; then {quotedtl.QDMSIPR} else if<br/>
{quoteqty.QTYNUM} = &#39;  2&#39; then {quotedtl.QDMSIPR2} else if {quoteqty.QTYNUM}<br/>
= &#39;  3&#39; then {quotedtl.QDMSIPR3} else if {quoteqty.QTYNUM} = &#39;  4&#39; then<br/>
{quotedtl.QDMSIPR4} else if {quoteqty.QTYNUM} = &#39;  5&#39; then<br/>
{quotedtl.QDMSIPR5} else 0<br/>
<br/>
Can anyone help me with the correct formula to make this happen?<br/>
<br/>
Thanks in Advance<br/>
Todd Hofert<br/>
Spartan Graphics, Inc.<br/>
(616)887-8243</div>

---


**Canonical:** https://www.epiusers.help/t/crystal-quote-form/2163
**Original content:** https://www.epiusers.help/t/crystal-quote-form/2163