GOOGLE MAP INTEGRATION

Question

We have a google map field in our quote record that provides a map of the shipping address. (We have named this the jobsite address tho). The trouble is that when there is a second line of the address for the floor number, apt number, etc. it errors out the map. Is there a way to set the code to use only the first line of the address? Ideally, taking only the info before the first hard return? 
 Here is the code we are using to make it work currently. 
 www.google.com/.../place, {shipping_address_city}, {shipping_address_state}, {shipping_address_postalcode} 
 (Note: I have edited out my google key as I think that is proprietary to our company)

Norm Bonenfant · Answer

Hi Norm, 
 I assume you are following these instructions: https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Adding_a_Google_Map_to_a_Module/ . 
 My suggestion here would be to create a new field (e.g. "ConcatenatedShippingAddress_c") and use SugarLogic to populate it with the address you want to pass to the google map field. That way, you can use SugarLogic to test if the second line of the address is non-empty and conditionally include it accordingly. Then in your Google Map field, you just make the Generate URL field uses {ConcatenatedShippingAddress_c} . 
 Regards, 
 Adam