Help

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

View by specific SQL :)

Topic Labels: Views
276 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

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

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: