Concatenate two fields one is a user the other field is a date field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

List(" _",[CUTOVER_STATUS],[CUTOVER_TRACKING_CALENDAR])

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,438 Points 50k badge 2x thumb
List("_", ToText([My Date field]), UserToName([My User field]))
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Thanks, what if I want to concatenate a field with a work for example
List("_",ToText(My Date field])," Pass")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,438 Points 50k badge 2x thumb
Sorry, can you give an example of the result you want?  The first parameter in the quotes is the separator, and then the rest of he values are what gets listed, separated by he separator.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Can you use a list with numeric fields