This is the scenario its a bit of a mess but I was experimenting to try and sort out the multi line text variable to be usable with some custom javascript code.
The db module is being retrieved basically using a key value and that is working correctly, I’ve tried parsing to json the multi line/long string and not doing and in debug modes it keeps appearing as empty still so it doesn’t work. However as mentioned there is a value in the database, that looks similar to this:
[{"answer":"[REDACTED]","position":0,"question":"Telephone"},{"answer":"web","position":1,"question":"Your business website (if you don't have one please type no website). "},{"answer":"$20,000 to $50,000","position":2,"question":"From your business, what is the range of your monthly income? "},{"answer":"[REDACTED]","position":3,"question":"What's your monthly income goal?"},{"answer":"[REDACTED]","position":4,"question":"What’s the #1 biggest obstacle holding you back from hitting your revenue goal? (don’t skip this part, we need to know as much as possible to help you best)"},{"answer":"Yes, of course!","position":5,"question":"Have you got a working funnel setup?"},{"answer":"[REDACTED]","position":6,"question":"Have you used Facebook ads before? If so, what was your experience?"},{"answer":"Absolutely! I have the means and I'm ready to take things to the next level.","position":7,"question":"Are you at a stage where investing in your business is a possibility?"},{"answer":"Without a doubt! I'm all in with my business, ready to invest and grow quickly.","position":8,"question":"If I were to advise a monthly ad budget of at least $500 to meet your financial goals, would you say:"},{"answer":"I recognize that if I don't have a funnel in place, there might be costs involved in repairing or constructing it, to ensure that we can direct traffic to it.","position":9,"question":"Final note:"}]
I replaced personal info with redacted.
This data was originally from a calendly form and the questions I converted to a json string so it could be stored in the data storage because I had issues whenever I tried to store it as an array or anything else.
So now I’m trying to retrieve the above example that is stored as a long string and it keeps saying it’s empty when it isn’t.