Populate Lookup Field

Populate Lookup Field

I have a form which is filled out by email - it is a Twilio SMS response.

I would like to link the form's From field (single line text or number; either works) with a lookup field which contains a list of mobile phone numbers from my Worker Information form.

The phone number from the From field will not be an exact match as Twilio responds with "+1 NPA NXX xxxx and I only store NPA NXX xxxx.

The goal is to ultimately fill in other fields based on the Worker Information Lookup so I can generate further workflows. Ie - First and Last Name, etc - stored in another form.

EDIT: Perhaps my problem would be solved by automatically converting the From phone number from Twilio to the same format I have in my other form. Ie - +14051234567 would become (405) 123-4567??

Thanks!

Jesse