Pricing tables & IfThen formula help

[richardhall1982]

Hi

Very new to Espo, so very much still learning the ropes.

I'm looking to build in pricing for services under 'cases'. Ideally, I'd like some sort of lookup table, whereby we input the type of service, and the supplier and customer prices auto populate.

Any ideas on how to achieve that? I've seen the Sales Pack extension, but we don't need any other functionality - just the pricing for services provided.

As I couldn't fathom where to begin with a pricing table, I started exploring formulas to auto populate the fields instead, but am getting nowhere. Here's what I've tried:

ifThen(
type == UFPLS, estCaseFee == '200'
);​​

Where am I going wrong?

Thanks.

[rabii]

it should be like below

if (type == 'UFPLS') {
    estCaseFee = 200;
}​