May 16, 2021 05:34 AM
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.
May 16, 2021 08:37 AM
You can’t create a view like that, but you might be able to use this SQL app to display the matching results:
May 17, 2021 12:18 PM
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: firstname.lastname@example.org
May 17, 2021 12:44 PM
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: