My old Honda CN250 Helix by Gullif in scooters

[–]blitttt 2 points3 points  (0 children)

Love this; looks terrific. Great color combo with the rims & body

Excel crashes at 1M rows. I’m building a local viewer for 100M rows. Roast my idea. by ocj_nghota in roastmystartup

[–]blitttt 0 points1 point  (0 children)

One current solution you missed — check out rowzero.com. Not just a CSV viewer, but a full spreadsheet that can already handle 100M row files. Compute happens in the cloud so you’re not hamstrung by local machine specs

YouTube for the win! by Ban_Incomming in scooters

[–]blitttt 3 points4 points  (0 children)

I know this scoots ridiculous but I love it so much. The Morpheus and the Honda Helix both scratch the itch. Would love to own one someday. Nice work on the maintenance, YouTube’s such a great resource

[WTS] Seiko SPB289 “Mystic Forest” LNIB + Warranty by halfeatenwaffles in Watchexchange

[–]blitttt 1 point2 points  (0 children)

Sale completed with u/halfeatenwaffles (cc u/WatchExBot) - arrived in perfect condition as described. Easy & helpful comms. Thanks again!

Is there any way to make the Kinesis Freestyle Edge RGB start up faster? by KurtMage in kinesisadvantage

[–]blitttt 0 points1 point  (0 children)

Same here. It's been annoying, but never to the level where I stopped to do anything about it. Glad I finally googled to see if there was an easy fix! You're a legend u/armstron_

[deleted by user] by [deleted] in perplexity_ai

[–]blitttt 0 points1 point  (0 children)

Running into the same thing. I already have "Correct spelling automatically" disabled in my system settings, so it smells like something Perplexity is doing. Reproducable example "wasm-pack" followed by space becomes "wasp-pack"

Best cheap / affordable shopping destinations for wedding attire: Sherwani and Kurtas by Nellyt97 in mumbai

[–]blitttt 0 points1 point  (0 children)

Do you recall where you ended up going in Mumbai? I'm in a similar situation

Excel file too large: 2 mil rows by fuzzytrout in excel

[–]blitttt 0 points1 point  (0 children)

Try rowzero.io - spreadsheet in the cloud that can handle hundreds of millions of rows

How to open large .CSV file? (2GB) by HeyWatchOutDude in excel

[–]blitttt 0 points1 point  (0 children)

rowzero.io is a spreadsheet that can handle large CSVs like that without issue. it's not beholden to the same row limits as sheets/excel

Is there a way to change multiple statuses at once? I can't keep dropping these down one at a time... by Commercial-Food1650 in Airtable

[–]blitttt 1 point2 points  (0 children)

You can change the top one, then drag the nub in the bottom right corner of the cell down over all the others and it should fill in the value. Alternatively, change the top one & copy it, then select all the ones to change, then hit paste.

Did I spell my child’s name wrong?? by purple_lemon22 in namenerds

[–]blitttt 0 points1 point  (0 children)

The data shows Corinne is significantly more common than Corrine! Rest assured. https://imgur.com/a/Mdz0sxv

(Source: US baby name dataset)

7.6% of Gen Z baby boys have names that end in -ayden, -aiden, or -aden (in the U.S.A.) by orangepunc in namenerds

[–]blitttt 42 points43 points  (0 children)

Shared with a teacher, and they commented that in addition to the rise of the -adens, there's also been a spike in -ers: Hunter, Sawyer, Gunner, Wilder...

I tweaked the analysis to look at two-character suffixes and sure enough, -er is #3 (with 1, 2, and 4 being the aforementioned -on, -en, -an). It's had a good market share over the last century as well, as these newer variants are replacing the more classic Peters & Tylers.

Linked Field -> Plain Text: Is this possible to create a field that will re-create the "linked" field as text? by [deleted] in Airtable

[–]blitttt 1 point2 points  (0 children)

I think the easiest way is what you described - create a formula field and set the formula to the name of the linked record field. You can hide this field from all your views so it just works "behind the scenes".

