Show Posts

This section allows you to view all posts made by this member.


Messages - Definitions

Pages: [1] 2 3 4 5 6 7 ... 136
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

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
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
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?

8
Just Shmooze / Re: Where Are You Posting From Now?
« on: January 11, 2021, 08:24:14 AM »
ORD

9
Just Shmooze / Re: Where Are You Posting From Now?
« on: January 11, 2021, 05:10:16 AM »
EWR

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.

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

Pages: [1] 2 3 4 5 6 7 ... 136