* Displayin Flag In records Window

[Johnyeates]

Hi,
I have created Flags for each Family line and it would be usefull to be able to addthe flag to the Records Window (Individuals)
I can add each Family Flag, but this takes up several columns.
Is it possible to create a single column which will display which ever family line the individual is associated with?

Regards
John

ID:4839

[Jane]

You could build an expression, using TextIf and HasFlag and nest it for the number of flags you have.

[Johnyeates]

Thanks Jane,
I have almost got it working but am having a problem nesting the expressions, I can't quite get it right.
I can't find an example in the expressions manual.
Will you give me a hint please
Thanks
John

[Jane]

If you post what you have I'll look at it for you.

[Johnyeates]

Dear Jane,
This line works
=TextIf(HasFlag(%INDI%,'Yeates Line'),'Yeates')
It puts the text 'Yeates' against all the relations of the Yeates Family Line.

This Line does not work
=TextIf(HasFlag(%INDI%,'Yeates Line'),'Yeates') or =TextIf(HasFlag(%INDI%,'Akers Line'),'Akers')
Where I have used 'Or' to try to nest the expressions.

Where I am trying to 'Configure Columns' (in the Records Window (Individuals)) I only get a single line to write the expression, I can't wrap text.

Any help with the syntax would be appreciated.
Regards
John

[nsw]

I suspect you need to 'nest' your TextIF using the 'Else' part (3rd parameter) of the TextIf function - I'm no FH function/query expert but my Excel knowledge suggests:

=TextIf(HasFlag(%INDI%,'Yeates Line'),'Yeates',TextIf(HasFlag(%INDI%,'Akers Line'),'Akers'))

So if they have the 'Yeates Line' flag then it shows 'Yeates' otherwise it carries out the other TextIf function.

[Johnyeates]

Nick,
Thanks for that, it workrd perfectly and, with the aid of Ctrl C & V, I extended it to all seven family lines in no time. When you think that all I needed was a simple commer to make it work, such a silly syntax error that I would never have found.
Thanks again
Regards
John