Skip to main content
Solved

Is it possible to add JSON data or an array of objects into Airtable column?

  • June 24, 2022
  • 1 reply
  • 101 views

Hi there, I’m new to the Airtable.

I’m wondering if it’s possible to store JSON data in a cell ?

For example, if I have a User table, and inside this User table, I want to store an array of objects for every user about the videos the user has watched.

Is it possible ? :thinking: :thinking:

e.g.
Can I store the data ( similar to the code below) in a cell ?

{
data:[
{videoId: 1, videoTitle:"some thing", videoDescription:"some text"},
{videoId: 2, videoTitle:"some title", videoDescription:"some text"},
{videoId: 3, videoTitle:"some other title", videoDescription:"some text"},
{videoId: 4, videoTitle:"fourth title", videoDescription:"some text"}
]
}

What’s the easiest way to create this relationship ?
Do I have to create another Video table? :thinking:

Any suggestions ? THANK YOU !!

Scenario:
e.g. User Amy watched video#1, video#2, video#3, and video#5
e.g. User Bob watched video#1, video#4, video#5
( I have a total of 100 videos )

Best answer by ScottWorld

Sure, create a long text field, and you can paste JSON into that field.

You can also use an app like JSON Editor or On2Air: Amplify to give you a full JSON editor to work with the contents of that field.

View original
Did this topic help you find an answer to your question?

1 reply

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8792 replies
  • Answer
  • June 24, 2022

Sure, create a long text field, and you can paste JSON into that field.

You can also use an app like JSON Editor or On2Air: Amplify to give you a full JSON editor to work with the contents of that field.


Reply