![InfoWrangler InfoWrangler](https://community.airtable.com/legacyfs/online/avatars/3X/5/7/579dc40ad18708ec318d7303f892432e3693a501.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2023 11:51 AM - edited ‎Feb 23, 2023 12:07 PM
Hi folks : )
I'm trying to put a link in an automated email, and it keeps generating a sequence of characters at the end of the url that makes the link useless.
Here's how I have it set up in the body of the email:
Here's what the end of the url is supposed to look like:
230526796288065/sign_document_d4deb6cd5dd95877_79e90063180a7cbf.pdf
And here's what it looks like when the automation is done with it:
This happens whether I set up the field as a URL or single line text, and the link opens fine from the data view; these extra characters only show up in the link generated by the automation email.
Since the characters look like html encoding, I looked them up and found this, if it helps:
- %EF : ï
- %BB : »
- %BF : ¿
How do I set it up so this doesn't happen? Or is it a bug that can be fixed?
Thank you for your attention,
Shawn
Solved! Go to Solution.
Accepted Solutions
![InfoWrangler InfoWrangler](https://community.airtable.com/legacyfs/online/avatars/3X/5/7/579dc40ad18708ec318d7303f892432e3693a501.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2023 11:10 AM
Thanks Adam @TheTimeSavingCo. I actually figured out that it was happening because the field I was trying to use was synced from another table.
This might be a bug that can be addressed, perhaps - but I solved the problem by re-creating the automation email in the original table for that field, and now the link is generated as it should be, without those characters.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2023 12:23 AM
Hm I tried to replicate this but wasn't able to I'm afraid. Here're some screenshots:
And the hover link output: 
Link to base with the automation
You might want to open a support ticket? Sorry I couldn't help more and I hope the data point proves useful
![InfoWrangler InfoWrangler](https://community.airtable.com/legacyfs/online/avatars/3X/5/7/579dc40ad18708ec318d7303f892432e3693a501.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2023 11:10 AM
Thanks Adam @TheTimeSavingCo. I actually figured out that it was happening because the field I was trying to use was synced from another table.
This might be a bug that can be addressed, perhaps - but I solved the problem by re-creating the automation email in the original table for that field, and now the link is generated as it should be, without those characters.
![Kelly_Rogala Kelly_Rogala](https://community.airtable.com/legacyfs/online/avatars/3X/2/1/212be2c4824f3edf66bab3abb3aebd4f3ab3e8c8.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2025 02:16 PM
If needed, you can create a new field in the table, make it a Formula field, and simply have it reference the synced URL from the original table. This will fix the appended characters and you can use this formula field in your email automations.
Example:
Synced field title = Website URL
Formula field = {Website URL}
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)