Column Types

[enjeck]

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
• [ ] Email
• [ ] 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

[enjeck]

@juliushaertl Coordinates/Location field and image previews are the most-requested by users for now.

[juliusknorr]

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)

[SystemKeeper]

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.

[xbluemonkx]

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.

[EzequielBruni]

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.

[Aveyron-RetD]

What would be interesting for Nextcloud users is having access to Files in a defined folder for some kind of workflow mechanism. For example : I want to track all the changes inside a folder that are business critical. I want to notify specific users or groups or all users of a modified document. I want to know who has opened it and “read it”. I want to make sure they have read it by making them sign it. => Maybe by tags ? I want to know who has not signed it => and send them a reminder. I want to know who has access to this file in read/Read write/ or no access at all.

It would be much easier to deal with this in a table than going per file and doing all this logic.

[tatrapikao]

Id like to suggest a "Label" Value which is similar to the "multi-select" but each string has a configurable Color attached. In the Table it is rendered like this: preferably there would be the Option to allow the User to add new "Labels" on input or limit them to specific Set.