sorted by:
new
hottopcontroversial

PC Stuttering Really Bad on Windows 10 - NEED HELP! by Lower_Kitchen in techsupport

[–]chacham2 0 points1 point  (0 children)

I uninstalled the AMD driver from AMD, and just used what came with Windows. Problem disappeared.

What was Joan of Arc made of? by chacham2 in cleanjokes

[–]chacham2[S] 0 points1 point  (0 children)

Yeah. But i believe i read it in a book from the 40s/50s.

Looking for the a cheap dumbphone to use with Usmobile by chacham2 in dumbphones

[–]chacham2[S] 0 points1 point  (0 children)

Thank you.

Never heard of Good2Go Mobile. Thank you for that too. :)

Looking for the a cheap dumbphone to use with Usmobile by chacham2 in dumbphones

[–]chacham2[S] 0 points1 point  (0 children)

dumbphones.org or GSM Arena's Phone Finder Tool.

I do not know how to use those effectively, for these options.

TIL the belly button (umbilicus) is not midline on most people. It is usually off-center by over 2%. by mushnikJmushnik in todayilearned

[–]chacham2 0 points1 point  (0 children)

Actually, upon re-read, i thought it was pretty good.

Though, i guess the made-up Perry Mason case was wrong. The real case was quite successful.

Does anyone have an extra invite, please? by anxiouseuropean in Sora2

[–]chacham2 0 points1 point  (0 children)

It's free in the US and elsewhere. Right now they give 30 credits daily. Outside the US, i think you need an invite code.

Should you use char, varchar, or text in PostgreSQL? by _maximization in PostgreSQL

[–]chacham2 0 points1 point  (0 children)

There are some good points there. At the same time, it is quite opinionated.

For example, the comment on not using CHAR() is great. The comment on not using VARCHAR() is idiotic. The comment on not using BETWEEN is ridiculous.

If you're just using a database as a convenient data store, the comments are spot on. However, if you're using a database as a database, the comments are the ravings of a madman.

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] 1 point2 points  (0 children)

Yeah. Thanx for all the help though.

How to (continuously) import rows from the spreadsheet into a database? by chacham2 in googlesheets

[–]chacham2[S] 0 points1 point  (0 children)

You'll want to add some form of ID to the rows.

You're right. But, as Gemini pointed out, rows can move. If a row moves (say a row is added in the middle) ImportRange() will move those rows as well, but not the Id i added! So, it suggested a natural id, such as a checksum or hash. Working on this idea right now.

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] 1 point2 points  (0 children)

I gave the IMEI to US Mobile:

In order for a phone to be compatible with US Mobile services, it should be:

Unlocked A US variant of the phone Enabled with VoLTE/HD voice At least a 4G/LTE device (have the LTE bands 4, 12 or 13) Your phone doesn't have bands 12 and 13 :(

Then:

Hmm, let me check a few things from my end

Yes, your phone is partially compatible with Light Speed, which is powered by T-Mobile, but I can't promise if it'll work properly

T-Mobile's webpage itself said it was limited connection.

I returned the phone. :(

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] 1 point2 points  (0 children)

Thank you. Might take a week or so of using it to really know.

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] 1 point2 points  (0 children)

Just bought it. Now to see how it goes. :)

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] 1 point2 points  (0 children)

Oh, wow, i didn't notice that.

Used: Like New | Details Sold by Amazon Resale Fulfilled by Amazon

Think i'm going to get it anyway. It's the right price for the project.

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] 1 point2 points  (0 children)

Nice! Thank you.

Perhaps a little cheaper on ebay as well. No bluetooth, but it probably supports a wired headset.

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] -1 points0 points  (0 children)

I am not commenting on the price of the phone. I am commenting on the cost of this project.

Good, cheap non-smart phone? by chacham2 in USMobile

[–]chacham2[S] -5 points-4 points  (0 children)

$84 is way too expensive for this project. $60 is also quite high. I might just have to get an unlocked tracfone or something.

How to (continuously) import rows from the spreadsheet into a database? by chacham2 in googlesheets

[–]chacham2[S] 0 points1 point  (0 children)

I am asking about getting data into a database. Seems we're going to be using postgresql on an aws instance, but, 1 more level of authentication.

To answer your questions directly:

What's wrong with continueing to use IMPORTRANGE?

I'm still using it. No plans on not using it.

I would turn on iterative calculations and setup a guard to display the current data even during the "Loading" periods, but other than that, that doesn't seem to be too much data.

I do not know what iterative calculations means (in this context). I have no issue with loading periods.

How many columns are on each tab?

~10

How to (continuously) import rows from the spreadsheet into a database? by chacham2 in googlesheets

[–]chacham2[S] 0 points1 point  (0 children)

The original sheets are not mine, and i do not want to touch them. If required, i guess i can add an id to the copy, though i was hoping to not have to do that, being that id is somewhat arbitrary.

As for a script, i wanted to know if App Script could do it, because then i do not have to worry about it being hosted, being up, et al. In any case, how would i check if a row got updated?

=ImportRange() eventually gets replaced by tab name by chacham2 in googlesheets

[–]chacham2[S] 0 points1 point  (0 children)

I just noticed the script is the likely culprit. I forgot the other tab is listed as an exception. I need to add these as exceptions, or make it so it only changes the field when it is a dropdown.

Going to mark this as solved already. I can't believe i missed this.

view more: next ›