I have a formula text field that displays a summary of all billing fields. It combines the billing code, the description of the code, and how many units have been billed. We used to manually enter these into a 3rd party system, but we are building out an API and need to separate parts of each line into it's own field. It looks like this:
[Billing Summarized]:
97110 Therapeutic Exercise 1 Unit(s)
97112 Neuromuscular Reeducation 1 Unit(s)
97530 Therapeutic Activity 1 Unit(s)
97140 Manual Therapy 1 Unit(s)
With the above example I need:
[Line 1]:97110
[Line 1 Units]: 1
[Line 2]: 97112
[Line 2 Units]:1
[Line 3]:97530
[Line 3 Units]: 1
Etc
------------------------------
Joseph Mahon
------------------------------