Ess Table, Airtable app on Solid

What do you think of a AirTable like app.

A user can store many workspaces on his POD and share it with a url like this one https://scenaristeur.github.io/ess-table/bases?url=https%3A%2F%2Fspoggy-test5.solidcommunity.net%2Fpublic%2Ftable%2Fworkspaces%2F6ae3faae-0192-4f4b-acbe-65eb64ecbf28.ttl (login & refresh to see on of my workspace)

A workspace can have many databases (on the POD or on a remote POD(todo))

A database is organized with Tables
And a table group records with an easy way to add Table column / Record Fields

Once connected & authorized (todo) we could easy collaborate on data

Very experimental for now but suggestions / contributions & feedback welcome on repo issue Issues · scenaristeur/ess-table · GitHub

2 Likes

@mthorner templates shouldn’t be really hard forking this base
https://spoggy-test5.solidcommunity.net/public/table/bases/6948b3c0-f1b0-4cc0-80e8-3ded849882f9.ttl
and his three tables

should give you a similar thing to the Airtable Project Manager https://airtable.com/tbltzV5ZqfTC8vtxa/viwohwhjAIW9kBANX?blocks=hide

Must improve Fields but for now if you only play with “Single Line Text” on Field type, you should see your data on your POD like here

https://spoggy-test5.solidcommunity.net/public/table/records/3f1d72ed-82cd-4fb1-ac4a-bb9ddb96c921.ttl

And can have same acces on your mobile, cause the web app access data on your Pod

I will quickly reimplement the switch button to swith ‘public/private’ so one can have private workspaces/bases/tables/records too :wink: → done
it’s up to you to build a contact base like this one Employee directory Template - Free to Use | Airtable that could be build as a Solid Group (i’ve expermimented groups with https://scenaristeur.github.io/group) then you could give (owner/read /write) acces as any Solid Resource

https://scenaristeur.github.io/ess-table

with project tracker template https://scenaristeur.github.io/ess-table/bases?url=https%3A%2F%2Fspoggy-test5.solidcommunity.net%2Fpublic%2Ftable%2Fworkspaces%2F6ae3faae-0192-4f4b-acbe-65eb64ecbf28.ttl