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.
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?