Skip to main content
Solved

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

  • November 7, 2024
  • 0 replies
  • 555 views
Forum|alt.badge.img+5

Hello:

I have two fields that I want to merge for reporting purposes.

  • Application Status - Primary
  • Application Status - Secondary

I created a formula-text field named, Merge Primary/Secondary Application Status. 

I tried the formulas below, but none are working. Could someone assist me with tweaking any of my formulas, please?

First Try

If([Nursing]="",[Application Status - Primary Program],[Application Status - Secondary Program])

Second Try

If(
[Nursing]="Application Status - Primary Program",
[Nursing]="Application Status - Secondary Program"
,
true,
false,
)

Thank you,

Roula

Best answer by RoulaHabbal

Good morning, Mark.

I tried coping and pasting my details into this window, but I received the error below. I later learned the error is due to using lists, numbers, bullets!

Without organizing the data, it would be very difficult for anyone to follow.

I will try to work with the formula you gave me already.

Thank you,

Roula

MarkShnierYou
Forum|alt.badge.img+24

You can concatenate two fields together using the List function. 

 for example

List(", ", [Application Status - Primary], [Application Status - Secondary]);

That will separate the values (if both a re present) with a comma space.

 

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+5
  • RoulaHabbal
  • Author
  • Registered
  • November 7, 2024

Hi Mark:

Thank you for your quick reply. I appreciate it. 

I should have shared that I have Application Status - Primary and Secondary fields for many programs. Let's say the program name is Nursing. How would I include the program name in the formula you created?

List(", ", [Application Status - Primary], [Application Status - Secondary]);

Thank you,

Roula

 

MarkShnierYou
Forum|alt.badge.img+24

np,

[Program Name] & ": ", 

& 

List(", ",

IF([Application Status - Primary] <> "",  "Primary " & [Application Status - Primary],

IF([Application Status - Secondary] <> "",  "Secondary " & [Application Status - Secondary]))

 

Note that the separator can be any string including a vertical line feed. For example perhaps you want a vertical look and maybe you want  some bolding like this: (sorry the vertical spacing is too big on this Forum.

Nursing:

Primary: Wait listed

Secondary: Accepted

 

If you like you can give the exact format of how you want the results to appear and we can come up with a formula for that. 

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+5
  • RoulaHabbal
  • Author
  • Registered
  • November 7, 2024

Hi Mark:

Thank you. I am getting ready to leave for the day, and I am off on Friday. 

I will provide more detail on Monday morning so you can help me with the exact formula.

Thank you,

Roula Habbal

Terms & ConditionsAccessibility statement