View by specific SQL :)

Topic Labels: Views
900 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I need to create a view similar to this SQL question:

select name, max(date) from xxx group by name;

I have no idea how I can do this with airtable.

Any help?

3 Replies 3

You can’t create a view like that, but you might be able to use this SQL app to display the matching results:

7 - App Architect
7 - App Architect

Thanks for the shout out @ScottWorld :pray:

@Daniel_Roziecki – we built the SQL Console app. Would love to make sure you get set up properly. Feel free to send us a quick DM or email me directly if you need anything:


Thanks, this is a great tool, but I need some smart views for automations, and sadly this is not a solution for me.

Airtable is great, but sometimes I need a lot of creativity to do some stuff :slightly_smiling_face: