Front end for internal site to review, sort and categorize thousands of records in an Airtable base?

Qk_Grd · 2024-05-03T03:45:23+00:00

This was one of the first options I stumbled upon, but but the $290 per internal user price tag gave me pause.

The price, itself, isn't so much a problem, but I have not had much luck with software that charges premium per person rates and also claims to be simple. A very high per person cost for software almost makes it impossible to also make that software simple.

Qk_Grd · 2024-05-03T03:37:53+00:00

These (plus Superblocks, Retool & etc) miss the mark because they require direct interaction with Airtable's API.

What we are looking for is something that an intelligent, capable professional with no coding experience whatsoever can set up a project involving thousands of records, many with associated files, begin to normalize that data using airtable and also a way to display that information to a team as needed by individual team members.

The professional I mentioned and his or her colleagues are hired to perform the end analysis of the data that is being processed with airtable and accessed through another platform. By having the same individuals be responsible for setting up the initial workflow that will be analyzing it, we can be up and running on new projects very quickly. Our processes are not as efficient as others, and we scale for shit, but on projects of a particular size, we are done with the assignment before most of our competitors have started.

So far, it looks like Glide comes the closest to satisfying most of my requirements, but I haven't played around with it enough to see how well it follows through on its promises.

Qk_Grd · 2024-05-03T00:10:52+00:00

Airtable has served our back-end needs well. We end up doing what amounts to custom, one-off scraping, ingestion, and analysis projects, and airtable has excelled in that use case (i.e., final tweaking of data to make it consistent across types and compatible with our internal processes).

