List command and record #

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

Is there a way to have the record number listed using the list or a similar command?  I guess what I'm asking, is, is there a way to list both text and numbers from a field using a formula command?

Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Can you give an example. I'm not understanding your question
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
My apologies.  That was a bit vague.  I'm trying to use the following in a formula-text field:  List ("\n", "Request #", [Record ID],  "Event Description",[Event Description], " ", "Request Sent To", [Provider - Name], " ", "Interpreters Assigned")

I'm assuming because Record ID is a numeric field, it's giving me an error.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Try this

List ("\n", "Request #", ToText([Record ID]),  "Event Description",[Event Description], " ", "Request Sent To", [Provider - Name], " ", "Interpreters Assigned")
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
Worked like a charm.  Thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
:)