I have a form where I am collecting confidential information from businesses so that an expert can provide them with business advice. In order to ease the minds of businesses who will be filling in the form, the Project Manager wants to be the only one that knows who filled in the form (he is not a PerfectForms user and he does not want any of the PerfectForm admin to be able to access it either). The idea is that all of the form data (except for the business name) will be passed on to an expert for analysis. The expert then gives the analysis to the Project Manager, who sends it to the business himself (so that the expert never knows who had filled in the form).
I had thought that I could solve the problem using notification emails. After the form is submitted, the contents are sent to the Project Manager in an email and then the "business name" field is set to contain another value (such as the Instance ID so that there is a way to cross-reference). That way, the business name would not be saved in the database and the Project Manager is the only one who sees it.
I set up my behaviour on the submit button like this: Notification (to Project Manager) -> Set Field (Business Name to Instance ID) -> Submit Data. However, it did not work as expected. The email contained the Instance ID instead of the business name. This happens even if I set the field after Submit Data.
Can anyone think of a way to fix this? Or another way to do it? I've hit a roadblock!
Thanks,
Renee
