There is no default feature for this, and it will require some custom scripting. I will provide the entire implementation, as well as some explanations (please note that, because I have no information about your exact same scenario, I will implement something similar and you will need to adapt it for your custom case).
What you need:
1. You will need to create 2 forms, one for the customer through which he will submit his question - 'Customer', and one for the staff member, through which he will submit his reply - 'Staff'.
Customer (id=1):
- This form will include a text area named 'Question', a text area called 'Staff reply' (will not be displayed in the frontend) in which the staff reply will be later added through a script and, of course, a submit button.
Staff (id=2):
- Includes a text area named 'Reply', a hidden field called 'SubmissionId' which will be later filled by a script with the id of the submission the staff member replies to and a submit button.
You will also need two 'View Submissions' menu items, one for the customer (called 'Customer submissions') in which he can view both his submission and the staff reply, and one for the staff members (called 'Staff reply'), in which they will only be able to see relevant information. You can configure the 'View Submission' menu item's Row and Details layout to include submission information of your choosing through the use of placeholders, you can read more on this topic here:
www.rsjoomla.com/support/documentation/v...-view-menu-item.html
Both menu items will display submissions for the 'Customer' form.
Implementation:
- head to Components >> RSForm!Pro >> Manage Forms >> edit the 'Customer' form >> edit the 'Staff reply' text area >> add the following code in the 'Additional Attributes' area:
style="display:none";
This will render the field to not be displayed in the frontend.
- head to Components >> RSForm!Pro >> Manage Forms >> edit the 'Staff' form >> edit the 'SubmissionId' text area >> add the following code in the 'Default Value' area:
//<code>
$myparameter_value = JRequest::getVar('SID');
return $myparameter_value;
//</code>
- eit the 'Customer submissions' menu item and add the following code in the 'Row layout' area:
<table width="100%"><tr><td>{Question:value}</td><td>{Staff reply:value}</td></tr></table>
- edit the 'Staff reply' menu item and add the following code in the 'Row layout' area:
<table width="100%"><tr><td>{Question:value}</td><td><a href="http://localhost/25/index.php?option=com_rsform&formId=2&SID={global:submissionid}">Reply</a></td></tr></table>
This code will add, in the row layout, a link to the 'Staff' form. The submission id is sent through that link in order to indetify the submission to which the reply is added.
You can control which users see the menu items from the menu items' configuration (the 'Access' drop-down).
The final step of the implementation is to map the 'Reply' field of the 'Staff' form with the 'Staff reply' field of the 'Customer' form. We will achieve this using the 'Mappings' feature, you can read more about it here:
www.rsjoomla.com/support/documentation/v...database-tables.html
- Edit the 'Staff' form, head to Properties >> Mappings and click on 'New Query'.
- Select 'Local' in the 'Connection type' radio group.
- Select 'Update' in the 'Method' radio group and click on 'Connect to database'
- Select the 'database_prefix_rsform_submission_values' table
- add {Reply:value} in the 'FieldValue (text)' text area
- add '{SubmissionId:value}' in the 'SubmissionId (int)' text area and select 'Equals' in the associated drop-down
- add 'Staff reply' in the 'FieldName (text)' text area and select 'Equals' in the associated drop-down
- click 'Save'
Now, the information submitted within the 'Reply' field of the 'Staff' form will be saved in the 'Staff reply' field of the 'Customer' form in the database.
