Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Resolved! Extract the first two words from a string?

I have string fields and I want to extract the first two words (minus any punctuation or special symbols). Ideally, they would remove the white space and capitalize each word as well.So a field with “Midnight: A Tale” = “MidnightA”. ”What’s New in Bo...

  • 92 Views
  • 4 replies
  • 0 kudos

Formulas are disappearing for no reason

Hello altogether, this is driving me crazy. I am entering some formulas in my field and while I am adding fields, they disappear. This behaviour is consistent for all the fields. What is going on? Is it because there are too many referenced fields?  

  • 232 Views
  • 2 replies
  • 0 kudos

SEARCH() and FIND() functions broken?

I'm trying to use either a SEARCH() or FIND() function to locate a comma within a string. Unfortunately, these seem to be broken on Airtable right now. Am I missing something? This should be pretty straightforward, right?

  • 1236 Views
  • 4 replies
  • 0 kudos

Resolved! Formula to Calculate Date from Linked Table

I have a base that has client names in a table and appointment date on another table that is linked to the specific client. I am trying to create a formula in the client table that will display the last appointment for that that client that was sched...

  • 165 Views
  • 2 replies
  • 0 kudos

Individual Dashboard Universal Link

Hello,I am using Airtable in conjunction with a web app. On my web app, I have a page for a section dashboard that shows communal information. Additionally, I have an individual dashboard, which displays information about a particular user.My problem...

  • 168 Views
  • 3 replies
  • 0 kudos

Resolved! Calculate average in interface

Hey I'm quite new but couldn't find an answer : I'm looking to show the average of a column in the interface. To be specific, I have a set of data from one table and I'm selecting certain data from another table, and I want to calculate the average o...

  • 2186 Views
  • 3 replies
  • 0 kudos

Resolved! Formula to Assign Single-Select Value

Hello,I'm moving into the List View Interface, and I am loving the "Prefix" field which allows me to use visual indicators to quickly see the status of records. My current roadblock is this, I haven't been able to figure out:How can I have a Single S...

M_L_1-1728332677253.png M_L_0-1728332655197.png
  • 181 Views
  • 1 replies
  • 0 kudos
M_L by 7 - App Architect
Solved