Sheets
Connecting a tab to app data
Fill a tab with rows from your forms, files, photos, calendar or share links, and refresh it whenever you want the numbers again.
A tab can be connected to another part of Nemi, and then it fills itself: the responses of a form, the files in a folder, the photos in an album, your events for the coming 90 days, or what your share links have done. Everything arrives as ordinary cells, so you can write formulas over it, format it and export it like anything else in the workbook. If you do not see Connect to app data in the sidebar, it has not been switched on for your account yet.
- 1
Press Connect to app data
In the sheet sidebar, under the list of tabs, next to Add sheet.
- 2
Pick the app
Form responses, Files, Gallery, Calendar or Share links.
- 3
Pick what the tab should show
Which form, which folder, which album. Some sources have only one thing to offer, and something you cannot open is never on the list.
- 4
Read the tab
A new tab appears, named after what you connected, with the column headings in the first row and the rows underneath.
What each source brings#
| Source | The rows | The columns |
|---|---|---|
| Form responses | The responses of one form in this workspace | The response columns of that form |
| Files | The files in one folder, or in the workspace root | Name, Type, Size in bytes, Uploaded, Downloads |
| Gallery | The photos in this workspace library, or in one album | Name, Taken, Camera, Width, Height, Size in bytes, Favorite |
| Calendar | Your own events for the coming 90 days | Title, Start, End, All day, Location, Calendar |
| Share links | Your own links | Name, Created, Expires, Status, Opens, Unique viewers, Downloads |
A folder brings the files directly in it, not the ones inside its subfolders. Calendar and Share links bring yours, never a colleague's.
Refreshing#
The bar above the grid says which app the tab is connected to and how long ago it was refreshed. Refresh fetches the source again, and the tab also refreshes once on its own when you open it, so a sheet you come back to is current without pressing anything.
Disconnecting#
Disconnect, in the same bar, keeps every row exactly where it is and stops the refreshes. The tab becomes an ordinary tab you can edit, and nothing is deleted. There is no way to undo a refresh, so disconnect before you start writing over the data rather than afterwards.
Limits#
| Thing | Limit |
|---|---|
| Rows on a connected tab | 1,000 |
| Columns on a connected tab | 20 |
| Dates and times | Written in UTC |
A bigger source is cut off at those numbers. Times are fixed to UTC so that two members in two countries read the same sheet the same way.
The refresh says the source is no longer available to me.
The form, folder, album or link it points at has been deleted, or it is no longer something you can open. The rows already on the tab stay. Disconnect it, or connect a tab to something else.
It says there have been too many refreshes.
Refreshing is rate limited, so a tab cannot be hammered. Wait a few minutes and press it again.
Can I connect a tab to a colleague's calendar?
No. Calendar and Share links only ever bring your own, because that is all you can see yourself. Everybody in the workspace reads what your refresh wrote.
Related
Still stuck? Email support@nemilab.com and tell us what you were trying to do.