Oct 16
Roger Moffat How to test if an entered value is a member of a value list
Oct 16, 2009; 04:43
Roger Moffat
How to test if an entered value is a member of a value list
I have a simple online registration system running for an upcoming
Seminar.
As an incentive to get more people to register, we're thinking of
offering a "bring a friend" coupon, so that if you've already
registered, and can convince someone else to register, you would get a
coupon, and the friend gets a discount (you can't get a discount since
you're already registered and paid).
To implement this I was thinking of telling the current registrants to
tell their friends to use a coupon code that is made up your last name
and your registration number. So for example I'd tell people to use
Coupon Code "Moffat 1"
But I'm stumped about how to at the time of registration test that
this code is a valid code, and so if it is, give the new registrant a
discount
I set up a value list made up of the lastName and the OrderNumber, so
that this list is continually updated, but I'm stumped on how to have
the "price calculator" test to see if a value in the CouponCode field
is a member of that Value List.
Currently the Price calculation is
Case (
(Session1 = "None" and Session2 = "None" and Session3 = "None") ; "0" ;
(Session1 = "" and Session2 = "" and Session3 = ""); "0";
Get ( CurrentDate ) ≤ Date ( 10 ; 20 ; 2009 ) and LeftWords
( CouponCode ; 1 ) = "BringAFriend"; "46";
Get ( CurrentDate ) ≤ Date ( 10 ; 20 ; 2009 ) and CouponCode =
"EASTMAN"; "45";
Get ( CurrentDate ) ≤ Date ( 10 ; 20 ; 2009 ) ; "50";
CouponCode = "EASTMAN"; "54"; "60")
Which is saying
If you didn't choose any sessions (or chose them all to be None), then
it's $0
If it's before 20 Oct 2009 and you've used CouponCode EASTMAN then
it's $45
If it's before 20 Oct 2009 it's $50
If the CouponCode is EASTMAN it's $54
Otherwise it's $60 (no coupon and after 20 Oct 2009)
So I need to add a line before or after the first line with CouponCode
= "EASTMAN" to test if the coupon code is a member of the valueList.
Can someone suggest a way I can accomplish this?
Many Thanks
Roger the Bamboozled FileMaker Person
--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/
Oct 16
Clayton Randall Re: How to test if an entered value is a member of a value list
Oct 16, 2009; 05:05
Clayton Randall
Re: How to test if an entered value is a member of a value list
Oct 16
Roger Moffat Re: How to test if an entered value is a member of a value list
Oct 16, 2009; 05:16
Roger Moffat
Re: How to test if an entered value is a member of a value list
Oct 16
Steve Cassidy Re: How to test if an entered value is a member of a value list
Oct 16, 2009; 05:27
Steve Cassidy
Re: How to test if an entered value is a member of a value list