This forum is no longer open and is for reading/searching only.
Please use our new MachForm Community Forum instead.
MachForm Community Forums » MachForm 2
Cross Reference Entry
Started 13 years ago by teamwebb2008 | 3 posts |
Is there a way to cross reference an entry? We have membership renewals coming up. If the member already has a completed form, they only need to fill out the renewal form without all the additional information. What I am trying to do is after their Member ID is entered, if they already have a completed form they should be redirected to renewal form only. Is this possible or do I need to go to the PhpMyAdmin and make the query first then use redirect on this query?
I think the easiest way would be creating a form with only one field, which is Member ID.
Then during form submission, do the query to check the Member ID.
Do the redirect to the next form based on the query result.
Another alternative (but slightly more complex) would be implementing Ajax call for your Member ID field. So after typing the Member ID, you do an ajax call to a backend script, the backend script then do a query to check the member id status.
Based on the result of this ajax call, you can do immediate redirect to the next form or not.
Once again, perfect advise!! Thanks :)
You must log in to post.