AnsweredAssumed Answered

Export script

Question asked by MikeF on Jan 2, 2012
Latest reply on Jan 3, 2012 by philmodjunk

Title

Export script

Post

 

Would like a script to:

Filter layout Companies for CompanyTypeID = 4.

Export fields CompanyID, Company, CityID, City to the same Excel file and sheet, overwriting the previous export.  Essentially a simple update.

Already have:

Go To Layout = Companies

Perform Find [Restore] CompanyTypeID = 4

 

... But it seems ExportRecords wants to create a new Excel file.

I merely want to copy the filtered table's four fields to the same sheet, say D:\Filemaker\CompaniesCities.xlsx  --- sheet name CompaniesCities.

Can this be done?

Thanks,

  Mike

 

 

Outcomes