Forum Discussion

MarkoKrajinovic's avatar
MarkoKrajinovic
Qrew Trainee
6 years ago

Formula to extract a part of text from one field to another.

Hi all, I want to extract a piece of information from one Rich Text field into a simple Text field, or multiple fields by using a formula. So, as an example, from [Intro] "Hi, my name is Marko, ...
Formulas and functions
JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
6 years ago
I have a great example, I'm not sure if this is something that Mark is specifically talking about -- but I have a Zapier webhook from a multi-choice field in a Gravity Form to deposit into a multi-line text field in QB.

The multi-choice field is set up for states, and so when it's deposited into my multi-line text field in QB it looks like this: "California, Hawaii, Minnesota, Washington"

I want to set up something that will separate those into their own text fields once I check a box, or once the entry is added, or something. The ultimate goal I have with this project is to be able to create a child entry for each of those "lines"

------------------------------
Jessica Adkins
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You can parse out the various pieces like this. into separate formula fields.

Trim(Part([my comma separated field],1,","))

then the next one would be

Trim(Part([my comma separated field],2,","))

Then you can have an Automation fire to
Step 1 delete any existing children.
Step 2 though 11, create say 10 records 
Step 12, delete any blank children.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------