Result

[workshop]

I have 5 fields a b c d e and F.
b is containe YES or NO
c is number validation auto generate start with 00001
d is contained DOG, CAT, or CHICKEN
e is contained Number of animals
f is contained LIVE, DEATH, or SICK

in a I lke to have result like this:
- if b is YES then enter Y00001
- if b is YES and d is DOG then in a is Y0001D
- if b is YES, d is DOG and e is 2 then in a is Y00001D2
- if b is YES, d is DOG, e is 2, and f is SICK then in a is Y00001D2S

Please help I haven't done this before... Thanks in advance

 

[Schlogg]

I'm using upper case for your field names.
Make A a calculation field as follows -
Case(B = "YES", "Y" & C & left(D,1) & numtotext(E) & left(F,1),
B = "NO", "&quot Cheers,
Paul J.

 

[workshop]

Hi Schlogg,
Thanks your respond I try your sugest but it's not work... Here my real situation:
field1 is INSTITUTION: University or Work
field2 is RECCORD NUNBER: auto number start from 00001
field3 is TISSUE TYPE: Tumor, lymph node,..
field4 is NUMBER SAMPLING: 1, 2, 3, or 4
field5 is SPECIMENT TYPE: Carcinoma, Invasive, or Rare
field6 is result:
example: 1: University, 2: 00001, 3: Lymph node, 4: 2, 5: Invasive then in field6 would be: U00001L2I

I just start to learn about filemakerPro but this to complicate for me would you please help me

 

[workshop]

Hi schlogg, I have try this but it said too few )?

here what I try:
case(left(Institution)&(Reccord number)&left(tissue type)&(number sampling)&left(speciment type)

please help

 

[JeanW]

You have to 'close' the case statement :
To have a better view, use cariage returns :

case(
left(Institution)&
(Reccord number)&
left(tissue type)&
(number sampling)&
left(speciment type)
)

HTH

John

 

[workshop]

I finally got it work but not complete... How do I keep the reccord number in whole like 00001 instead 1... my reccord number is auto serial


Left(Institution,1)&Reccord number&Left(Tissue type,1) & number sampling&Left(Speciment type,1)&"-" & Left(Lesion pancreatic,2 )

 

[Schlogg]

For numbers -
Right("0000" & numtotext(NUM), 5)
To avoid the need to use numtotext, define your serial as text. Cheers,
Paul J.