Messages

1

Deals/Deal Requests / Re: Comfortable desk chair for office with arms

« on: January 20, 2021, 08:22:06 PM »

I don't know. But based on a little searching it's going to be hard to find anything that's very comfortable at that price

2

General Discussion / Re: Business Phone/Internet question

« on: January 20, 2021, 08:09:59 PM »

Any options for Lakewood?

Need the cheapest most basic plan. Must have phone, a phone number that's registered to the business name.

Optimum wants 120

Also it must be classified as a landline

3

Tech Talk / Re: OBi Master Thread

« on: January 20, 2021, 01:07:57 PM »

I'm not sure what you saying?

They're relatively uncommon in use but it's a useful thing. It makes a wired ethernet connection from your modem/router to wherever you want in your house (more or less) using the power lines in your house to connect the two powerline adapters.

I have a pair if you'd like, you can borrow them to test it out



All you do is plug it in a outlet (preferably not a extension cord/surge protector) plug a ethernet cable into your router and one adapter. Then plug the second one near where you want the obi and connect via ethernet.

Also if you have a telephone jack near your router then plug in the obi there and connect the telephone jack to that outlet. It will give service to any telephone jack in your house.
That's what I did in my house and it works perfectly

4

Tech Talk / Re: Google Sheets help

« on: January 19, 2021, 03:52:54 PM »

It should include the time too; check what the cell is formatted as.

Ahh you're right.
Thanks

5

Tech Talk / Re: Google Sheets help

« on: January 19, 2021, 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

6

Just Shmooze / Re: Jewish Music (New CDs, hock, and opinions)

« on: January 19, 2021, 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

7

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

8

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.

9

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.

10

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?

11

Just Shmooze / Re: Where Are You Posting From Now?

« on: January 11, 2021, 08:24:14 AM »

ORD

12

Just Shmooze / Re: Where Are You Posting From Now?

« on: January 11, 2021, 05:10:16 AM »

EWR

13

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

14

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?

15

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.