Oh boy I hope you are ready for a little messy and something we have been patching together as we progress.
The [Billing Summarized] field is created by a long bulky formula to summarize all of the potential billing fields that get entered. It looks like this (only longer):
If([Physical Therapy Evaluation-Low Complexity Billing]!="",[Physical Therapy Evaluation-Low Complexity Billing] & "\n","")&
If([Physical Therapy Evaluation-Moderate Complexity Billing]!="",[Physical Therapy Evaluation-Moderate Complexity Billing] & "\n","")&
If([Physical Therapy Evaluation-High Complexity Billing]!="",[Physical Therapy Evaluation-High Complexity Billing] & "\n","")&
If([Physical Therapy Re-evaluation Billing]!="",[Physical Therapy Re-evaluation Billing] & "\n","")&
If([Therapeutic Exercise Billing]!="",[Therapeutic Exercise Billing] & "\n","")&
If([Neuromuscular Reeducation Billing]!="",[Neuromuscular Reeducation Billing] & "\n","")&
If([Therapeutic Activity Billing]!="",[Therapeutic Activity Billing] & "\n","")&
If([Gait Training Billing]!="",[Gait Training Billing] & "\n","")&
If([Manual Therapy Billing]!="",[Manual Therapy Billing] & "\n","")&
The fields above are generated from other fields as well that look like this:
If([Physical Therapy Evaluation-Low Complexity Units]>=1, "97161 Physical Therapy Evaluation-Low Complexity " & [Physical Therapy Evaluation-Low Complexity Units] & " Unit")
You can see I have the actual individual fields already. The issue is that when we map them with the API there cannot be blanks. There can be up to 6 lines total on a claim. So I ultimately need to translate whatever gets billed to Claim 1, Claim 2, Claim 3, Claim 4 etc and we need it to only be the code and the units billed example:
97110 Therapeutic Exercise 1 Unit(s)
Claim Code 1: 97110
Claim Code 1 Units: 1
------------------------------
Joseph Mahon
------------------------------
