Custom field returning a string of values | Community
Skip to main content
FrankatMSC
Level 4
July 24, 2025
Solved

Custom field returning a string of values

  • July 24, 2025
  • 1 reply
  • 339 views

I have a scenario that is returning a users name from a requests custom field.  On my form it stores just the name but the search module returns the string below.  I've looked at all the function Fusion offers but I can't see one that would allow me to parse just the ID. "
I've tried using variations of substring and spit.  Do I need to somehow store it in an array first?  Any suggestions will be greatly appreciated!1

        "value": [
            "{\"objCode\":\"USER\"",
            "\"name\":\"Kelly Powell\"",
            "\"ID\":\"61252bb0000eb57eae6652713ab41b15\"}"
        ]
   

 

Best answer by KristenS_WF

Try passing the value to a Parse JSON module.  All 3 of the items in your string would be text types in the data structure.  Once parsed, you should be able select the items individually.

 

 

 

 

1 reply

KristenS_WF
KristenS_WFAccepted solution
Level 6
July 24, 2025

Try passing the value to a Parse JSON module.  All 3 of the items in your string would be text types in the data structure.  Once parsed, you should be able select the items individually.

 

 

 

 

FrankatMSC
Level 4
July 24, 2025

Thank you @kristens_wf .  That was such a clean solution.  Here I was trying all mixes of functions trying to parse it, not realizing it was JSON.
I love how I learn something new about Fusion nearly everyday!!

 

Thanks again!!

KristenS_WF
Level 6
July 24, 2025

Happy to help!