Here is what I seek, please help: ( i am a newb)
Form 1: User A inputs name, email, and phone number, then submits.
Form 2: User B inputs a phone number which matches User A's resulting in a hidden field being populated with User A's email.
User A represents many other users, so in Form 2, the phone number field has to query all of the Form 1 submissions.
I also need to query other forms submissions. Like if I had a Form 3 where Users input phone number too, then submit. Form 2 must be able to query Form 3 also.
If anyone could please help, I would be grateful!
or
I can be more specific:
A user submits form 1 with name, phone number and email. Another user fills out form 2 with a phone number. A hidden field has code in the default value to query the database table jos _rsform_submission_values for the phone number (field name is 'phonenumb'). When a match occurs, the email (field name is 'email') data of the matching record is called and fills in the value of that hidden field in form 2.
This would accomplish what I am looking for. Can anyone help me with the code?
