Forum Discussion
MarkShnier__You
Qrew Legend
See if this works
var text UpToTheTwo = Part([Body],2, ")");
var text AfterTheColon = NotLeft($UpToTheTwo,":");
Left(Trim($AfterTheColon), " \n")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var text UpToTheTwo = Part([Body],2, ")");
var text AfterTheColon = NotLeft($UpToTheTwo,":");
Left(Trim($AfterTheColon), " \n")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
JohnKelley
2 years agoQrew Member
Thanks Mark! It worked like a charm to pull the ID ex. W123456789 but how about the next piece? lets say I want to pull the answer to the question "That the response you received was clear and easy to understand?:"
I have never worked with var text before so please excuse my lack of knowledge.
Thanks for your assistance!
------------------------------
John Kelley
------------------------------
I have never worked with var text before so please excuse my lack of knowledge.
Thanks for your assistance!
------------------------------
John Kelley
------------------------------
- MarkShnier__You2 years agoQrew Legendusing a formula variable such as
var text =
just allows you to store an intermediate calculation to break up the formula into small pieces which does not hurt your head so much or which allows you to temporarily change the formula to output an intermediate calculation for debugging purposes.
The parsing is done using function like
Left
Right
NotLeft
NotRight
Part.
The list of functions is here https://login.quickbase.com/db/6ewwzuuj?a=td
I can't really take the time to work out the formula for each of the other questions but basically you have to be creative about the parsing. If you would like some one on one time with me to try to get them all working feel free to contact me by email.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------