Hello - we are looking to build a airtable like functionality into our application for contact and company data enrichment. Connecting third party APIs and claling them per cell or for full columns. Another use case is to make a OpenAI API call to LLM and request a company description from a website as well on a per column or per cell basis. The api return will result in additional column with filled api requests.
Does anyone have experience in adding these functions/ elements in Baserow?
Hi, welcome to the community.
A formula field in Baserow allows you to create a clickable button that navigates to an external url using the button() function. The external url can be a webhook of an automation framework that triggers a certain api. You can pass additional parameters in the query string of the url using the contact() function.
The final formula can look like this:
button(concat('https://n8n.cloudron.myinstance.com/webhook/hook-name?company=',field('Company'),'&row_id=',row_id()),'get data')
It creates a button for each record that navigates to https://n8n.cloudron.myinstance.com/webhook/hook-name and passes the name of the company and the id of the row as a query string. The text in the button will be “get data”.
Baserow has an AI field type that can be used for this. You can check the following blog post for more information: How to enable and configure the AI field in Baserow