Forum Discussion
ArshadKhwaja
9 years agoQrew Commander
No prob. The only question that remains is how to get the resulting list show names of stores that are currently trading. At the moment it shows everything. Also, if we could somehow use a composite field with banner and name that will be even more useful
ArshadKhwaja
9 years agoQrew Commander
Thanks. In creating a formula similar to the following, I get an error, Choices too long - 4385 choices specified. Field may not have more than 50 choices.
If([Date Opened] > Today() and [Banner] = "WWWW", [Store Name])
If([Date Opened] > Today() and [Banner] = "WWWW", [Store Name])