Skip to main content
Solved

Formula with formatting for cemetery database

  • April 28, 2022
  • 2 replies
  • 73 views
S
Forum|alt.badge.img+4

I have created this database to catalog those buried in a cemetery. I understand that I can’t use formatting in a formula–unfortunately. In a perfect world, I need to format “short name” in quotes (or bolding) and “maiden name” in italics. Could any of the experts suggest a different approach if indeed formatting is not available in formulas?

Thanks,
Sam

paynegap.info

Best answer by Samuel_Duncan

Thanks John. Final and successful formula:

{First Name} & " " & IF({Short Name}," \\"") & {Short Name} & IF({Short Name},"\\" ") & {Middle Name} & " " & IF({Maiden Name}," [") & {Maiden Name} & IF({Maiden Name},"] ") & {Last Name} & " " & {Suffix} &("(")&DATETIME_FORMAT({Birth Date},"YYYY")&("-")&DATETIME_FORMAT({Death Date},"YYYY")&(")")

2 replies

J
  • John_Reid
  • Participating Frequently
  • April 28, 2022

Hey Sam,

Adding quotes is possible in a formula field, for your field, something like the below could be added.

IF({Short Name},"\\" ","")

When adding quotes you need to add a ‘’ before so that the formula knows to treat the quote as a string.

So your formula would look like this (apologies, I didn’t write out the whole formula but you get the idea):

{First Name} & " " & IF({Short Name}," \\"","") & {Short Name} & IF({Short Name},"\\" ","") & {Middle Name} & " " & {Last Name} & " " & Suffix

You can see this in the base, I duplicated it here.

As far as I know, it isn’t possible to make words bold or italics in formulas.

Hope this helps!
John

S
Forum|alt.badge.img+4
  • Samuel_Duncan
  • Author
  • Inspiring
  • Answer
  • April 28, 2022

Thanks John. Final and successful formula:

{First Name} & " " & IF({Short Name}," \\"") & {Short Name} & IF({Short Name},"\\" ") & {Middle Name} & " " & IF({Maiden Name}," [") & {Maiden Name} & IF({Maiden Name},"] ") & {Last Name} & " " & {Suffix} &("(")&DATETIME_FORMAT({Birth Date},"YYYY")&("-")&DATETIME_FORMAT({Death Date},"YYYY")&(")")

Terms & ConditionsAccessibility statement