Hi! I am trying to use JSON to bundle up data from one table and set of actions, and then move this data into a new row, or update a column through a relationship. Unfortunately the nicely formatted JSON from the Glide JSON columns gets turns into a basic text string when it lands! Is there something I am doing wrong? Or a way of turning it from text back into the jsonata queryable json?
Thanks!
An example
{
“responses”: {
“Q1”: {
“Question”: “What stops you listening to people? (max 3)”,
“User Response”: “Don’t care”,
“ite-advice 1”: “Dear Head of section, it seems you’re struggling with disillusionment, which is absurd given your vast knowledge and potential to lead. Apologies for harsh truths, but consider people as a resource, not a nuisance.\n\nFocus on enhancing empathy. FIT theory shows feedback increases performance when recipients focus on TASK, not self. The less you care, the less feedback you get, strangling improvement.\n\nWork on emotional intelligence. Data reveals EI is linked to transformational leadership which fosters high-performing teams.\n\nYour comfort in self-reflection is praiseworthy. Powers’ Control Theory emphasises importance of self-assessment in performance management.\n\nThus, tackle apathy with empathy, regulate self-boasting with emotional intelligence, and continue self-reflection. Remember, people are the fabric of your organization, caring for them bears fruitful results.”
},
“Q2”: {},
“Q3”: {},
“Q4”: {},
“Q5”: {},
“Q6”: {},
“Q7”: {},
“Q8”: {},
“Q9”: {},
“Q10”: {}
}
}
{“responses”:{“Q1”:{“Question”:“What stops you listening to people? (max 3)”,“User Response”:“Don’t care”,“ite-advice 1”:“Dear Head of section, it seems you’re struggling with disillusionment, which is absurd given your vast knowledge and potential to lead. Apologies for harsh truths, but consider people as a resource, not a nuisance.\n\nFocus on enhancing empathy. FIT theory shows feedback increases performance when recipients focus on TASK, not self. The less you care, the less feedback you get, strangling improvement.\n \nWork on emotional intelligence . Data reveals EI is linked to transformational leadership which fosters high-performing teams. \n\nYour comfort in self-reflection is praiseworthy. Powers’ Control Theory emphasises importance of self-assessment in performance management.\n\nThus, tackle apathy with empathy, regulate self-boasting with emotional intelligence, and continue self-reflection. Remember, people are the fabric of your organization, caring for them bears fruitful results.”},“Q2”:{},“Q3”:{},“Q4”:{},“Q5”:{},“Q6”:{},“Q7”:{},“Q8”:{},“Q9”:{},“Q10”:{}}}