tables
tables copied to clipboard
Column Types
This issue tracks Tables column types, both already implemented and user suggestions that we might consider building in the future.
Already implemented
- Text
- Rich Text
- Number
- Date (Could allow constant default value: https://github.com/nextcloud/tables/issues/732)
- Time
- Stars
- Single and multi select
- Progress
- Yes/No checkbox
- Links (depends on system setup and Search Provider API): Files, URL, Notes, Tags, Circles, Comments, Tables, Apps, Settings.
- User/Contacts (Related issues suggesting enhancements: https://github.com/nextcloud/tables/issues/586, https://github.com/nextcloud/tables/issues/644),
Suggestions
Some of these were gathered from Discussions.
- [ ] Coordinates/Location field with latitude and longitude. Useful for maps integration. Related issue: https://github.com/nextcloud/tables/issues/403
- [ ] Relational field to connect different tables. Related issues: https://github.com/nextcloud/tables/issues/172, https://github.com/nextcloud/tables/issues/802
- [ ] Icon/Emoji picker
- [ ] Color picker
- [ ] Autoincrement / Sequential number
- [ ] FliePicker/ImagePicker with image/file preview. Related issue: https://github.com/nextcloud/tables/issues/580. We already have the Link column, and i'd be nice if linked images had a preview.
- [ ] Drop-down with dependent options e.g country and statefields (you select a country and the state drop-down is limited to the particular country)
- [ ] Formula field. Related issues: https://github.com/nextcloud/tables/issues/181, https://github.com/nextcloud/tables/issues/36, https://github.com/nextcloud/tables/issues/888
- [ ] Phone number
- [ ] IP Address. Related issue: https://github.com/nextcloud/tables/issues/402
We should also think about test coverage for the different column types: https://github.com/nextcloud/tables/issues/907
@juliushaertl Coordinates/Location field and image previews are the most-requested by users for now.
Thanks for the nice overview. I think https://github.com/nextcloud/tables/issues/586 is the most crucial one to implement internal processes that we have, which is what we have put on the feature planning board already.
The file/image one definitely also seems important, we should probably try to figure out how those would be implemented and discuss that further already (e.g. where is the file stored)
Maybe adding a regex validation to the text column would already allow something like an email column? Could even provide some examples to choose from.
I would like to request another (non-editable) column type: user. Because I would like to store the information who created the data set. If you think that through you will end up with
- created by
- created date
- last edited by
- last edited date
EDIT: just found out, that this is already available in views.
Just want to add my voice to the support for Formula fields. Give me that, and I could ditch Airtable, or even my beloved NocoDB. I do like having as much as possible in one place, and all that.