Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do I extract data from a dictionary data type?

Topic Labels: Formulas
140 0
Showing results for 
Search instead for 
Did you mean: 

I have a field with the following data:
{“blog”:“abc dot com”, “twitter”:“xyz dot com”, “facebook”:“pqr dot com”}

I want to use the “keys”, viz, blog, twitter and facebook to extract abc dot com, xyz dot com and pqr dot com respectively.

So if I have the key “blog” in a formula, I want to store the corresponding data ie “abc dot com”. Any ideas how to do this?

0 Replies 0