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