Other questions | Airtable Community

Create total count field from different multiple select fields if it meets certain criteria

Hello - I am trying to get a total count field if student's have passed multiple tests. There are six fields representing each test. Within each multi select field the contents contain: Drop downs for fields: Pass 4/5/24, Pass 4/17/24, Fail 4/5/24, ...

Date Fields dynamically fill based off one manually entered date field

Hello! Use Case: New Employees start at our company and we input a load of default events/meetings into their calendarsI manually input Start Dateand I want an automation/formula to inputDay 1 Start Start Date (ADD TIME 9am)Day 1 End Start Date(ADD T...

Resolved! Pulling a list of tasks that were completed overdue?

Hello,As projects come to a close, I want to review how successful my team was on staying on task and completing tasks by the deadline. My base is set up to flag overdue tasks, so I know in the moment when something is overdue and needs to get done A...

How to include a meeting location along with time and date in a form

I am trying to create a scheduling tool in Airtable to book appointments with outside clients. I created a form that is linked to schedule availability and includes name, role, email, etc. At the bottom of the form, they can choose a date/time. Is th...

Changing help text based on input in a form?

Hi! I'm trying to make it easier to check which cell phone carrier a person uses based on their phone number. Right now I have a formula I use, but formulas can't appear in formsThis is the formula I use: IF({Phone Number} = BLANK(), '', CONCATENATE(...

How to use return outside of select method

Hello, I am using the Airtable API in javascript. Currently I am using the select method based on the documentation, and I am trying to make use of the returned data outside of the method.For example this is my code: base('TestData').select({ vi...

Resolved! Rollup - displaying a field, based on another field's value

My Table A is a list of Staff members, and is linked to Table B. Table B are records of Agreements, with one of the fields being Company (the company name of that Agreement. We have several companies). A record in Table A (Staff) has multiple Agre...

How can I create a summary table of thousands of records, my method seems clunky

I have a table with 5K+ rows of data as such:table1Date - Year(formula of date) - Month(formula of date) - DataPoint1/1/2020 2020 01 5461/2/2020 2020 ...

Update Percent Progress Automatically Based on Two Dates?

I'm not sure if I'm looking for a formula or if what I'm wanting is even possible, so this is just a general question about utilizing the progress functionality for percent fields.What I'm hoping to accomplish is a percent field, set to view as progr...

Create links

Hello.I have a cell that we input text and then in another cell that text in converted to an urlIF({LINK}=BLANK(),"","https://example.com/"&{LINK})Ex:CN-349302 --------> https://example.com/CN-349302 But what kind of formula can I create to convert...