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


Terms & Conditions