search

joelnitta / booklist

R package to maintain a book list with Zotero and Google Sheets
Other
0 stars 0 forks source link

Allow user to set custom columns in google sheets #1

Open joelnitta opened 5 years ago

joelnitta commented 5 years ago

Instead of hard-coding purchased, date_purchased, etc.

amirahmajid commented 5 years ago

I found that I could manually add columns in Google sheets and they seem to be unaffected when updating the sheet. I added columns which include dropdown selections, I formatted text, and added conditional formatting and it all seems to survive the update process unscathed. One weird thing is that 'NA's seem to appear and disappear. When I created the sheet it added NA's but when I updated it they vanished. That doesn't bother me so I haven't investigated it.