Add the following to a web-part on the new-item page:
<script type="text/javascript" language="javascript">
var masterDataList;
ExecuteOrDelayUntilScriptLoaded(getWebUserData, "sp.js");
function getWebUserData() {
clientContext = new SP.ClientContext.get_current();
web = clientContext.get_web();
currentUser = web.get_currentUser();
currentUser.retrieve();
clientContext.load(web);
clientContext.executeQueryAsync(onSuccessMethodGetUser, onFailureGetUser);
}
function onSuccessMethodGetUser(sender, args) {
var userObject = web.get_currentUser();
var userName = userObject.get_title(); //get_email();
masterDataList= web.get_lists().getByTitle('List Name');
var camlQuery = new SP.CamlQuery();
var query = "<View><Query><Where><Contains><FieldRef Name='Resource_x0020_Email' /><Value Type='Text'>" + userName + "</Value></Contains></Where></Query></View>";
camlQuery.set_viewXml(query);
masterDataListItem= masterDataList.getItems(camlQuery);
clientContext.load(masterDataListItem);
clientContext.executeQueryAsync(onMasterDataListItemsLoadSucceeded,onMasterDataListItemsLoadFailed);
}
function onFailureGetUser(sender, args)
{
//Do nothing
}
function onMasterDataListItemsLoadSucceeded(sender,args)
{
var itemID;
var itemsEnumerator=masterDataListItem.getEnumerator();
//Fetch latest item
while(itemsEnumerator.moveNext())
{
var currentItem=itemsEnumerator.get_current();
itemID=currentItem.get_item('ID');
}
if(itemID!=undefined)
{window.location.href="https://server/sites/site_name/Lists/list_name/Item/editifs.aspx?ID="+itemID+"";
}
}
function onMasterDataListItemsLoadFailed(sender,args)
{
//Do nothing
}
</script>
