Formulas | Airtable Community

Edit history of a field or formula

Is there a way to see/track who has made edits to a formula or field? This feature is very helpful for viewing individual records, but it'd be even better if I could view who is changing formulas.

Ft me nahi hai na to be in my heart and

DG mw me nahi hai na to be a great day hoga to be a

im accautn is Block support of the day is the best way to get

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...

Locate Completed Record

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

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

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...

Synced tables: Reference table-names per record & executing scripts in source table from destination

Hi all,Some context: I have multiple bases with a list of tags that can be associated with records in other tables through a linked record field. If the users cannot find the tag they need, they can enter it as a new tag, but due to view permissions,...

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...