Debug Menu is not there

[John Chamberlain]

I am trying to write a script, and I'm having problems. I tried to turn on the Debug feature, but it does not show up in my Scripts menu. Is there a switch or a preference that I don't know about?

TIA

[-Queue-]

You need Developer edition if you want to have the Debug option.

Perhaps you could post your script steps or sample file(s), so we can help you debug?

[John Chamberlain]

Thanks Porter - I will get back on this in the morning (gotta' go wine tasting tonight!) I will send a sample file and a description of mny problem then.

[-Queue-]

Haha! I am not Porter--he's the leader of our band--but thanks for the compliment.

Wine tasting, such a chore...

[John Chamberlain]

Good Morning -

OK, Here is my problem. I have a file that generates letters spaced at 2 weeks, 2months, 4 months, 6 months, 9 months, 11 months and 13 months. The file generates a due date based on the data of death of a hospice patient, and the letters go to the deceased's Primary Care Giver. I am a volunteer for this particuular Hospice, and they have asked me to generate a monthly report showing how many of each letter type are sent each month.

I have been chasing my tail around this for three days, and getting nowhere. I have attached a stripped down version of the file to this message. The script I have been working with is called Monthly Counter. The button at the bottom of the page activates this script. The script copies the date range in the field above the button, performs a find on the first letter sent field, and then places that count in a holding field called "Letter 1 Total". It then repeats this step for the second letter sent dates, and so on.

My problem is that I can't get the first counter to remain at it's proper value. When it does the second find, the value in the first total field just disappears.

Any advice will be greatly appreciated.

TIA

BereavementDataBaseCopy.fp5.hqx

[John Chamberlain]

Slight error in the script I sent you.

It should read: Paste [select, "Letter 1 Total"]

With that it does paste the proper amount into Letter 1 Total but, after it executes the second step, it no longer displays the amount in that field. Try going to the report layout and do a Find >0 on both the Letter 1 Total and Letter 2 Total fields and you will see what I mean.

[John Chamberlain]

STOOOOOPPPP! I am so DUMB! Of course it works that way because Only the records that got modified have the amount in the field. Sorry to have wasted your time with this brain fart.

[-Queue-]

No problem. But see if the modified attachment works better for you. I have changed the date range field to be a global text field where you enter the month and year, separated by a forward slash, and added some fields that flag whether each date falls within the month specified.

Ideally, this would be a related structure, which would make the process simpler. But with a few tweaks, such as I have applied, it can still work fairly smoothly.

BereavementDataBaseCopy.zip

[John Chamberlain]

Queue -

Thank you so much for your help - the script you sent me is so much more elegant than the one I worked out (and then lost when my hard drive crashed) - mine was about 150 lines vs your 35 lines). It has taken me until today to get back to this, due to extensive reconstruction on my new internal drive.

Again, thanks a lot! :)