Hello EspoCRM Developers,
I have a text field in which JSON data is stored. The data is structured like this:
{
"employee": {
"name": "sonoo",
"salary": 56000,
"married": true
}
}
I would like to know if there's a way to use the json\retrieve function in a formula to extract the name, salary, and married values from this JSON and save them to their respective fields within the same record.
Note: The JSON data is stored in the text field of the same record.
Thank you for your assistance!
I have a text field in which JSON data is stored. The data is structured like this:
{
"employee": {
"name": "sonoo",
"salary": 56000,
"married": true
}
}
I would like to know if there's a way to use the json\retrieve function in a formula to extract the name, salary, and married values from this JSON and save them to their respective fields within the same record.
Note: The JSON data is stored in the text field of the same record.
Thank you for your assistance!
Comment