Ess Table, Airtable app on Solid

Build a Solid App Ideas for Solid Apps
1

What do you think of a AirTable like app.

Screenshot_2021-01-18 ess-table
Screenshot_2021-01-18 ess-table1368×798 4.79 KB

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)

Screenshot_2021-01-18 ess-table(1)
Screenshot_2021-01-18 ess-table(1)1368×798 6.31 KB

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

Screenshot_2021-01-18 ess-table(2)
Screenshot_2021-01-18 ess-table(2)2702×1596 86.4 KB

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

Screenshot_2021-01-18 ess-table(3)
Screenshot_2021-01-18 ess-table(3)2736×1596 95 KB
Screenshot_2021-01-18 ess-table
Screenshot_2021-01-18 ess-table1368×798 4.79 KB

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

Screenshot_2021-01-18 ess-table(4)
Screenshot_2021-01-18 ess-table(4)1368×911 36.8 KB

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

3 Likes
2

@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

image
image1351×935 21.9 KB

should give you a similar thing to the Airtable Project Manager Sign in - Airtable

image
image1368×935 24.9 KB

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

image
image1868×1010 57.4 KB

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

Screenshot_20210118-143405_Chrome
Screenshot_20210118-143405_Chrome720×1280 212 KB

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 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

1 Like