Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 02, 2020 11:21 AM
Hello amazing community! We pull data from AT into our WP website. We have added a hyperlink to a rich text enabled Long Text field. When the info is pulled into our website, the hyperlink is converted to a “****” snapshot here:
Any thoughts? Thank you!
Katherine
Dec 07, 2020 07:52 AM
Hey Katherine!
I don’t know off-hand, but one thing that would be helpful is isolating if this is on Airtable’s side or WP’s side. When you say you “pull data in”, how exactly is that working? Are you using Airtable’s API or some service to do that?
Cheers,
Anthony
Dec 07, 2020 09:32 AM
Hi Anthony,
(From our developer) We attach to AirTable’s API with PHP to make our “read” data file (which we use as a “cache” so that we don’t keep hitting the API continuously).
Does that help?
Katherine
Dec 07, 2020 10:23 AM
Hey Katherine,
My hunch is that this isn’t on Airtable’s side and is somewhere else in your pipeline. I just experimented with a rich-text-enabled Long Text field, and this is what I’m seeing coming back straight from the API:
This is a test hyperlink that just displays the full value in text:\n\n<https://www.chr.org/>\n\nAnd this is one that [links it in-line](https://www.chr.org/).\n
Looks good to me.
One thing that may help is to simplify your pipeline from Airtable → your PHP app. Your developer mentions that you’re using a “read” data file as a cache. I’d be remiss not to mention I recently happened to launch a service that helps with this exact problem - Sync Inc (https://syncinc.so/). We setup a follower Postgres database that tracks your Airtable data in real-time. (No need to fiddle around with syncing to/reading from a file anymore.) Maybe the simplicity we offer will help with this and other issues? Pass it along, and let him or her know that I’m available to answer any and all questions!
Best,
Anthony
Former Coloradan :slightly_smiling_face:
Dec 07, 2020 12:48 PM
Thanks Anthony - I will pass this along to our developer.
Happy Monday!
Katherine