Hi!
I�m a newbie to alpha5. I have been developing a website that allows multiple users simultaneous data entry and view. I have been unable to get my head around an automated email function, would you be so kind as to help?
I have a table called �venues� which has 4 fields of particular note, them being �usergroup_1� , �usergroup_2� and �cancelled� the former 2 are character fields containing usergroup names. The later �cancelled� is a logical field.. When a venue is cancelled, the �cancelled� field = .f. I mentioned 4, the 4th being a date field.
I have another field called �customer� which lists the names and email addresses of customers. The important fields here are �usergroup� and �customer_email� (usergroup being the same info in either usergroup_1 or usergroup_2 in the venues table for any given record)
What I want to do is on 8.00am, each day, A5 will check the venues table, all cancelled venues (all records with cancelled = .f.) whose date also is equal to the current date A5 will match the �usergroup _1� and �usergroup _2� fields in the record/s with the �usergroup� field in the �customer� table, lookup the relevant customers and email a cancellation note to each of their email addresses.
any help would be much appreciated
I�m a newbie to alpha5. I have been developing a website that allows multiple users simultaneous data entry and view. I have been unable to get my head around an automated email function, would you be so kind as to help?
I have a table called �venues� which has 4 fields of particular note, them being �usergroup_1� , �usergroup_2� and �cancelled� the former 2 are character fields containing usergroup names. The later �cancelled� is a logical field.. When a venue is cancelled, the �cancelled� field = .f. I mentioned 4, the 4th being a date field.
I have another field called �customer� which lists the names and email addresses of customers. The important fields here are �usergroup� and �customer_email� (usergroup being the same info in either usergroup_1 or usergroup_2 in the venues table for any given record)
What I want to do is on 8.00am, each day, A5 will check the venues table, all cancelled venues (all records with cancelled = .f.) whose date also is equal to the current date A5 will match the �usergroup _1� and �usergroup _2� fields in the record/s with the �usergroup� field in the �customer� table, lookup the relevant customers and email a cancellation note to each of their email addresses.
any help would be much appreciated