Discount Unit Price for customers, based on value list result

[Roxy201]

Hi Everyone,

I'm new to Filemaker, and am a little stuck on a something.

Can I create a script that will automatically discount a unit price by 50%, if the Customer is set to a certain value in a drop down list?

Thanks in advance,

R

[MarkWilson]

Welcome to the Forums!

With a script, use the Set Field script step.

Set Field [ DiscountPrice; BasePrice * Discount ]

A script may not be needed to perform the calculation. Try an auto-entered calculation with the (BasePrice * Discount) formula. Uncheck the 'Do not replace...'

[Roxy201]

Thank you for the reply and the warm welcome.

I will include that calculation in my script steps, but also what I am wondering is if the person I am invoicing can be invoiced at a discounted rate, depending on meeting criteria in a drop down list.

The discount is for people internally who buy advertising. So the drop down list indicates whether they are an organization member, or a client.

Maybe I can do this, and save half a minute of work for myself for the odd invoice that is for organization members!

[MarkWilson]

Attached is a sample file allowing you to do both calculations.

Price.zip

[Roxy201]

Thanks for that. Worked a treat!