Skip to main content

View by specific SQL :)

  • May 16, 2021
  • 3 replies
  • 37 views
D

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

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • May 16, 2021

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

E
E
Forum|alt.badge.img+15

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

ScottWorld
D

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:

Terms & ConditionsAccessibility statement