New calculated data expression FORMAT() | Community
Skip to main content
lgaertner
lgaertner
Level 9
March 26, 2025

New calculated data expression FORMAT()

  • March 26, 2025
  • 3 replies
  • 811 views

Hello Community,

 

I was wondering, how to use the new calculated data expression FORMAT(), which is documented here. and was released with the 2025 Q1 update. 


Firstly, it is not clear to me from the documentation which parameter should correspond to the input and secondly, I cannot find the command in the editor for calculated fields, as it is not listed there.

I can add the example FORMAT($$POSITIVE, $$BOLD, $$ITALIC) to a calculated field and see 

Calculation result:  {"color":"$$POSITIVE","decorations":["$$BOLD","$$ITALIC"]}

in the preview, but I do not really understand the use of it, without having the possibility to pass an input parameter.


Maybe I'm just having a problem, so I would be grateful for any advice.

Thanks in advance.


Regards
Lars

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    Sven-iX
    Community Advisor
    Sven-iXCommunity Advisor
    Community Advisor
    March 26, 2025

    completely fails for me - I get N/A and the expression is not listed in the UI... 

      Q
      Adobe Employee
      QuinnCullisonAdobe Employee
      Adobe Employee
      March 26, 2025

      Hello Lars,

       

      Great question!
      The FORMAT option is actually meant to be used on field under the "Add Logic" menu. Once it's enabled on your system you should be seeing a "Formatting Logic" option in that menu and you would put the "FORMAT($$POSITIVE, $$BOLD, $$ITALIC)" in there to establish what you want it to do.

       

      I've talked with our team and I'll see about getting our documentation updated to mention this in more detail, thanks for letting us know!

        KellieGardner
        Community Advisor
        KellieGardnerCommunity Advisor
        Community Advisor
        March 26, 2025

        I'm currently in preview and not able to find anything related to formatting logic. There are only options for Display, Skip, and Validation.

         

         

          lgaertner
          lgaertnerAuthor
          Level 9
          March 27, 2025

          Hello,

           

          The Formatting logic option is not displayed for me either.

           

          @quinncullison What do you mean by "Once it's enabled on your system you should be seeing a "Formatting Logic" option"? Is it something which is not rolled out yet?

           

          Thanks in advance.

           

          Regards

          Lars

            kautuk_sahni
            Community Manager
            kautuk_sahniCommunity Manager
            Community Manager
            July 16, 2025

            @lgaertner Just checking in — were you able to resolve your issue?
            We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

            Kautuk Sahni
            Terms & ConditionsAccessibility statement

            Loading footer...