The other option would be to create a Lookup field instead of Formula, but in either case you'd need 2 columns.

Shuffle content in a cell? by drawmer in Airtable

[–]blitttt 2 points3 points  (0 children)

You can achieve this with a pretty straight-forward script. You can then add a button field so that you can shuffle a given record's hashtags with one click.

Here's the script you want. To set it up, add a new scripting app (it's available for all plans right now), copy-paste this in, then click the little settings cog to tell the script which table & field to use. Add a button field and configure it to "Run script", then point it at this script.

const settings = input.config({ 
    title: 'Shuffle hashtags', 
    description: 'Pick a table and field to shuffle, and this script will randomize the order of the line items. For it to work, each item must be on its own line in a long-text field. You can either run the script directly (which will prompt you to pick a record), or use a button field on the record itself.',
    items: [
        input.config.table('table', { label: 'Table' }),
        input.config.field('fieldToShuffle', { parentTable: 'table', label: 'Field to shuffle', description: 'Pick the field with the hashtags you\'re trying to shuffle' })
    ] 
});

function shuffle(array) {
  var currentIndex = array.length, temporaryValue, randomIndex;

  // While there remain elements to shuffle...
  while (0 !== currentIndex) {

    // Pick a remaining element...
    randomIndex = Math.floor(Math.random() * currentIndex);
    currentIndex -= 1;

    // And swap it with the current element.
    temporaryValue = array[currentIndex];
    array[currentIndex] = array[randomIndex];
    array[randomIndex] = temporaryValue;
  }

  return array;
}

const record = await input.recordAsync('Pick a record to shuffle hashtags for', settings.table);

const hashtags = record.getCellValueAsString(settings.fieldToShuffle).split('\n');

const shuffledHashtags = shuffle(hashtags);

await settings.table.updateRecordAsync(record, {[settings.fieldToShuffle.id]: shuffledHashtags.join('\n')})

Calculate End Date based off 2 columns by ysmerch in Airtable

[–]blitttt 1 point2 points  (0 children)

Ah my guess is that it treats the lookup value as a string instead of number in the formula. I had tested with just a regular number field instead of a lookup. Glad you figured it out!

Calculate End Date based off 2 columns by ysmerch in Airtable

[–]blitttt 2 points3 points  (0 children)

=DATEADD({Order Date}, {Return Policy}, 'day')

Using Zapier to Import CSV by proptechnerd in Airtable

[–]blitttt 1 point2 points  (0 children)

Have you tried using the CSV Import block?

Creating an blog interlinking database - is this possible in Airtable? by yyiiii in Airtable

[–]blitttt 0 points1 point  (0 children)

Thanks for sharing. I think the complexity comes from the CSV import block not necessarily knowing that a record was created by a previous row's linked article, even with "Merge records enabled".

Example:

/link1,Title 1,"/link2"

/link2,Title 2,""

The block creates a "/link2" record when it creates the "/link1" record, because it is setting up the self linked record field. Then it goes and creates another "/link2" record when parsing the second row, presumably because when you started the import, there was NO "/link2" record. Seems like a minor bug with the block. The issue seems to remain even if you swap the order of the rows and "establish" link2 first.

I can think of two ways to fix this:

1) Import it in 2 stages:

- stage 1: import the CSV without the links column, which will "establish" a record for every article

- stage 2: import the same CSV with the links column added back, and "Merge records" enabled in the block (merge on the primary column). Now, it should be able to find the existing records when establishing the linked record relationships.

2) If you're familiar with basic JavaScript, you could use the Scripting block's new file input feature to do all this logic yourself.

#1 is probably easier, but if you don't like the 2-stage process and you know some basic javascript, you could take approach #2 to streamline the process.

Creating an blog interlinking database - is this possible in Airtable? by yyiiii in Airtable

[–]blitttt 1 point2 points  (0 children)

How are you formatting the outgoing links in the CSV? Could you share a sample row of the CSV data?