I have a custom db table called "membership". The table appears as below:
membership_no(pk) | bronze | silver | gold 1000001 | no | no | yes 1000002 | yes | no | no
What id like to do is:
Add a custom field to registration form that asks for membership number.
Validate membership number input against database and if value exists get that row.
3 Assign the customer to a customer group dependent on membership type of the selected row?
Any ideas? (using v18.104.22.168)