Hi Gurus,

I have a quote table that has a status field with these drop down values:

Estimate

Opportunity

Under Client Review

Revised: Under Client Review

On Hold

Cancelled

ACCEPTED

PO Received

Deposit Received

I have a script that generates an invoice based on the quote and it's line items. I want to exit the script and show a custom dialog if one of the last three values (ACCEPTED, PO Received,

Deposit Received) is not showing as the status. How would you handle this?

Thank you for your help.

Create a calling script with a single If statement:

If(status = "ACCEPTED" or status = "PO Received" or status = "Deposit Received";

	 Perform Script["GenerateInvoice"];

	 Perform Script["ShowCustomDialog"]

)

All fine and good if you never change those value names - however, if you assigned a numeric value to values, then you can use the number for the comparison and accomplish the same goal.