AnsweredAssumed Answered

Export script

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


Export script



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?