Help

Re: Concatenating Text and Getting Rid of whitespace with "+' to generate link.

710 0
cancel
Showing results for 
Search instead for 
Did you mean: 
DavidBuilt
4 - Data Explorer
4 - Data Explorer

I am setting up an automation by concatenating 7 fields. These Fields are automatically populated as the user enters their info into a web form.

Formula:

CONCATENATE(Report_Link1,{Borough No},Report_Link2,{Project_StreetAddress},Report_Link3,{Proj_Street_Name},Report_Link4)
 
The output I get is:
https://a810-bisweb.nyc.gov/bisweb/PropertyProfileOverviewServlet?boro=1&houseno=167 &street=8th Ave &go2=+GO+&requestid=0
 
There are two problems with this: 
1. There are spaces between 
  • {Project_StreetAddress} & Report_Link3
  • {Proj_Street_Name}, & Report_Link4 

But there aren't any spaces between Report_Link1,{Borough No},Report_Link2,{Project_StreetAddress} and I have not done anything different to the latter part of the formula.

2. {Proj_Street_Name} could have spaces like in this example '8th Ave'. If I was to manually get the link from the website it would treat a space as a '+' to complete the link. How can I go about getting a '+' automatically so the link can be generated?

Thanks for the help and look forward to resolving this!

 

 

2 Replies 2

I recommend learning the Encode URL function.

https://support.airtable.com/docs/build-a-custom-form-url-filler-using-encode-url-component

Also, wrapping each field within Trim() will help remove unwanted trailing white space.

https://support.airtable.com/docs/formula-field-reference

The way I see it - this works if we use Airtable Forms. I should have clarified, I mean a web form on Wix website that is automated to submit the info in to my Airtable base as it comes in. Could this still work if that is the case?

Wix Web form > Airtable Data and then concatenate the data in the cells based on the above