From Dwayne Wright PMP
Certified FileMaker Developer
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).
A READER ASKS
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 firstname.lastname@example.org.
© 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.