Help

Chat GPT for Airtable formulas

2762 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Audrey_Harriso1
4 - Data Explorer
4 - Data Explorer

Has anyone had success asking Chat GPT for Airtable formulas? I've only asked it a few Airtable related questions so far, but I have to correct them all. Curious if anyone knows if there's a specific way to ask that will get formulas in the correct Airtable format.

6 Replies 6
Karlstens
10 - Mercury
10 - Mercury

Does ChatGPT learn through your conversations when you’ve had to correct it?

I have tested it with some JavaScript logic queries, and it’s impressive to say the least.

Audrey_Harriso1
4 - Data Explorer
4 - Data Explorer

It flops back and forth, correcting some things and reverting other things that we just discussed >2 messages ago. Haven't had much success.

> Curious if anyone knows if there's a specific way to ask that will get formulas in the correct Airtable format.

No. Airtable formulas are generally not exposed as code (like Excel and Sheets); therefore, there's no learning corpus for this closed formula system.

> Does ChatGPT learn through your conversations when you’ve had to correct it?

Feedback loops do exist in GP3 and Chat, however, it takes a lot of data to change how it behaves. If you want an improved version of ChatGPT specific to your world, you have to train an enhanced version of the model.

> Haven't had much success.

Try some prompt engineering to elevate its intelligence. But be cautious about this approach - here's why.

Dieu_Toan_Truon
4 - Data Explorer
4 - Data Explorer

Hi guys,

I found this website. It uses GPT to write formula for you. Hope it's useful for you!
https://excelformulator.com/

I don't typically write Airtable formulas because of this, but I'm sure a lot of people will like this.

UPDATE: Dream On...

A clean implementation of AI-based formula assistance is not likely to happen for a few years, if ever. Airtable is a closed formulaic system like Coda. There is no “code” [per se] for it to learn from because you are writing psuedo code to begin with - formulas are a proprietary abstraction layer. So either Airtable must train a fine-tuned LLM and open-source it, or a group of developers could take this challenge. It’s a lot of work, and it requires internal access or independent development of a formula parser. Read more here.