Automatic amount in opportunity

Automatic amount in opportunity

Hi,

In the opportunities, we fill  in a rebate. As the opportunity is linked to a product, is it possible in the form editor to have basically
opportunity.amount = product.price - opportunity.rebate.

I found that I can add a formula custom filed but :
1. I cannot find how to fetch the product's price
2. I'm not sure that the resulting value can be written to opportunity.amount. Maybe I'm not using the right tool?



On an unrelated note, we're looking for a freelancer proficient in Zoho (not only CRM, but also Books, Flow, etc.). French language a plus. Can I post the announcement here,  or is there a better-suited place?