Timestamp in rich text field

  • Timestamp in rich text field

    Posted by DSC Communities on September 18, 2020 at 6:30 am
    • Fabian Heil

      Member

      September 18, 2020 at 6:30 AM

      I“m trying to achieve, that you can enter a timestamp and user number in a comment field via button click. Heres how it looks like:
      By clicking the timestamp button, it adds the user number and timestamp to the field.Ā 


      The default value of the field is a variable “_htmlRemark”. And on the button, i concat the previous value with the timestamp.
      Set(_htmlRemark,Concatenate(dcvRemarkApproverCBR.Text,Left(Office365Users.MyProfileV2().userPrincipalName, Find(“@”, Office365Users.MyProfileV2().userPrincipalName)-1) & ” – ” & Text(Now(),”[$-de-DE]dd/mm/yyyy hh:mm”,”en-EN”) & “: “));

      When i save the form and open it again, it converts some characters and it looks like this.

      I tried with “Plaintext(_htmlRemark)” but it removes the “:” completely.

      Has someone ever done something similar and has an idea?

      ——————————
      Fabian Heil
      IT Consultant SharePoint Applications
      ——————————

    • Warren Belz

      Member

      September 19, 2020 at 5:25 PM

      HI Fabien,
      Try thisWith(
      {
      wUser: Microsoft365Users.MyProfileV2().userPrincipalName,
      wDate: Text(
      Now(),
      "[$-de-DE]dd/mm/yyyy hh:mm",
      "en-EN"
      )
      },
      Set(
      _htmlRemark,
      dcvRemarkApproverCBR.Text & Left(
      wUser,
      Find(
      "@",
      wUser
      ) - 1
      ) & " - " & wDate & ": "
      )
      )?

      Looks like this parsed

      ——————————
      Warren Belz
      Queensland Australia
      ——————————
      ——————————————-

    DSC Communities replied 4 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Timestamp in rich text field’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!