Skip to main content

Generate Google Doc with a live link from an AT field

  • March 25, 2024
  • 5 replies
  • 72 views
Linda_Bonder
Forum|alt.badge.img+14

I'm generating Google docs using the automation. In the text of the doc, I'm inserting data from a "link" field. The link field text is getting inserted, but just as text, not as a live link. Any tips on how to make them insert as live links?

See the attached pic - the red circled "link" appears as text, not a live link. Below it, the help email address appears as a live link because it's in the text of the email, whereas the Zoom link is coming from a database field. (We have 40 classes, they each have their own Zoom link.) Thank you!

5 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9808 replies
  • March 25, 2024

As far as I know, Airtable's Google Docs action doesn't support hyperlinks in the document that you create.

However, Make's Google Docs automations & integrations does support hyperlinking in the document that you create.

You just need to put in HTML code in the body of the document, and it will display as a live link in the document.

Take a look at the screenshot below for an example of how this might look in Make.

You'll need to have a few skills to make this happen:

#1. You'll need to know some HTML. You can use a website like text-html.com to convert text to HTML.

#2. You'll need to know how to instantly trigger an automation in Make. See this post.

#3. You'll need to learn how to use Make. I’ve assembled a bunch of Make training resources in this thread.

p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld

Linda_Bonder
Forum|alt.badge.img+14
  • Linda_Bonder
  • Author
  • Known Participant
  • 22 replies
  • March 25, 2024

As far as I know, Airtable's Google Docs action doesn't support hyperlinks in the document that you create.

However, Make's Google Docs automations & integrations does support hyperlinking in the document that you create.

You just need to put in HTML code in the body of the document, and it will display as a live link in the document.

Take a look at the screenshot below for an example of how this might look in Make.

You'll need to have a few skills to make this happen:

#1. You'll need to know some HTML. You can use a website like text-html.com to convert text to HTML.

#2. You'll need to know how to instantly trigger an automation in Make. See this post.

#3. You'll need to learn how to use Make. I’ve assembled a bunch of Make training resources in this thread.

p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld


Thanks - do you know if this works when the link is coming from an AT field? So in your attached example, could I integrate an AT field where it says, "1. URL"  within the href, and have that link be live in the resulting G-doc? ? I can program the HTML - I just need to be able to put an AT field within it.

Thanks!

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9808 replies
  • March 25, 2024

Right, exactly. That's where it's coming from.

Linda_Bonder
Forum|alt.badge.img+14
  • Linda_Bonder
  • Author
  • Known Participant
  • 22 replies
  • March 25, 2024

Right, exactly. That's where it's coming from.


Terrific, thank you, I'll try it this week. It looks like "Make" is fairly straightforward, but will let you know if I need help. I think we'll be able to afford the "core" subscription.

Linda_Bonder
Forum|alt.badge.img+14
  • Linda_Bonder
  • Author
  • Known Participant
  • 22 replies
  • April 13, 2024

As far as I know, Airtable's Google Docs action doesn't support hyperlinks in the document that you create.

However, Make's Google Docs automations & integrations does support hyperlinking in the document that you create.

You just need to put in HTML code in the body of the document, and it will display as a live link in the document.

Take a look at the screenshot below for an example of how this might look in Make.

You'll need to have a few skills to make this happen:

#1. You'll need to know some HTML. You can use a website like text-html.com to convert text to HTML.

#2. You'll need to know how to instantly trigger an automation in Make. See this post.

#3. You'll need to learn how to use Make. I’ve assembled a bunch of Make training resources in this thread.

p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld


Hi Scott, finally got time to work on this.

Within Make, should I be able to do this with "Create a document from a template" rather than using the HTML? I need to create the documents in 6 languages, and my HTML is rusty, so templates would be a lot easier. I have tried with the template, https://docs.google.com/document/d/1sWSiJM6BCwhU2fuDLhw-PBH4JzDnbOdwBwNjPeN7Zbk/edit?usp=sharing.

It's creating the document but not picking up any of the tags: https://docs.google.com/document/d/1j80VmvONyi4vOsSFuXeRV31J7pJ7Y64LEKTGaEP22Z8/edit?usp=sharing

In the creation process, I am getting the attached error message. The fields in AT are a mixture of drop-downs, look-ups, formulae, and text fields. The error keeps pointing to #7 and 8 (start counting with 0, correct?), but those AT field types are not different than others.

Would much appreciate any help with this.

- Linda

 

 


Terms & ConditionsAccessibility statement