Count the number of times a record is emailed?

[xardoz]

I've got my tech. support request DB set up with CDML/HTML pages on our intranet. When a techie enters or changes a record, he's got the option to email the updated ticket to the user.

However, I'd really like to track how many times a record has been emailed.

I'm a complete novice with FMP 6 scripting, so I'm totally in the dark here.

Also, if my DB has a STATUS field with two options, PENDING and FIXED, how can I track how long a record has remained NOT fixed? I.E. - This ticket has been active for XX days. Right now we're doing simple math, but my boss wants a daily counter field if possible.

Thanks!

[David Holmberg]

1.

Create a numberfield, I'll call it emailcount

If the email option comes up as a message with one button called E-mail and the other xxxxx it could look something like this:

Show message

If(get(messagechoice)="E-mail")

Set field(emailcount;emailcount+1)

-----the rest of the email script----

Else

-----things to do if the techie don't want to send an email----

End IF

2.

When the statusfield is set to pending (what does that mean) there could be a script that fills a datefield with the current date (get(today))

Then you could have a calc field which looks like this:

calcfield= Get(today) - datefield

This works if you never go back to fixed....