asked on

Automatically updating a field in filemaker

I am creating a subscriptions letter and I need it so that when a letter is printed the entry notes field is updated. I don't want the content in the field erased I just want it added to with something like a line break and then
"22/5/09 six month expiry letter sent."

Is this possible?

ASKER CERTIFIED SOLUTION

North2Alaska

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jonathan-dunstans

ASKER

Well I would just run it after it has printed as I already have that bit working see code.

In your code am I right in thinking in Set Field the first table::column announces where the information should go and the second gets the information and adds it into the field with the additional in also.

I guess to get the current date as opposed to a recurring 22/5/09 I would just put // as usual?

Constrain Found Set [Restore] //deletes people we don't want the letter sent to
 
Go to layout["letter"](subscribers)
 
Print Setup
Print[restore]
 
code to enter text into notes field goes here
 
 
perform find [restore]

Open in new window

North2Alaska

Yes. The "Set Field" script step accepts two parameters. 1) the field you want to set, 2) the value you are setting it to.

#2 can be a calculation and in that calculation you can do what you need to add the new comments to the existing comments. That calc may look a little more like this:

subscribers::notes & ¶ & Get ( CurrentDate ) & " six month expiry letter sent."

Open in new window

jonathan-dunstans

ASKER

Thanks it is working fine and dandy now, I really didn't have a clue.