+4I am trying to automate affiliate links. Sounds so easy!
What we know:
<a href=“http://Internet URL goes here.”>Title the visitor sees.
My two fields are Affiliate Company Name and BITLY (the url)
What is the formula for my HTML link? Concatenate? I am stuck. Searched other posts and I could not get this. Thank you!!
Concatenate would work. Or you can concat using an ampersand between text phrases phrase & phrase as outlined in the example below. You should also be escaping the quote characters with a backslash \\" beforehand since they’re special characters.
So your formula will probably look something like:
"<a href=\\"" & {BITLY} & "\\">" & {Affiliate Company Name} & "</a>"Concatenate would work. Or you can concat using an ampersand between text phrases phrase & phrase as outlined in the example below. You should also be escaping the quote characters with a backslash \\" beforehand since they’re special characters.
So your formula will probably look something like:
"<a href=\\"" & {BITLY} & "\\">" & {Affiliate Company Name} & "</a>"So glad I found this! It’s exactly what I needed. But now I am wondering if there is a way to have view where the text link is what we see instead of the code?
So we’d see I am a link
Instead of <a href="https://community.airtable.com/">I am a link</a>
So glad I found this! It’s exactly what I needed. But now I am wondering if there is a way to have view where the text link is what we see instead of the code?
So we’d see I am a link
Instead of <a href="https://community.airtable.com/">I am a link</a>
@Jenn_Iannaconi That’ll be a bit more difficult, but still very much possible. If you can manage to extract the URL via a formula, then you should be able to use it in the Button field’s configuration settings to open the URL. Instead of concatenating you’d be combining a few formulas - such as MID, FIND or others. The formulas would be nested (so FIND could be inside MID for example). If you’re having trouble, make a separate post describing your progress and I’m sure someone will jump in to help.
@Jenn_Iannaconi That’ll be a bit more difficult, but still very much possible. If you can manage to extract the URL via a formula, then you should be able to use it in the Button field’s configuration settings to open the URL. Instead of concatenating you’d be combining a few formulas - such as MID, FIND or others. The formulas would be nested (so FIND could be inside MID for example). If you’re having trouble, make a separate post describing your progress and I’m sure someone will jump in to help.
That’s exactly the noodge I needed!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.