Solved

Hi,I'm trying to patch call an empty cell which is always be in the last/current row. Is there a way to do this with a parameter?

Hello,I'm completely new to Air Table and very unfamiliar with the available formulas.I want to have rows display dates for the whole of 2023. Yes, a long list of every day of the year. I'm including a picture as an example.I'm sure I can achieve this with a formula? Instead of manually...  

Hello. Looking for a formula that allows me to both convert to central time & round to nearest hour. What I have 2022-11-11 4:01pm 2022-11-11 2:01pm 2022-11-11 12:02pm 2022-11-11 10:15am Want 2022-11-11 4:00pm 2022-11-11 2:00pm 2022-11-11 12:00pm 2022-11-11 10:00am

This has probably been answered before, but I'm not sure how formulas work or how to maniuplate them to fit my use case.My base has multiple tables, one of which is a Members table. This includes the person's name as the primary field and other info, including their birthdate, in other fields.On another table, I have a list named Releases. Each Release record links to the Members table, and includes every Member who participated in a Release. Also, each Release has a release date field.As an example (Note that I'm only interested in linking to the H!P Members field, not the Non-H!P Members field):Let's use the record named Morning Coffee to hopefully explain things well enough.Morning Coffee was released 1998-01-28, and five H!P Members participated in the release: Nakazawa Yuuko, Ishiguro Aya, Iida Kaori, Abe Natsumi, Fukuda Asuka. I would like to have a field running a formula that displays each individual member's age in years on that date, preferably in a list. As I

I've got an interface showing a list of all customers who we are awaiting information from.How would I go about sending those customers an email, when I click a button to do so in an interface? I don't want to do it automatically when they enter a view because there's a manual review step beforehand.I thought I'd found a solution via the sendgrid extension but it looks like that's only possible via data tables, not interfaces. I also tried triggering an automation via a button click but I could only get that to work with the record picker (i.e. one record at a time), rather than in bulk.I feel like I'm not seeing a relatively obvious solution here!Any guidance appreciated.Thanks

I’m trying the following in my automation; Trigger is when record in Offer table changes status. First Action is Find Records from a Customer Table Second Action is to Create Records in Marketing Table for each of the customers from #2 above. However, I don’t know how to do that. Is it possible to iterate a list in automations? Regards, Ruchika

So my title may not make much sense, but here is what I have going on.I have a base that has 2 tables. I have a building table and I have a Tasks table. I have them linked in that some tasks are needed in multiple buildings, so when a task is created it can be assigned to any building that needs that task. However, what I want to be able to do is make a building specific note for each task that only shows for that buildingAs a hypothetical example: I create the task "add signage" and it can be assigned to building A, Building B, Building C, but not D or E, etc.In addition on the "tasks" table I have a "notes" field, and a "status" field for each of the tasks, So I can say "label needs to say "welcome in"" or something like that and know if it is "to do" "in progress" or "done". Here is the part that gets sticky; when I am looking at the buildings page (and it is linked to the tasks page, and have notes show (with a lookup field)) it will show me the notes for any linked task. If I

I want to create an automation that will do the following:When a status is updated to "client reviewing quote," the date in the "quote sent date" column for that record will fill automatically with today's date (in other words, I can't put in "3/20" because I want it to be contemporaneous with the date the status is changed, not stay stuck on one date).I have searched around and tried a bunch of things but cannot seem to figure out how to do this simple automation. Anyone know how to help me?Thanks!

I’ve read many Count Records threads, haven’t found my answer. Table A lists organizations (schools) I’m tracking. Schools have attributes such as public/private, updated/not updated. Once a month or so (automated if possible) I want to count how many schools meet various criteria and record in Table B So Table B will be: Fields: Date, Public Updated, Private Updated, Public not Updated, Private not Updated, etc. Records: 1/1/2022, 200, 400, 100, 200 2/1/2022, 250, 450, 50, 150 3/1/2022, 300, 500, 0, 100 Automation? Script? Rollup? Also—even if I could find the calculation that would give me those #s, I can’t use a calculated field because it will be current, obviously. I need to the calculation on the 1st of the month and then paste # into those fields. Thanks in advance!

