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

Forum Posts

Adding sums between 2 dates

I need to be able to total up sums per line from an original start date for a full year after.Example:  Original  start date                   Amount paid-1, amount paid-2, amount paid-3, etc.                  This would be calculated for 1 year, the...

Multi likes help me

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a l...

Sarahhh1 by 4 - Data Explorer
  • 221 Views
  • 0 replies
  • 0 kudos

Locate Completed Record

Hi, where do I find completed record when it disappeared in the table?

reign by 4 - Data Explorer
  • 316 Views
  • 1 replies
  • 1 kudos

Formula to work out business hours between two date fields

Hi guys,I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. H...

Untitled Base_ Table 1 - Airtable and 3 more pages.png
CameronG by 5 - Automation Enthusiast
  • 402 Views
  • 0 replies
  • 1 kudos

Resolved! Adding certain statuses

Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For...

Mike_Lopez by 5 - Automation Enthusiast
Solved
  • 1614 Views
  • 5 replies
  • 2 kudos

Creating a default message for a field if it's left empty

Hello! I'm creating an Airtable form, and I want to enable a default text to fill in a field if the field is left empty by whoever is filling the form. Example if name is not filled in, then it will default to anonymous instead of being blank. How do...

cbg by 5 - Automation Enthusiast
  • 873 Views
  • 4 replies
  • 2 kudos

Resolved! Extract URL from text field in Airtable

Hello communityAgain faced with this, hope to get a simple workaround for this where I can get a formula that extracts URL from a text field. Thanks

Sched_kode by 5 - Automation Enthusiast
Solved
  • 1517 Views
  • 4 replies
  • 1 kudos

Calculate total in list view of values in the level below

I am trying to use the new list view to create a system for putting together quotes for events. I have a list of event enquiries in table 1, and in table 2, have created a list view, where I am adding line items to events using levels. I would like t...

Student Interactive Leaderboard

Hi all, I am looking to create an interactive leaderboard, where my students fill out a form which relays the results back into a board. I have a rough idea of how to do this, but was wondering if anyone has attempted this before or any leaderboard t...

CX2023 by 4 - Data Explorer
  • 559 Views
  • 0 replies
  • 0 kudos