A READER ASKS: Date Picker For Imported Records

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here).

How can I incorporate a "date picker" to an import? This way I could attach a billing date to the "Billing_Data" so I could import files from many months.


Well, you would want to add a field to the Billing Data table called import date. Then you would want to create a global field to hold that data temporarily. When the script does the import, use the Show Custom Dialog script step to give you the ability to type in the date you want included on those records. After the import takes place, you would use a Replace command to put the data from the global field into the new import date field.
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.