Airtable Formula Field Writer With Worked Examples
Write and explain formula fields for dates, text and status.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Write Airtable formula fields for me. My table fields and their types: [FIELDS]. What I want to calculate: [CALCULATIONS]. Sample records: [SAMPLE_RECORDS]. For each calculation give a table row with Goal, Formula, Explanation of each part, and Result for two sample records with the arithmetic shown. Cover common cases: days until a deadline with DATETIME_DIFF, an overdue flag with IF and IS_BEFORE, joining names with & while handling blanks, status labels, percentage complete, rounding, and conditional text. Mark function names and syntax you cannot verify [VERIFY against the Airtable formula reference]. Explain common errors: field names in curly braces must match exactly, blanks behave differently from zero, and text numbers differ from real numbers. Show how to test each formula on a few records before using it in a view or automation, and offer a simpler rollup or lookup where a formula is not needed. Prefer readable formulas and split long ones into helper fields when that helps.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.