document - calculation issue or something

Started by John Haber-Smith, March 23, 2011, 08:28:01 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

John Haber-Smith

I'm trying to set up a policy document integrating with TAM.

It requires the previous years certificate number to be shown. The part of the document is below:

Certificate Number:    SMT111/11/AHU/<CUST.INS.REC>  Renewal of: SMT111/10/AHU/<CUST.INS.REC>

My idea is to do an 'if' for the second part - if 'policy status' = 'REN' then subtract 1 from the number in table cell B2.

But that is where I'm stuck - any ideas on what the 'if' should look like?

Alternatively, is there a field where last years policy number will be held?

John Ansell & Partners Ltd
LONDON UK
TAM 12

Andrew Carrick

Not sure I can help directly with that but I wondered from the format of the policy number, is that "10" the year, and in that case can you do something with the Policy Effective Date instead? Maybe an If statement saying If Year = B1 then enter 10??
Jelf Insurance Partnership
Hull, East Yorkshire, UK
Me and TAM used to have a thing but we've split amicably. She got the kids, I got the Camaro and the maid.

Lance Bateman

Last year's policy number is not available.
What record type specifically are you trying to integrate - a certificate of insurance, the policy record, the app?  The problem with the certificate might be finding the specific one you want, if that's available even.

Quote from: johnhs on March 23, 2011, 08:28:01 AM
I'm trying to set up a policy document integrating with TAM.

It requires the previous years certificate number to be shown. The part of the document is below:

Certificate Number:    SMT111/11/AHU/<CUST.INS.REC>  Renewal of: SMT111/10/AHU/<CUST.INS.REC>

My idea is to do an 'if' for the second part - if 'policy status' = 'REN' then subtract 1 from the number in table cell B2.

But that is where I'm stuck - any ideas on what the 'if' should look like?

Alternatively, is there a field where last years policy number will be held?



John Haber-Smith

This is a word document I'm trying to create for customers.  I can pull data from all the usual fields plus the custom dec
John Ansell & Partners Ltd
LONDON UK
TAM 12

Hans Manhave

If you have a custom dec, add a field for the previous policy number.  That is how I addressed the situation.

This is operator dependent, but at least you have it and you have it as a straight field, no special handling.

I use it to link previous policies to current policies for Excel extractions.  One of the idiosyncracies of TAM being that it cares what the policy types are and doesn't link too many things together for research.

Then, while you are adding that additional field, add a few spare ones for the future.  It is very handy to have several empty fields waiting for use.  Doesn't matter if they are text or not, TAM doesn't really care, stores it as text anyway.
Fantasy is more important than knowledge, because knowledge has its boundaries - Albert Einstein