Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5387 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Looking for a little help on how to approach this. I have a field that automatically generates the age of a person based on their date of birth. What I'm trying to figure out is how to generate a string of text on the condition that said person is over 18 and then place the string of text into a field before their full name.

The text string would consist of the parent's name (located in another field), the text "A/N/F of" and then the child's first name, middle name (if they have one) and last name. So the end result if the child is a minor would be " John Smith A/N/F of Jane D. Smith"

Any help would be appreciated.

Thanks

Posted

Create a new calc field, result text,

dsp_Minor=

if ( Age < 18, ParentFullName & " A/N/F of " & ChildFullName, "")

where ParentFullName and ChildFullName also calcs concatenating First and Last.

(at one point you say over 18, and later you say is a minor).

This topic is 5387 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.