View by specific SQL :)

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?

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

1 Like

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:

1 Like


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 :slight_smile:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.