A modern, open-source spreadsheet that goes beyond the grid

Re:A modern, open-source spreadsheet that goes beyond the grid by smokefoot on Thursday November 02, 2023 @08:26AM (#38112548)

Can you do this in grist or Airtable?

Building join tables with calculated fields is a missing feature in all spreadsheet-like solutions as far as I know.

Also I concur with the parent that I often get frustrated by my inability to do spreadsheety things in these tools.

[ Parent | on HN ]

Re:A modern, open-source spreadsheet that goes beyond the grid by paulfitz on Thursday November 02, 2023 @09:27AM (#38113207)

In Grist, reference columns let you do a lot of what you can do with a join https://support.getgrist.com/col-refs/ while still having spreadsheet-style immediate updates when underlying data changes.

Also, if you just want to do queries and don't care about instant updates, you can do any SQL you like including joins with a SQL endpoint or a custom widget https://twitter.com/getgrist/status/1710018836836077967

[Grist employee]

[ Parent | on HN ]

Re:A modern, open-source spreadsheet that goes beyond the grid by klysm on Thursday November 02, 2023 @05:09PM (#38120185)

I've never used grist and know nothing, but if we have foreign keys why can't we write join expressions?

[ Parent | on HN ]

Re:A modern, open-source spreadsheet that goes beyond the grid by e12e on Thursday November 02, 2023 @12:01PM (#38115482)

I'm sure you could hack it up in scheme-in-a-grid?

http://siag.nu/siag/

[ Parent | on HN ]

Re:A modern, open-source spreadsheet that goes beyond the grid by klysm on Thursday November 02, 2023 @05:08PM (#38120177)

hacking it up is something I can do in most spreadsheet thingies, but I just want to be able to type join and have it Just Work

[ Parent | on HN ]