1
Tech Talk / Re: Google Sheets help
« on: Yesterday at 03:52:54 PM »It should include the time too; check what the cell is formatted as.Ahh you're right.
Thanks
Show Posts
This section allows you to view all posts made by this member.
Thanks
2
Tech Talk / Re: Google Sheets help
« on: Yesterday at 03:46:22 PM »
I want to have a date AND time timestamp autopopulate in column A when editing column B
I found some code here https://spreadsheetpoint.com/insert-timestamps-in-google-sheets/
I edited it as follows
It works but only adds in the date is there some function to replace
I tried NOW() but it doesn't seem to work
I found some code here https://spreadsheetpoint.com/insert-timestamps-in-google-sheets/
I edited it as follows
Code: [Select]
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "New transactions" ) { //checks that we're on the correct page or not
var r = s.getActiveCell();
if( r.getColumn() == 2 ) { //checks that the cell being edited is in column B
var nextCell = r.offset(0, -1);
if( nextCell.getValue() === '' ) //checks if the adjacent cell is empty or not?
nextCell.setValue(new Date());
}
}
}It works but only adds in the date is there some function to replace
Code: [Select]
nextCell.setValue(new Date()); that would include the current time?I tried NOW() but it doesn't seem to work
3
Just Shmooze / Re: Jewish Music (New CDs, hock, and opinions)
« on: Yesterday at 12:43:23 PM »interesting collection of music streams.Thanks I forgot the link to that. Someone (DanH?) Posted it once but I couldn't find it
דף-הבית.קום
4
COVID-19 Discussion Board / Re: Lakewood covid cases
« on: January 18, 2021, 02:06:00 PM »
My father just tested positive... He's not a young man
5
General Discussion / Re: **Shipping Master Thread** What service To Use When
« on: January 14, 2021, 10:48:07 PM »Anyone else here use shippinguru USPS priority labels and have packages that have been in the USPS system for 8+ days with no movement? Curious if the delays are purely USPS-based or have something to do with the label. Somewhat frustrating. Shipped 5 things on 1/5 and only one has been delivered... others feel like there's in no-mans land... buyers haven't really complained either... just a puzzling situation...
My guess is the USPS. I use regular usps labels. This year in particular I had a lot of packages that were extremely delayed by the USPS. Some of them a month+ until it was delivered. I don't know what's up with them.
6
COVID-19 Discussion Board / Re: Interesting Articles: COVID-19 Edition
« on: January 12, 2021, 11:01:13 PM »
I mean theoretically it's just the airline that has to verify. So if you make a somewhat decent forgery of a test result I'd imagine privacy laws would prevent them from actually finding out if a test occured at all.
7
Just Shmooze / Re: The funny/strange/interesting/random pictures thread
« on: January 12, 2021, 10:31:04 AM »
The view from my hotel now. First time I'm seeing this type of mural in real life.
Why is the flag at half mast?
10
Just Shmooze / Re: Master Thread of Pet Peeves
« on: January 09, 2021, 07:37:40 PM »
Battery compartments that are not designed to be easy to remove a battery
11
Credit Cards / Re: Disputing charge - penalty
« on: January 09, 2021, 07:36:01 PM »I fight chargebacks for a living and have never seen such a fee.Is this a general rule for all businesses?
12
Politics / Re: Twitter bans sitting President
« on: January 09, 2021, 07:22:05 PM »Twitter is clearly no longer an open platform, rather a publisher. And should be liable for their content and open to suit.I do not agree with this.
Not in technicalities/legalities whether it's a publisher or not. In the (sarcastic?) opinion as a whole.
13
Politics / Re: Does DDF need a politics board?
« on: January 07, 2021, 11:36:46 AM »
If it's reversible and doesn't take too much time. Why not try?
It'll be like the responsive design trial.
It'll be like the responsive design trial.
14
Just Shmooze / Re: What's your desktop background?
« on: January 07, 2021, 09:11:06 AM »Why would you want it like this? Why not combine all games into one folder? And those pictures (emotes?) too
15
General Discussion / Re: Brooklyn Optometrist
« on: January 03, 2021, 09:41:30 PM »
From what I remember minzer was known to be cheap. I don't know if it's still like that