Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
repeat customer flag
If we have a customer text field for a place to auto-flag repeat customers = Y or N... for reporting and other things.
how would you auto populate it nightly with a saved mass-update?
I tried things like a formula filter where {firstorderdate}-{lastorderdate}>0 then mass update the flag to 'Y' ... as yes this would be a repeat customer
I tried things like a formula filter where {firstorderdate}-{lastorderdate}=0 then mass update the flag to 'N' ... as this would NOT be a repeat customer because their first order and their last oder date are the same.
Everything I tried failed.