I am trying to create a calculated formula field for one of my reports. It needs to place the "subtask name" in the report based on the subtask field.

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

I have several different subtask fields. The beginning part of my formula works, but after the first condition nothing else works. 

Here is the beginning of my formula: 

Case ([Administrative Subtasks], "Travel Time", "Travel Time", "Desk Time", "Desk Time", "Personal Appt", "Personal Appt",

I need this to work for all ["" subtasks].

It does not seem to accept any other part of the formula.

Photo of Becky

Becky

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Can you explain more what you are trying to do?  Can you give an example using some real data in your app?
Photo of Becky

Becky

  • 0 Points
Here is a screenshot from my report. As you can see the Subtasks field is my calculated formula. The subtask "Travel Time" is correct for the "Administrative" Task. However, the subtasks under the other tasks are not working. I cannot create more than one calculated formula field, so I tried to put all of the conditions in one formula.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
I see a report with 4 records on it.  Can you tell me the result that you want to see "Calculated"  for each of those 4 records?
Photo of Becky

Becky

  • 0 Points
Administrative should say Travel Time (this part of the formula works)
CAHPS should say Data Entry
Employer Groups should say Employer Group Client Meetings
Professional Management should say Attend Training.

I could give you my entire formula, but it is very long. Let me know. Thank you.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Is this want you want?  I doubt it but I still do not think that I am understanding your real question.

Case ([Administrative Subtasks],
"Administrative", "Travel Time",
"CAHPS", "Data Entry",
"Employer Groups", "Employer Group Client Meetings",
"Professional Management", "Attend Training")
Photo of Becky

Becky

  • 0 Points
Each subtask has a list of tasks. My app goes like this. The "Task" field is a multi-choice list of tasks. When a task is chosen from that list, the "Subtask" fields (based on rules in the form) shows only the subtasks for the chosen task, in another multi-choice list. I do not want my report to be so wide, by choosing the fields of subtasks to show, so I wanted to create a formula field to represent this.

Attached is the entire formula. There are no errors with the formula, according to QB, but it is not performing.

Let me know if you would like any other screenshots.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
My goodness.  That was a lot of typing for no reason.  

I think that what you are saying is that you have a record with about a dozen or so multiple choice fields which you call your SubTasks.  You want any nonm blank data entry into these doxzen or so fields concatenated into one field.  

The List function describe here will separate non null text fields with a delimiter.

https://www.quickbase.com/db/6ewwzuuj?a=dr&r=e2&rl=bad


So I think what you want is this
List(", ",
[Administrative Subtasks],
[CAHPS Activities Subtasks],
[Case Management Subtasks],
[Committee Meetings Subtasks],
[Compliance Activities and Work Plan Subtasks],
[Department Admin Support Subtasks],
[Employer Group Reports Subtasks],
[HEDIS Activities Subtasks],
[Internal Meetings Subtasks],
[Marketing and Sales Activities Subtasks],
[NCQA Activities Subtasks],
[Performance Management Subtasks],
[Professional Management Subtasks],
[Program Development Subtasks],
[Project and RIE Management Subtasks],
[PTO Subtasks],
[QI Work Plan Subtasks],
[Quality of Care Concerns Subtasks],
[STARS Activities Subtasks],
[Time Tracking Subtasks],
[Training Subtasks],
[Utilization Management Subtasks],
[Vendor Management Subtasks])

Paste that into a field and let me know if that is what you are after.  if it is, please double check that I did not miss any of your data entry SubTask fields.
Photo of Becky

Becky

  • 0 Points
Unfortunately, that did not work. This gave me the long list of subtasks as a result, instead of the subtask that was chosen in the subtask field. I must be overthinking this somehow. I don't know how to further explain it, or show you. I'm sorry, I am new to QB and this is complicating to me. I have searched all over for help and the QB language is somewhat still foreign to me. I just don't seem to be finding what I need. I don't know where to go from here.
Photo of Becky

Becky

  • 0 Points
Actually, it did work! I missed one thing in your explanation. I GOT IT!! Thank you so very much!!!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Great!, At first QuickBase will be very different from Excel, but soon the light bulb will turn on and you will suddenly "get it".  Feel free to post back with questions if you get stuck.
Photo of Becky

Becky

  • 0 Points
I have seen a lot of light bulbs, lol! Thank you again for your help. This is amazing!!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Thx for the warning.  I will put in my sunglasses now to avoid blindless
Photo of Becky

Becky

  • 0 Points
:)
Photo of Becky

Becky

  • 0 Points
I should also thank you for reading through my "garbage" to find the problem and solve it for me. I am sure it was just as confusing for you as it was for me. I guess that is why you are the expert!! Maybe someday I will be as smart as you! :smile:
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Thx.  I've been working with QuickBase and answering questions here since 2002 so I developed a skill for reading between the lines.