Solved

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?

Hello everyone,I'm trying to create something similar to what I do with spreadsheets, it's like a product catalog but using multiple rows on a single entry so I can use different values for each variation of the  same item. (image attached)Is it possible to do something like this in AirTable?Or if anyone got any suggestions on how I could do something similar to this in AirTable, I would appreciate it very much.Thanks everyone! 

I imported a financial report from PayPal. All of the Negative amounts in the "Amount" field use a "-" in front of the value. I want to create a new field that removes the "-" and just lists the value of the Amount field.  If the amount doesn't have the "-" symbol, I just want it to leave the record blank.  I tried using a substitute formula in the new field, but not sure how to get a blank value in the new field if the original amount value does not have a "-" sign. SUBSTITUTE(Amount, "-", " ") What would be the best way to do this? Thanks in advance.

Hi,I need to lookup a value from shipping rate tables based on the weight value from another table.I have two tables I need to look up data from, an example of one is below, The other is the same structure but different data.This is my source table containing my weight values.I need to select a value from the 2nd column on the above table, when the weight in my source table is between two row values.For example, if source weight is 7.75kg, it should return 53.3 for the rate.Hope someone can point me in the right direction 😁Thanksjohn

Hello everyone, I'd like to make a formula with an IF statement that shows "OK" if a date is in the last 6 complete months. For example, if today is the 17th of March, it would show "OK" for every record since the 1st of September.Is this something possible?Thanks 🙂

Hi, community!I'm trying to create an automation that sends a Slack message sharing the record link directly at the interface, but I'm not being able to accomplish that.What I've tried:Using the Airtable Record URL: Unfortunately, when I use this URL, it directs me to the table, not the interface (Case 1)Using the Interface URL: It solves the issue of directing me to the interface instead of the table, but I'm not directed to the specific record (Case 2)Is there a way to share the record URL that directs me to a specific record at the interface?Case 1: Case 2: 

Goal: A user can create a post including any version of a youtube or twitch URL. When the post is created it appears in a repeating group and the link appears as an embedded video. Current State: The entire site is already built using a combination of airtable and bubble.io. This is the last feature that I need. Work: I am open to ideas. What I know right now is that it can be done either with a Regex Formula or JavaScript Automation using the video id. Budget: Hopefully, under $200. But we can discuss it, based on your idea. 

I am trying to build a base for a company that delivers natural food for pets. The clients tells us the date they want their first delivery made, how often they want to receive it (every week, every 2 weeks, etc), the preferred day of the week they want to receive the deliveries (monday, tuesday, etc) and also the number of deliveries that are already paid for. Based on that I would like the base to automatically fill the future delivery dates for each client record considering the informations we have. This will be importante so that I can set up a calendar view later that will allow me to know all the clients I have to make deliveries on any specific date. Thanks in advance for any help and I am sorry if this is not the right place to ask.

I have a table with a field called "plact_is_main_activity"Only one record for all the records sharing the same "_plact_asset_" can be "plact_is_main_activity"=TRUESo I have set an automation triggered when "plact_is_main_activity" is updated.When triggered, I need the automation to search which is the record:other than the one just updated,sharing the same "_plact_asset_"that has "plact_is_main_activity"=TRUEand for that record, make "plact_is_main_activity"=FALSEThis is, I need a switcher between records sharing the same asset in such a way that only one can be "plact_is_main_activity"=TRUE.In the attached image, if record #2 was turned into the main activity by ticking on "plact_is_main_activity", the automation would need to untick "plact_is_main_activity" for record #1 rather than leaving both ticked.I have not managed to do it with an automation that updates records when triggered, so I would appreciate any tips on how this could be done either by triggering a

Subrecords is the one aspect I don't like in Air Table and I am struggling with a case right now. Maybe somebody has a smart and simple solution. I feel my design is flawed but I did not find any other practical way to work this.Let's say I haveTABLE AField 1: Location name (text)Field 2: Sub-location name (text)Field 3: [Field 1] & [Field 2] (calculation field)Field 4:: A chekmark field to filter out sub-records, so I can a list of records without seing all the time I repeat Field 1.TABLE BField 1: Area code (text)Field 2: [TABLE A Field 3] (linked) What I would like is a list of unique records of Table A Field 1, with all the linked records in Table B Field 1.And I can't seem to find a simple solution. 

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

Hello! I use an automation email to send information to team members. This includes some really long URL’s. Just for the sake of keeping that email tidy, is there a way to hyperlink some text with the URL in the email? So instead of saying “Click this link: (long URL)” the word LINK would be hyperlinked to the URL? Thanks!

I built a base for a project, and shared it with several users with editor privs. I added them to my own workspace, and thus assumed responsibility for the cost of their (Pro) accounts. There are a lot of bases in my Pro workspace, but I'm only sharing this one base with these users (i.e. I'm NOT sharing my whole workspace).The project has now come to an end and I want to stop paying for these users but I'm a bit unclear about how to proceed.If I unshare the base with them (leaving myself as the only user), does that remove them from my workspace as well? More important, does it mean that I'm no longer paying for them?If I unshare the base, what happens from their perspective? Do they still have accounts? If so are those accounts downgraded to free accounts?Those are my urgent questions, but I just thought of something else. A business has hired me as a consultant to help with a base they had already started themselves, in their workspace. They shared the base with me (with creator pri

I cannot figure out how to filter all entries where “date” is the current month.

Is there a way to customize what fields are visible/hidden in an expanded record view for linked records? If I’m just in an expanded view, I can hide/unhide fields in the dropdown for each field, like so: But if I’m in the expanded view for a linked record, that option goes away: Screenshot%202|309x500 Field visibility doesn’t appear to be related at all to field visibility on the table I’m linking to. For example, I have admin start date and admin end date both hidden on the view this record is linking to, but they’re visible in the expanded view for that linked record. Any suggestions? Thanks in advance! Jess

Hi,Currently, I use automations to create Google Calendar events from new records in Airtable. I prefer to manage the events directly from Google Calendar. I find moving events (jobs) is more fluid than doing so in Airtable. What I need is to create an automation that updates an Airtable record when a Google Calendar event is updated. I would assume the trigger is - GCalendar update and I would think I need to find and match the airtable record to the GC event. I stumped on this part.