Theo Ephraim

icon indicating a website link https://theoephraim.com icon indicating an email [email protected]

icon company @dmno-dev icon location British Columbia, Canada icon location 👉_ _ /||||| building @dmno-dev - the best way to configure, run, and deploy your entire stack. full stack dev, designer, entrepreneur

Results 163 comments of Theo Ephraim

Please add query option for update and delete

If you mean bulky in that it fetches everything, google's api does not provide filtering capabilities :(

setDataValidation data validation

it is not implemented but should be relatively straightforward to add. Open to PRs!

Build issues related to polyfill and webpack 5

I know others have successfully used this module in front-end only projects, but I really never built it with that in mind, as most use cases use service account auth,...

Past column A (AA >)

The sheet is flat, nothing exists after Z, just monsters... Perhaps it is just an oversight it how it figures out the column address. Can you give a little more...

row.Delete() is sometime not deleting the row as expected

sorry for the delay folks. This module definitely does not handle deletion of rows as well as it could... Unfortunately rows dont have a unique ID we can refer to...

row.Delete() is sometime not deleting the row as expected

Obviously this wont work for all use cases, but one option for some is to use a "soft delete" - meaning add a `is_deleted`/`deleted_at` column to the table and then...

Change permissions of a google sheet / newly created sheet.

I'd love to have some basic Drive api functionality built into this module as well, but I have not had the time to implement it. Open to PRs!

Prepend rows

I think this should be pretty easy to add. Pull requests welcome! If not I'll add it the next time I'm doing a big round of changes (I usually do...

Edit an existing row by sending the row number

This module is not really set up for that at the moment, but you might be able to do something hacky - load a single row - clone it -...

Not able to add dropdown to Spreadsheet Cell using dataValidation property

Sorry but this is not yet supported in this module. Just setting it on the cell object like that won't actually do anything at the moment. Open to pull requests!