Forum Discussion

Curtis_M's avatar
Curtis_M
Qrew Cadet
5 years ago

Multi-Line Text into Email URL Button

Hi,

Here is what I am trying to build:

We have a list of stakeholders for each project. On each stakeholder record is their contact information. The goal is to have an email button on that record that redirects Project Leads to a communications log table/form when they want to email a stakeholder.

On this table/form, it will pull over the stakeholder's email address and provide a message box.
In the message box, the Project Lead will type what they want to communicate. These messages aren't intended to be complex.

There will then be a button they click that says "Confirm & Send" which pulls up a new email and brings over any pertinent information. The reason we want it to function like this is so we can have a log of communications associated with a project. We know they can modify the email after clicking the button, but it at least provides a general idea of what was communicated.

I have made a couple email buttons with no issues in the past. 
The issue and difference here is that I am trying to draw in a multi-line text field into the email and it isn't holding it's formatting.   Paragraph breaks convert over as one continuous line of text. I have confirmed with QB Care that this is a limitation.

Has anyone else run into this before and know of a possible work around?
Additionally, I am open to alternate solution proposals?

Thank you to anyone who has taken the time to read this and potentially help.


------------------------------
Regards,
Curtis Middleton
------------------------------
  • Are you emailing using the Mailto syntax?  Or via email Notifications.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Curtis_M's avatar
      Curtis_M
      Qrew Cadet
      Here is my code ([Testing Text Input] is the multi-line text field):

      var text Return = URLEncode("\n"); //variable used for return/space function in a body of text

      //////////////////////////////////////////////////

      "MailTo:" & URLEncode("Curtis Middleton")

      // the above text invokes the mail client, and creates the TO line

      & "&cc=" & URLEncode("") & "; "

      // the above text invokes the mail client, and creates the CC line

      & "&subject=Email To A Stakeholder"

      // the above text does the subject line, below that is the body

      &"&body=Hi User,"
      & $Return & $Return
      & [Testing Text Input]
      & $Return & $Return
      & "Regards,"
      & $Return
      & "Curtis"

      ------------------------------
      Curtis Middleton
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I did a test and by making this change

        & URLEncode([Testing Text Input])

        It worked for me on gmail webmail.


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