Is there a way to convert formatted text to markdown format for use in automations?

I would like to send an email to an specific email address with a google sheet as an attachment and have the info in the sheet updated in my table.Thanks a lot for any help

Hello,I have a base for our sales CRM. In the CRM I have 3 key tables:DealsTasksReportsEach Tasks and Report is linked to a Deal. In Deals we have a field "Owner" which is a User field. In both Tasks and Reports we have a linked field "Owner (from Deals)".I want to create a dashboard for our weekly meeting with one filter to select one or more users from the "Owner" field and then based on that I have 3 grids one each for Deals, Tasks and Reports display records based on the "Owner" filter. (the next step after I solve this would be then to filter records based on a date field, but I believe this isn't going to be a problem).I can't find any way to cascade the filtering from the Deal Owner to the Tasks and Reports.The only way I can mentally come up with a model that would work is if I had a table "Owners" and linked the Deals to an Owner. Then I should be able to use a record picker to select the Owner from the Owners table and cascade the filtering down to Tasks and Reports as well.B

Hi,Looking for some scripting help. I am manually copy and pasting values from a Lookup field to a Multi-select field on the same table and want to know if there is a way to create a script that could do this process for me.  Example below:Want to copy the teams in the "Lookup of Teams" field and paste it into the "Manual Copy Paste (multi-select).  Any suggestions appreciated! Thank you. 

Hello!I have a base with 3 tables:a Contacts table,an Organization table, anda Membership table. In the Organization table, I have a linked field to the Contacts table called "All organization contacts" where I link all Contacts records associated with that "Organization" record.In the Membership table, I have a linked field to the Organization table called "Organization" where I link all Organization records associated with that membership. In the Membership table, I have a linked field to the Contacts table called "Membership seats" where I link all Contacts records that have a seat on that Membership. In the Membership table, I'd like to add a lookup field called "Other organization contacts" that pulls in any Contact record linked to the Organization linked to that Membership record that is NOT already linked in the "Membership seat" field. I don't mind doing this with either an automation or some sort of combination of fields, but I want it to be

I am building a CRM to track touches with individual contacts. While I have figured out how to set up a reminder to reach out to contact a certain amount of time after their most recent meeting, I am trying to figure out the best way to track/record all past meetings for that contact. I have it all on a spreadsheet right now to import but am struggling to figure out the best way to set up that data. Any suggestions?Thanks! Ariel

Hi there - I have tried a few ways to do this but have been unsuccessful. Here is what we are trying to accomplish >> Matching one company to grants that have matching sectors, location and demographics and each can have a deadline or no deadline. The problem is that when there is no match the automation for 'Update Record' deletes the records that are already matched in a field. So I tried to make 6 different fields to match, and thought I could concatenate the look-up IDs but when I use the formula to concatenate the IDs, the commas go away...  How is it possible to either: 1. Use the Update Record when there is no match and have it keep previous records? 2. Combine the record IDs so they all have commas and/or can add all of these to one look up record so we can send an email with one table instead of 6?    

I'm using the chart extension to visualize some data. Nearly all of my questions on the form have 5 answer choices but I have a few questions where no one chose an answer. For example (strongly disagree, disagree, neutral, agree, strongly agree) where no one chose "agree". I'd like the chart to show that agree is a 0 while also displaying the true values of the others. Any suggestions? Thanks!

In the theatre world our "fiscal years" are actually seasons that start in the fall and end in the spring.  And specifically, there are two big "quarters" = a fall/spring season, and a summer season. More complex than just "quarter 1" plus "year." and I don't think I can use the MONTH function.I want to be able to use an if then statement that I can set once and forget it without having to create a new formula field when each new season rolls around.If the date range is between 09/01/(yyyy) - 05/31/(yyyy+1), it's displayed as the "(yyyy)/(yyyy+1) Season"Ex:  Engagement end date is 09/02/2022.  It would be displayed in the column as "2022/2023 season"If the date range is between 06/01/yyyy - 08/31/yyyy, it's "yyyy Season"Ex: Engagement end date is 0701/2023. It would be displayed in the column as "Summer 2023 season" Is this possible??M

hello, i just took a monthly subscription on airtable,I noticed that my account was switched to a yearly subscription without my knowledge or consent. I did not intend for this to happen and I would like to request a refund as soon as possible.I'm very unhappy .Elaine

Hi, I'm trying to create a formula that will direct to a Gantt view filtered by a ProjectID field (So I can create a "Open Gantt Chart" button in an Interface using the "go to url in record" action that will open a Gantt view filtered by a specific project.) I can create a formula that generates a filtered link to a Shared View (https://airtable.com/shrXXXXX?filterEquals_ProjectRecID=XXXXXXX)  but this Shared View isn't editable, which defeats the point. I have tried a formula for the non-shared view URL (https://airtable.com/appXXX/tblXXXXX/viwXXXXX?filterEquals_ProjectRecID=XXXXX ) but that only opens the un-filtered view. Are there any tweaks to the URL formula that would make this work? Thanks! [Slightly off topic rant - I'm working on creating a semi-complex workflow Interface, and I'm getting increasingly frustrated. It seems like for every single feature I want to implement, there is a limitation in Airtable that I have to create seve

Hi all, I would like to extract an ID of a link with Regex formula but I don’t find how this formula works. Example: Link Drive (false link) https://drive.google.com/drive/folders/E1x1a1m1p1le1 And I would like to extract this part: E1x1a1m1p1le1 (i.e. part after “folders/”) I have tried this formula: IF({Link}, REGEX_EXTRACT({Link}, “folders/[^\s]+”)) but I have the following result : “folders/E1x1a1m1p1le1” instead “E1x1a1m1p1le1” I guess it should only be a small adjustment. Could you help me? Thank you in advance, Sébastien

Hi Airtable Community -I have table A which has a column that stores links to records in table B.  When I am in an expanded view of a record in table A and I click on the linked entry to open the linked record in table B, what determines what view is used for table B?  Is there a way to specify what view the linked record should open in?  I only want to display a few fields on the table B entry and I'm unsure how to do that.Thanks in advance!

Hi Folks, I'm currently struggling with a formula. I'm trying to track the progress of a project that requires an asset to be translated to several languages. I created checkboxes for each language and for when those assets were QC'd. I'd love to be able to consolidate all the checkboxes to a single text field so I can easily see which languages have been completed and QC'd. I've been able to create a formula to pull a checkbox per language but now I'm adding the second step of QC and my IF AND formula isn't working. Below is a sample of the formula that worked and the one that isn't once I added the second step. TRIM(IF(({BR Art}),"BR, ")&IF(({DE Art}),"DE, ")&IF(({FR Art}),"FR, ")&IF(({IT Art}),"IT, ")&IF(({JP Art}),"JP, ")&IF(({MX Art}),"MX ")) The two step I was testing outIF(AND({BR Art},{BR Art QC}),"BR, ",IF(AND({MX Art},{MX Art QC}),"MX, ",IF(AND({IT Art},({IT Art QC}),"IT",BLANK()))) 

I created a new base in preparation for moving some spreadsheet data. Column 'A' of the sheet is dates.I'm thinking I can set the primary field as a 'date' field and include 'time' in order to make each record unique. After import (copy & paste) I can change the default time (12:00am) to 12:01am, 12:02am, etc. if there are multiple spreadsheet rows (records) with the same date.QUESTION: Is there a potential issue with having a dates in the Primary Field?

Use case: RSVP form linked to individual attendees’ Airtable records created in a separate table. Each record pertains to a unique person. I’d like the RSVP form to automatically link to the original record. I’m working with two tables, ‘Anchor Table’ which contains hundreds of records related to individuals not involved in this use case and dozens of fields including private information, and ‘RSVP Table’ which is for the purpose of organizing an event where specific attendees’ are involved. I’ve created a filtered view for pertinent attendees’ and hidden all unrelated fields in Anchor Table and linked these records in RSVP table. When I create a form in RSVP table using the Linked Record field as a drop down, the preview in the selection shows thumbnails of attachment fields in the record that are hidden from the Anchor Table view. How can I change the fields in the form selection field to hide this?