Making a daily list export script, and want to have the actual field names be a header at the top of each column (this is an order that gets e-mailed as an Excel spreadsheet every day). How do I get the field names to output as the first record? Thought it would be obvious but I think I'm missing it...

Export as "Merge" format. It puts comma-separated field names as the 1st row. Or upgrade to 8, where you could Save As Excel and attach to an email in 1 step (or a few more if you want to send immediately).

Ah, brilliant, thanks. And I really should get up to 8. That feature alone is something I could really take advantage of. Appreciate your feedback!!!

I have a database with fixed fields of church boyscout merits.

Full Name

Field Name for example (Red Compass) Date earned for example (12-10-2006)

I need to beable to transfere the The Boys full Name and the Merit field name and the date earned to my Advancements Database that has a merit Name Field and a merit Completed Date field.

Getting the date out of the date field is easy but getting the Field name out to a Field that I can cut an paste in is the hitch I am stumbling over.

Any one have a suggestion on this. Get(ActivefieldName) didn't get me where I need to go.

Any help is or suggestions is appreciated.

Mark Jones

Edited December 4, 200619 yr by Guest

Well after reading a few great messages here on the forum. I saw that a script was the only way to Get(ActivefieldName) to work. I then used Get(Field Name) to grab the date of that merit as well.

Before this a took the two (Global)fields and added a text field that I had setup to contain the information. Then just cut and pasted it with a comma after each entry to create a field that contained the results of the script. Each time I click in a field I click on the script button and it adds a ine to this text field. I then have a button that exports the file contents to a file. This creates a dandy Excell importable file and a file to import into my Advancmenet Records Database. SWEET!

Here is what the text file looks like as each is clicked in and the script button is ran. 2 fields were clicked in.

Mark Jones,Red Compass,12-10-2006

Mark Jones,Red Cooking,06-11-2005

This forum is a Godsend. I appreciate the genius that is in these forums. You guys and gals make this a most treasured resource. THANKS!

Mark Jones

I have a website that has a bunch of Solutions I have compiled for Royal Rangers and other things.

http://readyrangers.tzo.com