Forums

You can change the WebToLeadsCapture.aspx file to use cmdLEADS_Update so that you can set the MODIFIED_USER_ID field. This will also set the CREATED_BY field for the new field. It is a bit more difficult because you need to manually set the value of each parameter.

OK I made the changes.
Can you add this changes to the next release of splendidCRM?
if you do so here are the code I edit:

Changed this:
IDbDataParameter parMODIFIED_USER_ID = Sql.AddParameter(cmd, "@MODIFIED_USER_ID", gMODIFIED_USER_ID/*Security.USER_ID*/);

and added new function:
public static void spLEADS_Update(ref Guid gID, Guid gASSIGNED_USER_ID, string sSALUTATION, string sFIRST_NAME, string sLAST_NAME, string sTITLE, string sREFERED_BY, string sLEAD_SOURCE, string sLEAD_SOURCE_DESCRIPTION, string sSTATUS, string sSTATUS_DESCRIPTION, string sDEPARTMENT, Guid gREPORTS_TO_ID, bool bDO_NOT_CALL, string sPHONE_HOME, string sPHONE_MOBILE, string sPHONE_WORK, string sPHONE_OTHER, string sPHONE_FAX, string sEMAIL1, string sEMAIL2, bool bEMAIL_OPT_OUT, bool bINVALID_EMAIL, string sPRIMARY_ADDRESS_STREET, string sPRIMARY_ADDRESS_CITY, string sPRIMARY_ADDRESS_STATE, string sPRIMARY_ADDRESS_POSTALCODE, string sPRIMARY_ADDRESS_COUNTRY, string sALT_ADDRESS_STREET, string sALT_ADDRESS_CITY, string sALT_ADDRESS_STATE, string sALT_ADDRESS_POSTALCODE, string sALT_ADDRESS_COUNTRY, string sDESCRIPTION, string sACCOUNT_NAME, Guid gCAMPAIGN_ID, Guid gTEAM_ID, string sTEAM_SET_LIST, Guid gCONTACT_ID, Guid gACCOUNT_ID, bool bEXCHANGE_FOLDER, IDbTransaction trn)
{
spLEADS_Update(ref gID, gASSIGNED_USER_ID, Security.USER_ID, sSALUTATION, sFIRST_NAME, sLAST_NAME, sTITLE, sREFERED_BY, sLEAD_SOURCE, sLEAD_SOURCE_DESCRIPTION, sSTATUS, sSTATUS_DESCRIPTION, sDEPARTMENT, gREPORTS_TO_ID, bDO_NOT_CALL, sPHONE_HOME, sPHONE_MOBILE, sPHONE_WORK, sPHONE_OTHER, sPHONE_FAX, sEMAIL1, sEMAIL2, bEMAIL_OPT_OUT, bINVALID_EMAIL, sPRIMARY_ADDRESS_STREET, sPRIMARY_ADDRESS_CITY, sPRIMARY_ADDRESS_STATE, sPRIMARY_ADDRESS_POSTALCODE, sPRIMARY_ADDRESS_COUNTRY, sALT_ADDRESS_STREET, sALT_ADDRESS_CITY, sALT_ADDRESS_STATE, sALT_ADDRESS_POSTALCODE, sALT_ADDRESS_COUNTRY, sDESCRIPTION, sACCOUNT_NAME, gCAMPAIGN_ID, gTEAM_ID, sTEAM_SET_LIST, gCONTACT_ID, gACCOUNT_ID, bEXCHANGE_FOLDER, trn);
}

and in the end changed the webtolead.aspx page and added this:
, Sql.ToGuid (Request["MODIFIED_USER_ID" ])


So now you can now also who sent this lead so you can have affiliate support.
Please let me now if you can add this( so I won't have to make changes foe every new verion).
Thanks.