Are you an expert in FMP and can devote some time to doing a fast project this week? If so, read more and apply...
Create a FileMakerPro script that would accomplish the following goals:
1. Run through an existing data set to determine the first record per user email address. Tag this record as the "primary user record".
2. Pull "Product Id", "Date of Sale", and "C3" from "primary user record" and apply to fields "oPID", "oDOS", and "oNetRev" respectively based on email match. NOTE: Each customer will have only 1 unique "primary user record" and the values from that "primary user record" should be
3. Calculate new field "daysPostSale" by subtracting "oDOS" from "Date of Sale" and record in the daysPostSale field per record.
• Create scripting in a way that these functions are easily repeatable with new data (replacing the old data set completely).