View by specific SQL :)

[Daniel_Roziecki]

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?

[ScottWorld]

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

Airtable

SQL Console - Apps - Airtable Marketplace

Query Airtable with all the power of SQL. on Airtable with the SQL Console app.

[Eric_Goldman1]

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: eric@syncinc.so

[Daniel_Roziecki]

Hi,

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: