Jump to content

Importing 2 weeks


amigo
 Share

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

Recommended Posts

  • Newbies

Hi all,

Was wondering what the best way is to import the last 2 weeks of data from one filemaker file to another Filemaker file with a scripted button? Both files have the same layout.

Any help would be great

Link to comment
Share on other sites

Use a script with the Import Records script step. There is a restore option you can use to remember the import order of the fields. In other words, once you make the script, it will always import the same fields.

You'll also want to add a script in the source file that finds records from the last two weeks. That's because when you import FileMaker to FileMaker, only the found set will be imported. But, watch out! Make sure the source file is open or FileMaker will assume you want to import all the records.

Your find script might look like this if you want it to import based on the current date:

Enter Find Mode []

Set Field [MYTABLE::DateField; (Get(CurrentDate) - 14) & "..." & Get(CurrentDate)]

Perform Find []

You could also replace the Get(CurrentDate) function with a global date field and add a Show Custom Dialog with the global field as the input for the date you want to start with and go back 14 days.

Link to comment
Share on other sites

This topic is 5679 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
 Share

×
×
  • Create New...

Important Information

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