Help

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

Solved
Jump to Solution
6036 1
cancel
Showing results for 
Search instead for 
Did you mean: 
I_Love_Coding
4 - Data Explorer
4 - Data Explorer

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 )

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

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.