forked from gristlabs/grist-core
-
Notifications
You must be signed in to change notification settings - Fork 0
/
publiccode.yml
175 lines (168 loc) · 7.99 KB
/
publiccode.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
# This repository adheres to the publiccode.yml standard by including this
# metadata file that makes public software easily discoverable.
# More info at https://github.com/italia/publiccode.yml
publiccodeYmlVersion: '0.2'
categories:
- data-collection
- crm
- compliance-management
- office
dependsOn:
open:
- name: NodeJS
optional: false
version: ''
versionMax: ''
versionMin: '18'
- name: Python
optional: false
version: ''
versionMax: ''
versionMin: '3.9'
- name: Yarn
optional: true
version: ''
versionMax: ''
versionMin: ''
- name: Postgresql
optional: true
version: ''
versionMax: ''
versionMin: ''
- name: Redis
optional: true
version: ''
versionMax: ''
versionMin: ''
description:
en:
apiDocumentation: 'https://support.getgrist.com/api/'
documentation: 'https://support.getgrist.com/'
features:
- database
- spreadsheet
- low-code
- no-code
- form generation
- webhook
- calendar
- map
- python formulas
genericName: collaborative spreadsheet
longDescription: |
Grist is a hybrid database/spreadsheet, meaning that:
- Columns work like they do in databases: they are named, and they hold one kind of data.
- Columns can be filled by formula, spreadsheet-style, with automatic updates when referenced cells change.
This difference can confuse people coming directly from Excel or Google
Sheets. Give it a chance! There's also a [Grist for Spreadsheet
Users](https://www.getgrist.com/blog/grist-for-spreadsheet-users/) article
to help get you oriented. If you're coming from Airtable, you'll find the
model familiar (and there's also our [Grist vs
Airtable](https://www.getgrist.com/blog/grist-v-airtable/) article for a
direct comparison).
Here are some specific feature highlights of Grist:
- Python formulas.
- Full [Python syntax is supported](https://support.getgrist.com/formulas/#python), including the standard library.
- Many [Excel functions](https://support.getgrist.com/functions/) also available.
- An [AI Assistant](https://www.getgrist.com/ai-formula-assistant/) specifically tuned for formula generation (using OpenAI gpt-3.5-turbo or [Llama](https://ai.meta.com/llama/) via [llama-cpp-python](https://github.com/abetlen/llama-cpp-python)).
- A portable, self-contained format.
- Based on SQLite, the most widely deployed database engine.
- Any tool that can read SQLite can read numeric and text data from a Grist file.
- Enables [backups](https://support.getgrist.com/exports/#backing-up-an-entire-document) that you can confidently restore in full.
- Great for moving between different hosts.
- Can be displayed on a static website with [`grist-static`](https://github.com/gristlabs/grist-static) – no special server needed.
- A self-contained desktop app for viewing and editing locally: [`grist-electron`](https://github.com/gristlabs/grist-electron).
- Convenient editing and formatting features.
- Choices and [choice lists](https://support.getgrist.com/col-types/#choice-list-columns), for adding colorful tags to records.
- [References](https://support.getgrist.com/col-refs/#creating-a-new-reference-list-column) and reference lists, for cross-referencing records in other tables.
- [Attachments](https://support.getgrist.com/col-types/#attachment-columns), to include media or document files in records.
- Dates and times, toggles, and special numerics such as currency all have specialized editors and formatting options.
- [Conditional Formatting](https://support.getgrist.com/conditional-formatting/), letting you control the style of cells with formulas to draw attention to important information.
- Drag-and-drop dashboards.
- [Charts](https://support.getgrist.com/widget-chart/), [card views](https://support.getgrist.com/widget-card/) and a [calendar widget](https://support.getgrist.com/widget-calendar/) for visualization.
- [Summary tables](https://support.getgrist.com/summary-tables/) for summing and counting across groups.
- [Widget linking](https://support.getgrist.com/linking-widgets/) streamlines filtering and editing data. Grist has a unique approach to visualization, where you can lay out and link distinct widgets to show together, without cramming mixed material into a table.
- [Filter bar](https://support.getgrist.com/search-sort-filter/#filter-buttons) for quick slicing and dicing.
- [Incremental imports](https://support.getgrist.com/imports/#updating-existing-records).
- Import a CSV of the last three months activity from your bank...
- ...and import new activity a month later without fuss or duplication.
- Integrations.
- A [REST API](https://support.getgrist.com/api/), [Zapier actions/triggers](https://support.getgrist.com/integrators/#integrations-via-zapier), and support from similar [integrators](https://support.getgrist.com/integrators/).
- Import/export to Google drive, Excel format, CSV.
- Link data with [custom widgets](https://support.getgrist.com/widget-custom/#_top), hosted externally.
- Configurable outgoing webhooks.
- [Many templates](https://templates.getgrist.com/) to get you started, from investment research to organizing treasure hunts.
- Access control options.
- (You'll need SSO logins set up to make use of these options; [`grist-omnibus`](https://github.com/gristlabs/grist-omnibus) has a prepackaged solution if configuring this feels daunting)
- Share [individual documents](https://support.getgrist.com/sharing/), workspaces, or [team sites](https://support.getgrist.com/team-sharing/).
- Control access to [individual rows, columns, and tables](https://support.getgrist.com/access-rules/).
- Control access based on cell values and user attributes.
- Self-maintainable.
- Useful for intranet operation and specific compliance requirements.
- Sandboxing options for untrusted documents.
- On Linux or with Docker, you can enable [gVisor](https://github.com/google/gvisor) sandboxing at the individual document level.
- On macOS, you can use native sandboxing.
- On any OS, including Windows, you can use a wasm-based sandbox.
- Translated to many languages.
- `F1` key brings up some quick help. This used to go without saying, but in general Grist has good keyboard support.
shortDescription: |-
Grist is a modern relational spreadsheet. It combines the flexibility of a
spreadsheet with the robustness of a database.
videos:
- 'https://www.youtube.com/watch?v=XYZ_ZGSxU00'
developmentStatus: stable
inputTypes:
- application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
- text/csv
it:
conforme:
gdpr: false
lineeGuidaDesign: false
misureMinimeSicurezza: false
modelloInteroperabilita: false
countryExtensionVersion: '0.2'
piattaforme:
anpr: false
cie: false
pagopa: false
spid: false
landingURL: 'https://getgrist.com'
legal:
license: Apache-2.0
localisation:
availableLanguages:
- en
- fr
- ru
- de
- es
- pt
- zh
- it
- ja
- 'no'
- ro
- sl
- uk
localisationReady: true
logo: |-
https://raw.githubusercontent.com/gristlabs/grist-core/master/static/img/logo-grist.png
maintenance:
contacts:
- affiliation: Grist Labs
email: [email protected]
name: Paul Fitzpatrick
type: internal
name: Grist
outputTypes:
- application/x-sqlite3
platforms:
- web
releaseDate: '2024-06-12'
roadmap: 'https://github.com/gristlabs/grist-core/projects/1'
softwareType: standalone/other
softwareVersion: 1.1.15
url: 'https://github.com/gristlabs/grist-core'
usedBy:
- 'ANCT (https://anct.gouv.fr)'
- 'DINUM (https://www.numerique.gouv.fr/dinum/)'