Hi everyone 👋
I’m importing data into Airtable, and one of the fields arrives as a JSON array that looks like this:
[
{ "key": "Label", "value": "Sample A" },
{ "key": "Code", "value": "0716" },
{ "key": "Category", "value": "Lotus" }
]
Instead of showing the raw JSON, I’d like the field to display something more readable, for example:
Label: Sample A
Code: 0716
Category: Lotus
I tried changing the field type and using simple formulas, but it still shows the full JSON array.
Has anyone done this before?
Is there a formula, script, or automation that can parse this JSON?
Any suggestions would be really helpful, thank you!
Â
