Forum Discussion

AdamHollman's avatar
AdamHollman
Qrew Trainee
5 years ago

Intro & Queries - Warner Bros. International TV Production

Hello everyone. We have recently signed up with Quickbase to offer the platform as a online production tool for our 15+ production companies around the world. All our producers enter in all product...
App builders
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
np, try this

var text LastEntry = Left([Logging at the top],"\n");

Trim(Right($Last Entry, "]))

That should packman gobble form the right up to the first ].  The trim gets rid of any extra white space (blanks).

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
AdamHollman's avatar
AdamHollman
Qrew Trainee
5 years ago

My apologies I received a syntax error on that one. I copied in the total formula and there was an error on the logging at the top part, and the ($Last Entry part, and then the last "])) part.

Thanks again.

 

var text LastEntry = Left([Logging at the top],"\n");

Trim(Right($Last Entry, "]))



------Original Message------

np, try this

var text LastEntry = Left([Logging at the top],"\n");

Trim(Right($Last Entry, "]))

That should packman gobble form the right up to the first ].  The trim gets rid of any extra white space (blanks).

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • AdamHollman's avatar
    AdamHollman
    Qrew Trainee
    5 years ago

    Mark – many thanks once again

     



    ------Original Message------

    Its always best to post the complete error message along with your actual code to help us debug.

    But I can see that there was a mismatched quote on the last line


    Trim(Right($Last Entry, "]"))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    Its always best to post the complete error message along with your actual code to help us debug.

    But I can see that there was a mismatched quote on the last line


    Trim(Right($Last Entry, "]"))

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