We have a custom app on Force.com where non-SF users will provide input using web forms that will create new records and update existing records in our app within the data model. The forms will be distributed to these non-users via email. We need to track the responses coming back into the Force.com app for accountability purposes. It is not acceptable for the "last modified by" field to be the FormAssembly API user with no tracing back to the actual form respondent. The issue is that we need to know specifically who provided the data and when. The system needs to provide the details of the form respondent as captured in the web form they completed. Are there any suggested workarounds to this dilemma?
Unfortunately as the 'last modified by' is set by Salesforce, it is not possible to control that from the FormAssembly side. I think the best bet would be to contact your Salesforce support representative and see if they can recommend some apex trigger code to set your preferred tracking field with data from the object after response submission.
Happy to answer further questions, FormAssembly.com Support.
To follow up on Drew's comment, you could also add custom fields to the object, and update those via the Salesforce connector. Again, using the 'last modified by' isn't possible because it's a system read-only field, and it can only refer to a Salesforce User.
Understood and agreed. A custom object field with respondent contact information could be mapped to a form field and displayed in the page layout next the system fields that could indicate the contact information of the last form respondent.