I make limited use of EN tables at the moment. As you say they're easier to manipulate in a desktop client than on a phone!
I second the idea of being able to put tasks in a tale. That could go some way to seeing a more "calendar-like" view of your tasks - and wouldn't it be great if tasks were in that sort of view and you could drag a task from one date to another and its assigned date updated?
But being able to put a tasks in the cells of a column, say, and use the cells in another column to add notes other information might be quite useful...
Having the tables option in EN is nice. But there are times when I want to include a table from Numbers, which can be anttached easily. But the attachment is not dynamic, so when the table is updated in Numbers, the changes are not reflected in EN. It shouldn’t be that hard to make the link dynamic. I don’t know if dynamic links work with Excel tables, do they?
Just tested. I have a Excel spreadsheet attached to a note in preview so I can see the cells. Double click to open, edit then save and the preview updates straight away with the changes.
If the Excel file is on Google Drive, the Google Drive attachment option can be used to add the file to an EN Note, and if you open the file you can amend it, automatically saved on Drive, and the next time you access it it's all up to date. However, using the Google Drive option doesn't give you a preview in EN as you would get if yiou used the Attachment option.
Agree that you can edit an attached Excel file when opening the attachment from EN, but as Philrodo says, its the note attachment that has been updated by your edits; you have to "Save AS..." the attachment back to its original location to replace it. I guess the crux of this is: are you intending ti replace the original file that was attached , or are you editing it in EN as a precursor to some other activity? How would this function if the note was shared? I suspect it comes back to how the note integration is designed to work. There;'s a difference between an attachment and a direct file link isn't there?
I think there is a difference. If you add an attachment it adds the file to the Evernote storage on your device and on the cloud, it doesn't create a shortcut to somewhere else.
Yes that makes sense - like an attachment in an email, you can open the attachment and edit it locally, but the original file in its native location remains unedited, only the attached copy has changed.
I’m not sure we’re talking about the same thing. I mean after attaching a table to a Note, open the spreadsheet in its native app (Excel, Numbers, etc.) and edit the spreadsheet. Go back to EN and as far as I can tell, the edits to the spreadsheet are not reflected on the table inside EN. In other words, once the table is attached to the Note, it’s no longer dynamically connected to the original spreadsheet.
I know that I can open a file attached to a Note, make editing changes and save it, which updates the attachment inside EN. But these edits only affect the Note attachment.
A true dynamic attachment should update in the background, so when the Note is opened it reflects any changes to the attached file.
I don’t recall if this was in legacy. But EN basically imports the attachment into the Note. So it’s not a shortcut pointing to the original file, the file is simply imported into EN and stored in its database, as far as I can tell.
Another useful piece - thanks Jon.
I make limited use of EN tables at the moment. As you say they're easier to manipulate in a desktop client than on a phone!
I second the idea of being able to put tasks in a tale. That could go some way to seeing a more "calendar-like" view of your tasks - and wouldn't it be great if tasks were in that sort of view and you could drag a task from one date to another and its assigned date updated?
But being able to put a tasks in the cells of a column, say, and use the cells in another column to add notes other information might be quite useful...
Tasks in tables would be very useful. We'd be able to almost categorise them Kanban style.
Having the tables option in EN is nice. But there are times when I want to include a table from Numbers, which can be anttached easily. But the attachment is not dynamic, so when the table is updated in Numbers, the changes are not reflected in EN. It shouldn’t be that hard to make the link dynamic. I don’t know if dynamic links work with Excel tables, do they?
Just tested. I have a Excel spreadsheet attached to a note in preview so I can see the cells. Double click to open, edit then save and the preview updates straight away with the changes.
Not the same for Numbers?
If the Excel file is on Google Drive, the Google Drive attachment option can be used to add the file to an EN Note, and if you open the file you can amend it, automatically saved on Drive, and the next time you access it it's all up to date. However, using the Google Drive option doesn't give you a preview in EN as you would get if yiou used the Attachment option.
I think there was talk about a Google Drive preview ages ago, maybe with the old team. Would be useful.
Agree that you can edit an attached Excel file when opening the attachment from EN, but as Philrodo says, its the note attachment that has been updated by your edits; you have to "Save AS..." the attachment back to its original location to replace it. I guess the crux of this is: are you intending ti replace the original file that was attached , or are you editing it in EN as a precursor to some other activity? How would this function if the note was shared? I suspect it comes back to how the note integration is designed to work. There;'s a difference between an attachment and a direct file link isn't there?
I think there is a difference. If you add an attachment it adds the file to the Evernote storage on your device and on the cloud, it doesn't create a shortcut to somewhere else.
Yes that makes sense - like an attachment in an email, you can open the attachment and edit it locally, but the original file in its native location remains unedited, only the attached copy has changed.
I’m not sure we’re talking about the same thing. I mean after attaching a table to a Note, open the spreadsheet in its native app (Excel, Numbers, etc.) and edit the spreadsheet. Go back to EN and as far as I can tell, the edits to the spreadsheet are not reflected on the table inside EN. In other words, once the table is attached to the Note, it’s no longer dynamically connected to the original spreadsheet.
I know that I can open a file attached to a Note, make editing changes and save it, which updates the attachment inside EN. But these edits only affect the Note attachment.
A true dynamic attachment should update in the background, so when the Note is opened it reflects any changes to the attached file.
I think I'm with you. The table/link in Evernote is like a shortcut to a file somewhere else on your Mac?
I didn't know it did this, was it in legacy? Been a long time since I used it.
I don’t recall if this was in legacy. But EN basically imports the attachment into the Note. So it’s not a shortcut pointing to the original file, the file is simply imported into EN and stored in its database, as far as I can tell.