Skip to main content

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 ? 🤔 🤔


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? 🤔


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 )

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