Copy All Script

[JimmyLewis]

Hi,

I have created a financial db tracking all my finances. There are instances, however, where within the current found set all my transactions need to be labelled, either with store_name (the store name), category, etc. For instance, if I loaded all transactions of "best buy" and i want to label every store_name field "Best Buy", i have to do it manually.

I want to create a script based on a keystroke enter (such as SHIFT+ENTER) that will automatically populate all transactions within the found set with the result i put on that given cell. i.e. i put "bank of america" in store name and click the keystoke, which prompts a warning and then results with all the found set being populated with "bank of america".

Any suggestions? it would be very helpful to me.

Regards,

Jimmy

[comment]

This is possible, but... if the store_name needs populating, how do you "load all transactions of "best buy""?

[JimmyLewis]

Hi,

every banking program uses a bizarre way of naming the transaction, i.e. "05345 Checkcard Star Market".

I label the store names for later use and sorting, but i can still go to "transaction_name" and search for "Star Market" and find all those corresponding to it. I have other ways as well, but i can get to the point where i have a bunch of transactions that need categories and store names. It would be easier if i could simply copy from one to all.

[comment]

I was just wondering if you couldn't automate the process by looking up the store name based upon some existing value. Because the way you want to do this is dangerous - there is no undo if you make a mistake.

Anyway, this feature is built in: after typing the desired value (and while the cursor is still in the field), select Records > Replace Field Contents… (or the keyboard shortcut =). There is also a corresponding script step, if you want to perform this without dialog.

[JimmyLewis]

great. is this within the found set or will it do it to every record i have in the db?

[comment]

Found set only.