New user, request for help with text manipulation in Bruji's BookPedia

[Tom]

@MarkSealey

I believe it's failing in the loop:

on error
	set originalTitle to ""
end try

This shouldn’t be the reason. This is meant to avoid an undeclared variable in case the old title doesn’t have a colon (= no text item 2).

@MarkSealey

Would you prefer to email direct, take this offline here as it probably isn't of great interest to anyone not using BookPedia ?

No. This can still be of use for somebody with a similar database GUI.

@MarkSealey

is your macro designed to work when the records are displayed one-by-one, in the single Edit window; or as in your screenshot (above) displayed in BookPedia 's spreadsheet-like view?

Starting point is the window as shown in the screenshot.

@MarkSealey

If in the latter, I understand the importance of moving BookPedia 's columns so that at the left come: Title, Date Modified (on which the whole thing must be sorted, oldest first) then Original Title.

In the main window (is it called like that?) the order of the displayed columns shouldn’t matter (well, try to have the Title column at the left, since that’s how I tested it). What does matter are the positions of the Title and Original Title fields in the edit window, as shown in the last image here.

---

PS:

Another (unmentioned) assumption of my script is that the Original Title is empty for all records. (Otherwise it will just get overwritten.)