Fill field based on csv lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-939646%22%20slang%3D%22en-US%22%3EFill%20field%20based%20on%20csv%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-939646%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20collect%20customer%20information%20and%20add%20it%20to%20ConstantContact%20or%20another%20e-mail%20application.%26nbsp%3B%20I%20have%20created%20a%20form%20with%20Name%2C%20Address%2C%20Phone%20Number%2C%20E-mail%20Address%20and%20and%20a%20final%20field%20based%20on%20their%20Address.%26nbsp%3B%20What%20I%20would%20like%20is%20for%20the%20final%20field%20to%20be%20automatically%20populated%20based%20on%20the%20input%20above.%26nbsp%3B%20I%20have%20a%20csv%20file%20with%20all%20of%20the%20postal%20addresses%20and%20the%20corresponding%20data%20that%20should%20be%20input%20into%20the%20final%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20best%20way%20to%20accomplish%20this%3F%26nbsp%3B%20I%20am%20vaguely%20aware%20of%20Flow%20and%20could%20potentially%20use%20it%20to%20add%20the%20field%20after%20the%20fact.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-939646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am trying to collect customer information and add it to ConstantContact or another e-mail application.  I have created a form with Name, Address, Phone Number, E-mail Address and and a final field based on their Address.  What I would like is for the final field to be automatically populated based on the input above.  I have a csv file with all of the postal addresses and the corresponding data that should be input into the final field.

 

What is the best way to accomplish this?  I am vaguely aware of Flow and could potentially use it to add the field after the fact.

 

Thanks,

0 Replies