Add your HTML content in a field and this automation will provide you with a formula that generates a public URL for every record in your table.
Pro Tip
You can add values from your Airtable record in the HTML code. We explain how to do this in the video. The way you would replace placeholders with their actual text is by using Airtable’s SUBSTITUTE formula.
e.g. SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( HTML,'[placeholder1]',placeholder1),'[placeholder2]',placeholder2),'[placeholder3]',placeholder3)
Features
- Build dynamic webpages from Airtable in bulk.
- Add HTML code in one field and get links generated in another field.
- Content’s placeholders can be replaced with a formula.
Demo
This is a sample webpage generated by this automation. It will open in a new tab.
Use Cases
This automation can be useful in a lot of scenarios. You can use it to:
- Allow customers to view/print invoices
- Generate proposals from Airtable
⚠️ For links to be clickable in your generated page, URLs have to include target="_parent"
in their tag.
If you click on the sample view below, you’ll see the table that’s used for the demo above.
Does this require me to have a hosting webserver? Is it possible to have a custom domain name?
No, the app runs on our server. It’s not possible to host it somewhere else nor have it on a custom domain name.
How do I display an image from an attachment field in a record?
You would first need to extract the image attachment URLs into a separate field. You can this extension to achieve that. Then you would pass that direct URL in an HTML image tag.
My substitute formula to replace the placeholders with values returns #Error! msg in airtable.
This post on Airtable forum could probably help.