Script to change calculation formulas

[Femca]

Hello everyone

We have a big database including information about father, mother, grandparents and siblings. We use scripts to create fields by calculations.

These calculations are the same for the father, mother, grandparents and so on...except for the referenced fields, which are different:

eg: to create a field 'Sudden_death_father' we use for the father:

If (Position ( quest2::E6 ; "5" ; 1 ; 1); "Yes"; "No")

(In question E6, if people filled in answer 5 then there is sudden death)

For the mother it would be:'Sudden_death_mother'

If (Position ( quest2::E6_2 ; "5" ; 1 ; 1); "Yes"; "No")

For a grandparent:

If (Position ( quest2::E6_3 ; "5" ; 1 ; 1); "Yes"; "No") and so on

Is there a possibility to just make a script which changes the referenced field for the different familymembers?

eg 'Sudden_death_x': If (Position ( quest2::y ; "5" ; 1 ; 1); "Yes"; "No")

Can we make a script like:

if 'x' = father then 'y' in the formula must be E6

if 'x' = mother then 'y' in the formula must be E6_2

It would be easier then copy all of our formulas and make changes manually!It would save us a lot of work if it would be possible.

Hope you can help us

Thanks

[mr_vodka]

From what you have posted, it seems to me like you have a structural issue. You should look into having individual related records.

[Femca]

We'll try to look into that!

Thanks

Femca