Forum Discussion

RodCabanban's avatar
RodCabanban
Qrew Trainee
8 years ago

Need help with ""default"" text in Multi-Line text box when a Record is Added

I wanted to see if anyone can help me out with placing "default" text into a multi-line text field when a record is added/created. I can place 1 liner text, but I am needing the text in this format:

Some Text:
Another Text:
SomeOther Text:

My end goal is so that our reps have a "template" in our notes field (Multi Line Text) that will allow them to place certain data in those fields above.

Thanks in advance!
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Not tested but try this

    Make a formula text field called [Default text] with the formula.

    List("\n",
    "Line 1",
    "Line 2",
    "Line 3")

    Then use the road which says
    when my text field is blank
    change my text field to the value in the field [Default text]
    • RyanFarrington's avatar
      RyanFarrington
      Qrew Member
      6 years ago
      I needed to do exactly this and am happy to report the List() function method did work.

      ------------------------------
      Ryan Farrington
      Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
      rfarrington@experiencepinpoint.com
      ------------------------------
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    Another option is to break that field into 3 fields that ask those "questions" separately.  It makes the reporting easier, especially if one job function is only looking for the answer of part, but doesn't need it all.