Custom field returning a string of values | Community
Skip to main content
FrankatMSC
New Participant
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
New Participant
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
New Participant
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
New Participant
July 24, 2025

Happy to help!