Skip to main content
Question

Extracting Parts Of Text

  • June 22, 2023
  • 0 replies
  • 70 views

Forum|alt.badge.img+5

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22

Can you explain how the [Billing Summarized] field is created.?  Is this a formula field?  Can you post the formula?   How many lines can there be in the summary?

Also is he goal to push a button and create child table records one per Billing Line?



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------