Hi, I am not too good with PhP but have a good understanding of MYSQL.
Here is my business case:
1. I have created a form where my users can post jobs giving their contact info like email.
2. I have created a custom procedure wherein whenever there is a new job post, the SQL procedure will populate all the data in jos_content as 2 articles: The first one containing the basic info as a category list Public item and the second one containing the full details as a Registered article. The first article will have a Read More.. hyperlink to the second one. The whole idea is to give the users a snapshot of the jobs, but if they want to view the details, they have to login. My procedure, after creating the second article, populates a field called article_id in my chronoforms table. So there is a direct link between the Form data and the article id created.
3. Now when the user logs in and goes to the second article, he sees a button called Apply. Onclicking that, a new form will open where the candidate will fill additional info.
Requirement:
1. What I want is whenever the user applies for a job in the second form, the job poster and the applicant should get a notification. Is there any way that when the candidate opens the Apply form, that the system will retrieve the email address of the job poster by linking to the current article_id and looking up the jobpost table for the email address and populate it subsequently in the 2nd form as a hidden field.
2. The same has to be done for the applicant by looking up his user profile and fetching his email in another hidden field.
I can make the DB query but how to apply it in the forms.
Any help will be appreciated.
-ashish
Here is my business case:
1. I have created a form where my users can post jobs giving their contact info like email.
2. I have created a custom procedure wherein whenever there is a new job post, the SQL procedure will populate all the data in jos_content as 2 articles: The first one containing the basic info as a category list Public item and the second one containing the full details as a Registered article. The first article will have a Read More.. hyperlink to the second one. The whole idea is to give the users a snapshot of the jobs, but if they want to view the details, they have to login. My procedure, after creating the second article, populates a field called article_id in my chronoforms table. So there is a direct link between the Form data and the article id created.
3. Now when the user logs in and goes to the second article, he sees a button called Apply. Onclicking that, a new form will open where the candidate will fill additional info.
Requirement:
1. What I want is whenever the user applies for a job in the second form, the job poster and the applicant should get a notification. Is there any way that when the candidate opens the Apply form, that the system will retrieve the email address of the job poster by linking to the current article_id and looking up the jobpost table for the email address and populate it subsequently in the 2nd form as a hidden field.
2. The same has to be done for the applicant by looking up his user profile and fetching his email in another hidden field.
I can make the DB query but how to apply it in the forms.
Any help will be appreciated.
-ashish
Hi,
Thanks for posting this article. I glad that you presented this problem. I'll look forward for the answer.
Thanks for posting this article. I glad that you presented this problem. I'll look forward for the answer.
I have a similar problem. If someone can reply I'll be glad.
This topic is locked and no more replies can be posted.