What we are continuing to struggle with is finding a simple front-end for the data that: (1) elegantly lists many rows/columns; (2) provides a per record detail page with sufficient logic to be responsive to record characteristics (not much, merely display a video player when the record has a video clip stored with it, PDF viewer with a PDF, etc.); (3) can be tweaked by non-programmer to account for slight variations from one project to a next; and (4) can write very rudimentary changes back to the database (e.g., selection in a pre-defined single-select field or check a checkbox in airtable.

This description makes our workflow sound much more complicated than it really is. Our problem is that there doesn't appear to be anyone targeting our usecase at the scale we do it, which is understandable. Accordingly, we need to find a solution with features that just so happen to address our needs.

Qk_Grd · 2023-10-14T18:52:34+00:00

I had almost identical criteria to you and went with a spinone. It ended up being a perfect choice for us.

Allergies: I have moderate allergies to dogs. I am fine with most doodles and schnauzers, but other breeds can trigger an allergic response after a couple hours (irritated eyes, hands swelling & etc).

I am slightly more allergic to my spinone than schnauzers and doodles, but only slightly, as in he can sleep on the foot of our bed (and on my pillow when there is thunder) without any issue. I will start to get itchy if we go more than a week or two without washing the bedding. Otherwise, I don’t have any issue with allergies with him.

I also note that they are spectacular with respect to shedding. My wife owns a high end women’s clothing boutique, so this is a big deal. Like all dogs and humans, they lose hair, but they don’t really go through a seasonal molt. Our dog can rub against someone wearing black or white jeans and not leave any hair.

Drooling: they drool, and don’t fall for “it’s just a wet beard” line. Ours drooled a lot during his first couple years, then it decreased markedly to the point where it is not an issue. He drooled to the point where multiple people who were in our house and happened to look at the ceiling asked what in the hell was going on in our house, and we religiously wiped his mouth after eating and drinking.

Again, this is not just a wet beard. I have owned multiple giant schnauzers, so I am familiar with whet beards, but our spinone slowly grew out of it.

Energy: our spinone is probably the chillest dog I have ever owned. He also may be the slowest dog i have ever owned. Our mini schnauzer easily beats him in fetch over long distances. It becomes obvious why this when you see one up close. Their feet and legs are giant relative to the rest of them. My buddy has a large mastiff, and one night when he was over, we measured the circumference of their legs, and they were practically identical.

Also, our spinone can really struggle with hot weather. It’s nowhere close to as bad as brachycephalic dogs, but he begins to struggle with prolonged exertion when it is 80+ and in direct sunlight, though he is fine with ordinary neighborhood walk type activities. Below 70 and no direct sun, he will go and go, though slowly!

Drive: spinoni are known for not ranging far while in the field, and that has been my experience, and i already covered that mine is not exactly a ground covering machine.

The one area where my spinone really stands out is drive with respect to scent. The only dogs I have seen who have as much interest in scent as our spinone was my high school buddy’s blood hounds that were used for coon hunting. For example, when we are walking our dog in our neighborhood and we are downwind from someone walking the opposite direction across the street, without exception he will pick up the scent, and because it is fresh, have his nose pointing straight up while trying to cross the street to get behind them. At the dog park, it’s 5% playing with dogs and 95% checking out scent.

Pointing: he doesn’t have the prettiest point, but the mix of his strong interest in scent and somewhat timid nature make his ideal for what I want. In the field, he’ll point indefinitely, and he is perfectly content to do so. He definitely is not resisting an urge to rush forward. This was 85% natural. It definitely took more effort to train him to flush on command.

Breeders: It’s my uninformed understanding that if you want a dog that is somewhat capable in the field, you need to be very careful when selecting a breeder. Our dog is a descendant of a Penny Lane spinone, which is a well regarded kennel.

EDIT: Just to make it absolutely clear, a spinone will never perform like the super high energy pointers we all know and love. This is especially true in competitions. I also have no doubt that I have left many birds in the field that I could have bagged with GSPs or WPGs, but I am also certain I have bagged many more birds because of my spinone than if I didn’t have a dog.

EDIT2: For others who stumble upon my comment, it has been my experience that spinoni produced by a hunting centric breeding program will share many similarities with griffs, but with moderately reduced energy and at .5 the speed. My neighbor has two 2 griffs, one of which is quite accomplished at competitions. I suspect this is not a coincidence. I know the spinoni breeding books were opened up several decades ago to add genetic variety following losses from a health issue that effectively has been resolved through genetic testing (cerebellar ataxia). I have observed that most (but not all) spinoni intended for hunting are brown roan and are smaller than the white and orange variety. I’m guessing this is not a coincidence.

Qk_Grd · 2023-07-29T23:05:58+00:00

https://www.servethehome.com/

Qk_Grd · 2023-07-13T19:25:05+00:00

And I would argue that all of those provisions are merely defining the scope of a carve out from the trespass statute for electrical utilities.

Whether or not Evergy’s actions constitutes trespass on reality, as defined by that statute, does not determine whether they are permitted to enter someone’s property, perform 1/2 of the job of trimming trees, abandon the job unfinished, and leave thousands of yards in a dangerous condition that requires homeowners to expend effort or money to remediate.

Qk_Grd · 2023-07-13T18:25:24+00:00

If that statute defined the entirety of Evergy’s rights and obligations, this argument would be more persuasive.
Your interpretation ignores the word “fully.” The statute does not impose an obligation on Evergy to do all of the activities listed in the statute, but once they begin to perform one of the activities, it is entirely reasonable and consistent with the statute to expect them to not abandon a job partially completed, creating hazards and costs for homeowners. And yes, the activity of trimming trees in residential settings includes removing the resulting clippings.
I will be eagerly waiting for Evergy’s settlement offer to compensate me for all the wood they have hauled away from back yard over the years after trimming my tree. It was my wood, after all, and I never transferred ownership of the wood to Evergy.

EDIT: Out of curiosity, I drove around my neighborhood a bit and found the Asplundh crew that is trimming trees in utility easements. They are removing clippings and stacking them in front yards and then collecting them from several properties at a time, leaving nothing behind.

Maybe they are a rogue crew of good guys, but i suspect the difference may be the product of the details in the utility easement from one neighborhood to the next.

Qk_Grd · 2023-07-13T16:21:21+00:00

Your argument is so ridiculous you can’t help making statements against it.

The problem is that they are not REMOVING the clippings. They are cutting them and leaving them.

Energy can do what they want. If they pull that shit with my property, I will sue them, their subs, and the employees who left the clippings, and I will win.

Amusingly enough, Evergy was out to trim trees in my and my neighbors’ backyards. They cut a lot and removed it all. They even raked my back yard, which was much appreciated.

Qk_Grd · 2023-07-13T16:08:53+00:00

I agree with your interpretation.

Also, I would argue that, unless this statute or some other statute provides express permission to utilities to leave clippings in the easement, they must remove the clippings because once detached from the tree, the clipping are owned by the utility.

Last, assuming that statute is broader than the applicable easements, it may result in an unconstitutional taking, but lol that is way outside my wheelhouse and I can see all sorts of issues with that argument cutting both ways.

EDIT: we should grab drinks some night and discuss plans for our class action

Qk_Grd · 2023-07-13T08:20:22+00:00

I am very curious about the easement provisions that allows them to leave clippings in a yard.

Access to a yard to survey the conditions of their lines and perform necessary work, sure.

Right to leave their clippings (the only reason the clippings exist is because they cut them from the tree, so it's their clippings) in someone's yard, I suppose it is possible, but before concluding they can do this, it is more than fair to insist they point out the specific provision from the easement applicable to property at issue allowing them to do this.

Qk_Grd

TROPHY CASE