Jump to content

How to create user-friendly export menus?


This topic is 6121 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello-I am looking for some help, maybe even a starting point.

I would like a user to be able to select either single or multiple fields from multiple menus, and then have each of the selected fields exported to Excel. For example, say the user selects #'s 123,125,126 from a "Product" menu, a range of dates (6/5/07-6/8/07) from a second ("Date") menu, and selects the desired output from a third menu (say, "Total # sold") for each Product ID. I would like Filemaker to then take only the user requested data and export it to Excel. I already know how to do this with Filemaker's "Export" menu, but I was hoping to make it more of a "user-friendly" function.

Any ideas?

Link to comment
Share on other sites

This can be done but it's a bit of work.

It invloves hard-coding several calculation fields that get exported (as many as you want to users to be able to select). Each calculation is based on the entry in a field which the user selected a field name from.

Link to comment
Share on other sites

The date range is easy to implement and a good idea.

However I like to remind clients that is it far, far cheaper and faster for users to get a one-size-fits-all excel export file and delete the dcolumns thet don;t want, compared with a developer haning to sit down and create a kama-sutra like web of export options for each user (because each user will want something different, and some might want more than one).

Link to comment
Share on other sites

Thanks for your help Vaughan.

I suppose you're right; exporting to Excel is a more efficient means of filter/sort. Sometimes I get into the habit of creating "exotic" design ideas that become complex, time consuming projects not worth the while!

Common mistake for a novice, I'm sure.

Link to comment
Share on other sites

Don't know if this is any help, but here is a link to a sample file that does a user defined import. Perhaps you could use a similar technique to do a user defined export.

http://fmforums.com/forum/showtopic.php?tid/87713

Edited by Guest
Link to comment
Share on other sites

This topic is 6121 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.