Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

New Field Type: JSON

cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Walker
5 - Automation Enthusiast
5 - Automation Enthusiast

It would be great to have a field type specifically for JSON (not just Long Text fields).

This would allow us to store more complex structures of data inside a single table, including custom properties that we may not know ahead of time. (For example, if we have Users who are sending us custom properties & values that they come up with).

I recorded a quick video to walk through the feature:

Descript

Video for Airtable Feature – JSON Fields - Descript

By Michael Walker, October 5, 2022

Thank you,
Michael

3 Comments
ScottWorld
18 - Pluto
18 - Pluto

Airtable employees don’t visit us here too often, so I would recommend sending your video & your feature request to support@airtable.com.

In the meantime, you might get some benefit from using the JSON extension:

Or, you might enjoy the built-in JSON editor of On2Air Amplify:

Engjell_Sela
6 - Interface Innovator
6 - Interface Innovator

Hi @Michael.Walker :wave:

I’m building nocodebase.xyz and it almost does what you’re looking for, it clones your Airtable database and turns into a JSON API.

Using JSON has made it possible to do multiple filters directly from URL, completely without code.

I’m currently building an integration with a website builder so no-coders can use it, but if you know some code, the API is ready.

If anything, don’t hesistate to reach out either here or on email ( eengjellsela@gmail.com )

Thanks!

Karlstens
10 - Mercury
10 - Mercury

I see that either having the Long Text field supporting formats such as JSON or XML would be extremely useful. Or alternatively, having extra functions within a Formula Field to output stringified Long Text to JSON or XML could useful too.

As a side note, I construct my own JSON output formula fields, they usually look something like this;

 

'{"name":"'   			& {Spaceship Name} 	& '",' & 
'"technology":{' 	&
IF( OR({Chassis} = "No Chassis"	, {Chassis} = BLANK()), "",
  '"chassis":"' & {Chassis} 			& '"') &
IF( OR({Core} = "No Core"		, {Core} = BLANK()), "",
  ',"core":"' & {Core} 				& '"') &  
IF( OR({Engine} = "No Engine"	, {Engine} = BLANK()), "",
  ',"engine":"' & {Engine} 			& '"') &  
IF( OR({Shield} = "No Shields"	, {Shield} = BLANK()), "",
  ',"shield":"' & {Shield} 			& '"') &
IF( OR({Armour} = "No Armour"	, {Armour} = BLANK()), "",
  ',"armour":"' & {Armour} 			& '"') &
IF( OR({Module Array} = "No Weapons"	, {Module Array} = BLANK()), "",
  ',"weapons":[' & {JSON Weapons Array} & ']') &
'}}'

 

 But then I have to validate the output in an external application - so it would be great if we could somehow validate a calulated JSON within an Airtable formula field.