# Fields and Formulas **URL:** https://air.tableforums.com/c/airtable/fields-and-formulas/24.md [Latest](https://air.tableforums.com/latest.md) · [Categories](https://air.tableforums.com/categories.md) --- ## [About the Formulas category](https://air.tableforums.com/t/about-the-formulas-category/54)
**Author:** [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\ **Replies:** 0
Formulas, lookup fields, rollup fields, button fields, etc. --- ## [Email created from formula - need to insert line breaks in subject text](https://air.tableforums.com/t/email-created-from-formula-need-to-insert-line-breaks-in-subject-text/1485)
**Author:** [@brastedhouse](https://air.tableforums.com/u/brastedhouse)\ **Replies:** 2\ **Last updated:** [March 12, 2025, 10:00pm UTC](https://air.tableforums.com/t/email-created-from-formula-need-to-insert-line-breaks-in-subject-text/1485 "2025-03-12T22:00:08Z")
I have created a form in Fillout using Airtable data. In Interfaces I created a list and put a button in it and set it up to send an email. I have everything working except that I cannot figure out how to put a line brea… --- ## [What are the pros/cons to using a Checkbox vs Yes/No Single Select vs Text Field](https://air.tableforums.com/t/what-are-the-pros-cons-to-using-a-checkbox-vs-yes-no-single-select-vs-text-field/915)
**Author:** [@AirBenderMarcus](https://air.tableforums.com/u/AirBenderMarcus)\ **Replies:** 10\ **Last updated:** [October 13, 2023, 9:19pm UTC](https://air.tableforums.com/t/what-are-the-pros-cons-to-using-a-checkbox-vs-yes-no-single-select-vs-text-field/915 "2023-10-13T21:19:57Z")
Are there any considerations I should be making when deciding whether to use a Check Box, a single select field with the options “Yes/No” or just a text field in regards to automation triggers and general data governance… --- ## [Dynamic Filter on Lookup](https://air.tableforums.com/t/dynamic-filter-on-lookup/1381)
**Author:** [@JBJ](https://air.tableforums.com/u/JBJ)\ **Replies:** 2\ **Last updated:** [December 4, 2024, 6:10pm UTC](https://air.tableforums.com/t/dynamic-filter-on-lookup/1381 "2024-12-04T18:10:26Z")
Hi guys, On my \[Revenue\] table, I’m trying to compute the expected revenue that I’ll get from a client. The client processes payments twice a month after the work sessions are completed. We have struck a deal that sp… --- ## [Function: Now()](https://air.tableforums.com/t/function-now/1128)
**Author:** [@Julian.Dumitrascu](https://air.tableforums.com/u/Julian.Dumitrascu)\ **Replies:** 4\ **Last updated:** [March 18, 2024, 1:14am UTC](https://air.tableforums.com/t/function-now/1128 "2024-03-18T01:14:33Z")
I’d use it in a formula field. Its output would trigger an automation to notify e.g. me and the submitter of a form that our next talk is scheduled to start in e.g. 72 minutes: IF( AND( start, NOW()+0.05 = start ), … --- ## [Formula Preview : New implementation](https://air.tableforums.com/t/formula-preview-new-implementation/1117)
**Author:** [@dilipborad](https://air.tableforums.com/u/dilipborad)\ **Replies:** 1\ **Last updated:** [March 7, 2024, 11:56am UTC](https://air.tableforums.com/t/formula-preview-new-implementation/1117 "2024-03-07T11:56:55Z")
Airtable added new important features Formula Preview without being mentioned anywhere in the updates. Did anyone notice? :point\_down: --- ## [Watch for an updated field in table1, then add it's value to a value in table2](https://air.tableforums.com/t/watch-for-an-updated-field-in-table1-then-add-its-value-to-a-value-in-table2/1062)
**Author:** [@hauwi](https://air.tableforums.com/u/hauwi)\ **Replies:** 2\ **Last updated:** [February 1, 2024, 2:39am UTC](https://air.tableforums.com/t/watch-for-an-updated-field-in-table1-then-add-its-value-to-a-value-in-table2/1062 "2024-02-01T02:39:37Z")
Hi. I find it helps to think of this as similar to updating the number of available stock-items after an order. :blush: I have a ‘claims’ table where each record is a tutor claim - per student. Each claim contains a ‘nu… --- ## [Find the biggest number used in a field, add one and use that number in the new record created via form](https://air.tableforums.com/t/find-the-biggest-number-used-in-a-field-add-one-and-use-that-number-in-the-new-record-created-via-form/690)
**Author:** [@Shrizz](https://air.tableforums.com/u/Shrizz)\ **Replies:** 4\ **Last updated:** [June 21, 2023, 3:52pm UTC](https://air.tableforums.com/t/find-the-biggest-number-used-in-a-field-add-one-and-use-that-number-in-the-new-record-created-via-form/690 "2023-06-21T15:52:23Z")
Using the Auto-number type field can be great, but it is also very limiting when you need to start with a certain number in particular. And if you create a record and then delete it, the next record you create will not h… --- ## [Help with formula looking up values from 2 columns](https://air.tableforums.com/t/help-with-formula-looking-up-values-from-2-columns/685)
**Author:** [@airtablewhitebelt](https://air.tableforums.com/u/airtablewhitebelt)\ **Replies:** 3\ **Last updated:** [June 19, 2023, 3:41pm UTC](https://air.tableforums.com/t/help-with-formula-looking-up-values-from-2-columns/685 "2023-06-19T15:41:22Z")
What formula would you use to lookup a value in column 1, if no value, use value in column 2? I have a new column “User Company Name” that I want to pull the value from either “Customer Name” or “CM Name”. I tried this… --- ## [Roll up to derive the latest edit in Rich Text field](https://air.tableforums.com/t/roll-up-to-derive-the-latest-edit-in-rich-text-field/603)
**Author:** [@Phantom](https://air.tableforums.com/u/Phantom)\ **Replies:** 5\ **Last updated:** [May 22, 2023, 2:47pm UTC](https://air.tableforums.com/t/roll-up-to-derive-the-latest-edit-in-rich-text-field/603 "2023-05-22T14:47:15Z")
I am a newbie , for some reason I a unable to get the roll up formula to work for me , screen shot attached for reference… what am I doing wrong here? Thanks guys … keep rolling out "Built on Air " podcasts, I am trying… --- ## [Escape slashes in a formula](https://air.tableforums.com/t/escape-slashes-in-a-formula/602)
**Author:** [@Ricardo](https://air.tableforums.com/u/Ricardo)\ **Replies:** 3\ **Last updated:** [May 21, 2023, 1:37am UTC](https://air.tableforums.com/t/escape-slashes-in-a-formula/602 "2023-05-21T01:37:34Z")
Hi, I’m trying to use a formula field to combine the rollup of HTML table rows with a table header. I have added slackes in front of the quotation marks to escape them and wonder how to treat the slashes that close the H… --- ## [How to make a regex pattern compatible with Airtable?](https://air.tableforums.com/t/how-to-make-a-regex-pattern-compatible-with-airtable/596)
**Author:** [@Ricardo](https://air.tableforums.com/u/Ricardo)\ **Replies:** 6\ **Last updated:** [May 12, 2023, 1:07pm UTC](https://air.tableforums.com/t/how-to-make-a-regex-pattern-compatible-with-airtable/596 "2023-05-12T13:07:45Z")
Hey there, I’m trying to use a regex replace formula in Airtable and am struggling to adapt the pattern for it to work inside Airtable by escaping problematic characters. (?\<=\\/d\\/)\[\\w-\]+ --- ## [Years of Service Formulas Needed for 3 Possibilities](https://air.tableforums.com/t/years-of-service-formulas-needed-for-3-possibilities/575)
**Author:** [@brastedhouse](https://air.tableforums.com/u/brastedhouse)\ **Replies:** 8\ **Last updated:** [May 4, 2023, 7:14pm UTC](https://air.tableforums.com/t/years-of-service-formulas-needed-for-3-possibilities/575 "2023-05-04T19:14:31Z")
Greetings, What I have . . . Member Table for Fire Department Operations Airtable Base Type of Field Field Name Data in Field DateField: Joined Date Member Joined Department Formula: Current YOS Calculat… --- ## [Formula to compare 6 dates and determine which was first](https://air.tableforums.com/t/formula-to-compare-6-dates-and-determine-which-was-first/488)
**Author:** [@Alisha\_Sadeski](https://air.tableforums.com/u/Alisha_Sadeski)\ **Replies:** 12\ **Last updated:** [April 7, 2023, 6:37pm UTC](https://air.tableforums.com/t/formula-to-compare-6-dates-and-determine-which-was-first/488 "2023-04-07T18:37:55Z")
I’m looking for a way to determine which course a customer purchased first. The problem is that each course has it’s own table. (I REALLY wish we could restructure this and put all course enrollments are one table but we… --- ## [Ultimate solution to converting number into international format](https://air.tableforums.com/t/ultimate-solution-to-converting-number-into-international-format/332)
**Author:** [@Bettina](https://air.tableforums.com/u/Bettina)\ **Replies:** 5\ **Last updated:** [February 26, 2023, 2:25pm UTC](https://air.tableforums.com/t/ultimate-solution-to-converting-number-into-international-format/332 "2023-02-26T14:25:08Z")
Hi all, It’s driving me insane, I’m trying out several ideas I read on the topic in various communities but I just can’t get it to work (the formulas tend to get complicated). So here in this forum you find it actually… --- ## [Formula to create abbreviations](https://air.tableforums.com/t/formula-to-create-abbreviations/248)
**Author:** [@Alisha\_Sadeski](https://air.tableforums.com/u/Alisha_Sadeski)\ **Replies:** 2\ **Last updated:** [February 17, 2023, 12:04am UTC](https://air.tableforums.com/t/formula-to-create-abbreviations/248 "2023-02-17T00:04:31Z")
Is there a way to write a formula that would string together the first letters of a multi-word name? Example: Farmington Youth Basketball Association = FYBA There might not always be 4 words. Some name might be made u… --- ## [Prefilled form vs select fields](https://air.tableforums.com/t/prefilled-form-vs-select-fields/202)
**Author:** [@Databaser](https://air.tableforums.com/u/Databaser)\ **Replies:** 8\ **Last updated:** [February 9, 2023, 1:54am UTC](https://air.tableforums.com/t/prefilled-form-vs-select-fields/202 "2023-02-09T01:54:35Z")
Hi all I once again ran into this: when trying to prefill a form with a value that’s supposed to end up in a select field (eg “working year”), it doesn’t prefill this data in your form if the data is not already an opti…