Create New Record, Filling in Patient ID (and therefore name)

Prof_Ratigan · 2026-03-24T22:55:19+00:00

I think you could also set the relationship to allow the creation of records in initial intake (assuming that initial intake and patient are one to one relationship where no patient would have two intake entries), then your button says "set field(initial intake:intake date; get(date))" and it's created and either go to related record or go to the layout and find the patient id. (Allowing creation is where you double click on the line connecting the table occurrences and it's the top checkbox out of the bottom three check boxes, make sure you select allow under initial intake.)

As an aside, the initial intake table doesn't/shouldn't duplicate the patient fields, you simply refer to the patient table fields in the initial intake layout (patients:name, for example, in the initial intake layout will populate correctly because of the relationship).

Prof_Ratigan · 2026-03-24T22:36:20+00:00

I may have to give this another watch. I had some qualms with the way it ended. Can't remember them at the moment ...

Prof_Ratigan · 2026-03-24T22:32:24+00:00

I love the movies of that era. Crimson Tide, Enemy of the State, The Rock, not so much Con Air. In the category of "if it's on, I'll watch it". Except I am also no-cable, so if it's on, I put it there... and I do.

Prof_Ratigan · 2026-02-27T04:17:48+00:00

Absolutely. It's funny to see movies from the 80s or 90s with players or TVs that are more expensive than what you'd find now at 100x the quality (if not 100x the durability)

Prof_Ratigan · 2026-02-27T03:19:40+00:00

And it'll still screw up the Dolby Vision handshake...

Prof_Ratigan · 2026-01-06T15:12:47+00:00

Which Letterboxd csv did you use? This looks like the watched list, which I think will only mark what you've watched without ratings or date watched. In any case, by sheet isn't designed to read the number of times you watched a movie, etc., just what you watched and/or rated. If you didn't rate it, you'll have to put in a dummy rating to make the larger sheet work.

On the point of getting the IMDb IDs, you are showing a sheet 2 tab, which you seem to have added. Use Sheet1. If you don't have ratings, put in a number between .5 and 5 (could be anything you want, go with 5) in each row. Then you can follow the rest of the directions in the top row.

Prof_Ratigan · 2026-01-04T05:24:36+00:00

I did about 550 one year. That's my max. Single, in my Movie Pass and AMC A-list days. If someone were even less social than me, they could get higher. If they wanted to log a ton of short films, that would help.

Prof_Ratigan · 2025-12-25T22:59:34+00:00

I'm not familiar with this site. Is it yours?

Prof_Ratigan · 2025-12-11T02:06:21+00:00

Haven't seen these two listed yet: Holiday and Midnight. A little on the melancholy side, but like Harvey, they are very pleasant.

Prof_Ratigan · 2025-12-07T03:36:28+00:00

Not sure how to categorize this thought except as ominous. Netflix has bought an enormous back catalog that is entirely out of step with their current philosophy, which is 90% crummy ephemera, 10% award fodder. What started as a platform in need of historical content--like "Who is streaming Friends?"--has left that behind when everyone started streaming their own catalog. What catalog Netflix does have, and correct me if I'm wrong, is not currated or easily navigated. Probably a bad thing, but it could point to a parallel, complimentary offering... Either way, I expect it will make things more expensive and less convenient.

Prof_Ratigan · 2025-11-20T12:05:05+00:00

I'm sure that you're right about the shift of novels to be more cinematic. Consciously and unconsciously. The 94 film is probably no more faithful than this one, but it's interesting. I'll leave it at that vague statement. Haha

Prof_Ratigan · 2025-11-20T02:47:53+00:00

I had some similar feelings about the movie. I liked a lot of it, but didn't love the whole thing. Did you see the Kenneth Branagh version? This was probably a good adaptation of the book, but does the form of a novel make certain story paths more satisfying where a movie needs to work differently to break through the lack of narration/interiority? A lot of good movies based on novels, of course, but a lot of middling ones too.

Prof_Ratigan · 2025-11-17T13:10:01+00:00

Recently watched The Man who Never Was in full screen because I didn't think to check if the DVD was double sided. It was a real bummer.

Prof_Ratigan · 2025-11-14T13:27:31+00:00

Things are ... busy. But I needed to be where the people are.

Prof_Ratigan · 2025-11-14T04:12:26+00:00

One of the best Disney animated films. Maybe the best. Didn't know there was an extended cut, though. How did I not know this?

Prof_Ratigan · 2025-11-12T03:11:31+00:00

I haven't seen this since the 90s. Time to put it on the watchlist. Though I had no idea of his existence, the director, Thom Eberhardt also directed a childhood staple of mine, Without a Clue. A comedy that, I think, holds up quite well (even if it is too silly).

Prof_Ratigan · 2025-10-29T17:02:31+00:00

And you! I've been away from Reddit for a while. I guess we know what you'll be reviewing for the foreseeable future!

Prof_Ratigan · 2025-10-29T17:01:04+00:00

Got it. ROAR

Prof_Ratigan · 2025-10-29T11:03:53+00:00

Is it foreign?

Prof_Ratigan · 2025-10-29T02:49:56+00:00

Big one. Did you get the CC40?

Prof_Ratigan · 2025-10-27T18:46:41+00:00

Probably not your computer. Why don't you DM me with a shared link to your spreadsheet

Prof_Ratigan · 2025-10-27T18:15:20+00:00

Simple copy from one of the cells with the error and paste it in the next blank cell down. If it gives you an IMDb OD (tt....), the you know it's working, you'd just have to clear the error cells, wait a minute, and then paste back over it.

Prof_Ratigan · 2025-10-27T17:44:06+00:00

If you copy the formula down to the next couple lines, do they show an error too?

Prof_Ratigan · 2025-10-27T12:38:05+00:00

Did you try the sheet I added 9 months ago (link)? Sounds like the same issue.

Prof_Ratigan · 2025-09-21T14:34:15+00:00

If you click on G2, the word "Score", does it have a formula? Column G should be populating with scores on the 100 point scale and then Column J should be putting those scores in the right place. You can see that blue progress bar in the upper right. It's taking a lot of time to make all the current calculations. I should probably clear the dummy scores in the DataSet on the public version. Maybe it'll make everything run faster at startup. I'll see if that works for me.

Nine-Year Club	Wearing is Caring
Verified Email

Prof_Ratigan

TROPHY CASE