I'm trying to build a simple job posting list for our web site.
I have two menu items: (1) "Post a job", and (2) "List Jobs".
For (1) "Post a job", I created a CF5 form that allows the employer to enter job information which is saved to a table when the form is submitted.
For (2) "List Jobs" I created a CC5 connection to list all the jobs in the table by ID#, Position tile, and Employer. The ID# is unique for each job.
So far, so good ... both of those are working.
I'd like to allow the user to select one of the jobs in the listing and get all the information about it. My questions are:
(1) How do I find out from the user which job he/she wants to view? Is it possible to make the ID# in the "List Jobs" list a link to that record in the table so the user just clicks on it? Or can the "List Jobs" CC5 connection have a prompt for the user to enter the ID#?
(2) To display all the information about a position would I do it using another CC5 connection?
I have two menu items: (1) "Post a job", and (2) "List Jobs".
For (1) "Post a job", I created a CF5 form that allows the employer to enter job information which is saved to a table when the form is submitted.
For (2) "List Jobs" I created a CC5 connection to list all the jobs in the table by ID#, Position tile, and Employer. The ID# is unique for each job.
So far, so good ... both of those are working.
I'd like to allow the user to select one of the jobs in the listing and get all the information about it. My questions are:
(1) How do I find out from the user which job he/she wants to view? Is it possible to make the ID# in the "List Jobs" list a link to that record in the table so the user just clicks on it? Or can the "List Jobs" CC5 connection have a prompt for the user to enter the ID#?
(2) To display all the information about a position would I do it using another CC5 connection?
After much fumbling around, I've gotten to this point:
I have two CF5 forms-
(1) Employment_Available
(2) Show_Job
and one CC5 connection:
Get_Employment_Available
Form (1) is for data input by the employer. Form (2) started as a copy of Form (1) but was modified a bit to change the screen prompts. Both use the same table.
Get_Employment_Available also uses the same table. Under Front List | Actions, for Form Event, I entered the second form name Show_Job. I changed the Public view permission to Allowed. In Front List | Settings, I set View Linkable to ID#, Position title, and company name (using a model and the correct field names)
When I check the webpage and select List Jobs, ID#, Position Title, & Company are listed correctly for each job. If I click on any of them, the Show_Job form opens, but it's empty. How do I force it to retrieve the data for the selected position? What am I missing in my connection?
I have two CF5 forms-
(1) Employment_Available
(2) Show_Job
and one CC5 connection:
Get_Employment_Available
Form (1) is for data input by the employer. Form (2) started as a copy of Form (1) but was modified a bit to change the screen prompts. Both use the same table.
Get_Employment_Available also uses the same table. Under Front List | Actions, for Form Event, I entered the second form name Show_Job. I changed the Public view permission to Allowed. In Front List | Settings, I set View Linkable to ID#, Position title, and company name (using a model and the correct field names)
When I check the webpage and select List Jobs, ID#, Position Title, & Company are listed correctly for each job. If I click on any of them, the Show_Job form opens, but it's empty. How do I force it to retrieve the data for the selected position? What am I missing in my connection?
OK, getting closer.
In my CC Get_Employment connection, I have a Model Title of Jobs. In the Front List, my Columns list is:
Jobs.id:ID
Jobs.position:Position
Jobs.co_name:Company
and View linkable is Jobs.id:ID
This gives the user a list of jobs with the ID as a link. When the user clicks an ID, it opens the Show_Job form which should pull the data for that ID out of the table. The problem I'm having is communicating the ID number from the Get_Employment connection to my Show_Job form.
In Show_Job form, in DB_Read on the Basic tab, I'm not sure what I should be using in the Conditions window. I know I have to have something like:
<?php
return array( 'id' => 'var_name');
?>
But I don't know what to use for 'var_name'.
In my CC Get_Employment connection, I have a Model Title of Jobs. In the Front List, my Columns list is:
Jobs.id:ID
Jobs.position:Position
Jobs.co_name:Company
and View linkable is Jobs.id:ID
This gives the user a list of jobs with the ID as a link. When the user clicks an ID, it opens the Show_Job form which should pull the data for that ID out of the table. The problem I'm having is communicating the ID number from the Get_Employment connection to my Show_Job form.
In Show_Job form, in DB_Read on the Basic tab, I'm not sure what I should be using in the Conditions window. I know I have to have something like:
<?php
return array( 'id' => 'var_name');
?>
But I don't know what to use for 'var_name'.
This topic is locked and no more replies can be posted.