Ask the Community

Hello,Is there a way to have two-way cross-references between entries in the same table?For example, there is a table [Companies]. Each entry, a company, can have clients and suppliers. If a company has clients, it means that those clients have at least one supplier - the company. I'd love to be able to connect entries so that when I assign clients, those entries automatically get updated with supplier info—and vice versa.Another example is Investors/Funds and Portfolio companies. I want to be able to add portfolio companies to a Fund and automatically have this Fund added as an investor to all its portfolio companies.Such two-way cross-reference works fine if I have several tables, for example, [Investors] and [Companies]. Airtable shows all the investors associated with a company and all the portfolio companies associated with an investor.However, I am looking for a solution to keep all the companies (portfolio companies, investment funds, client

Can anyone please help me solve this issue? Before 1/1/2024 I have to calculate a 2.99% fee and after is different 2.29%. I am trying a formula but only giving the result after 31/12/2023, before the result is blank: IF(    {Date Booked},    IF(        IS_AFTER(                {Date Booked},                DATETIME_PARSE(                 &nb

Hello - I'm trying to figure out how to set a price based on 2 other columns. One column is Product Type (Socks) and the other would be Variant (single or 3-pack). So for example if Product Type is Socks and Variant is Single, the Price should be $3; if the variant is 3-pack, the price would be $8.Both Product Type and Variant are single select values, and I could potentially make the Price a single field as well. I also thought of combining Product Type and Variant into one column (Socs - Single, Socks - 3-pack, etc) and do Link Records instead, but I would like to eventually sort by Product Type alone (all socks, for example). Does anyone have any experience in this for inventory tracking? Thanks!

I am currently working with the Webhooks notifications (https://airtable.com/developers/web/api/webhooks-overview) to process record updates when a set of files/fields have changed. While I love the power and flexibility of the notification, especially the `fromSources` filtering and metadata, I have hit a few roadbumps in my implementations and I'm wondering if I am missing any obvious solutions that others have discovered.- Cursor value. Initially I thought I could possibly track the cursor value, but then I realized that this is likely just the cursor from the start of the payload list, so after 7 days of payloads, the max cursor value from the payloads will be less than my locally saved cursor, so this doesn't seem viable.- `baseTransactionNumber`. Since AirT

Bonjourje souhaite partager un formulaire a deux prestataire externe le premier va remplir le formulairele deuxième va consulter ces informations remplit et mettre juste valider ou nonavez vous une idée comment faire cela ? 

Hello, As the image uploaded in Airtable returns the URL of the image, I want to convert the contents of the URL(image) to base64, btoa() converts the URL to base64 but not the content of the URL (Actual Image), I want the uploaded Image in base64 format. Is there anyway to do this inside automation script? Thank you

Hi all,Airtable Table Newbie, but feel in love.I want to group rows by partial text in the field.(CDPA) Campaign 1(CDPA) Campaign 2(CDPA) Campaign 3I want to group all three above using the (CDPA).I assume it would create a formula row to do this, but I do not know how to create the formulaCan someone help?Thanks,Judd 

Afternoon,I've had 2 ideas recently whilst building a lot of automations. Please do say if they already exist and I've missed them.When creating an, "Update record" action, please auto-fill the "Record ID" with Trigger item's record id if it's from the same table as you're updating.1. Every time I'm building an automation, if I'm updating a record on the same table as the trigger, the Record ID, is the trigger item's Record ID. Could AT autofill that Record ID token? Or maybe, a quick function link underneath the input box, "Use trigger record's Record ID" which fills the box when pressed.2. Is there a shortcut key to access the dynamic variables in a field, please? Often I'm filling in a Field in the automation type some words, but have to move to my mouse to press the plus button and access the data key explorer.Instead, maybe like how a

How to add SMTP inside AirTable as there is a checkbox Send Email?

Hi all, What do you find the easiest to connect (and scale) Airtable to when it comes to reporting/dashboards, Power BI or Tableau? I realise there are no connectors for either through Zapier but have seen some workarounds for both tools. Any thoughts or suggestions? Regards, Tom.

How to filter and set condition IF EMPTY?

I’m currently working on a fairly large base and I was wondering if there is any way I can link it to Tableau, reason being I would like to visualise the data while I’m cleaning/enhancing it. I know I can download a csv - but I’m wondering if there is any way I can link directly or automate this so when I add a new record or alter data I can see the impact in Tableau.

I’m currently Zapier > Google Sheets > Tableau … Looking for Zapier > Airtable > Tableau Equiv … any ideas? Thanks in advance …

Help! I am using the Project Management template and in the broad view on Projects I can reorganize the projects into whatever order I want them in. However, when I get down into the Project and Project detail base (in List view), the only way I see to reorganize them is by sorting and that limits me to A-Z and Z-A. Is there a way to move around the projects in list view that I am not seeing?

Hey, we are currently experiencing the issue that a automation changed the way it works. The Find Records Automation used to just fail if it searched for a empty field now it gives us back the maximum Amount of Records it can find(100).These are also not empty in the field that is searched for. Is this a intentional change or just a bug? 

I have 3 tables in a gsheet - Meals, Dishes and Ingredients with a one to many parent-child relationship through IDs - meal ID, dish ID and ingredient ID.Is it possible to upload this data along with the relationships or I need to establish the relationships in airtable again manually?If it is possible, kindly also explain how?Thanks a lot. Grateful to the community.

Hello everybody,I am very new to AirTable. English is not my native language.I created an external form with Fillout, which is connected to my AirTable base.When I use the block ‘multiple choice questions’ in Fillout, I have 2 options I am aware of :-Connect it to a ‘single-line text’ field-Connect it to a ‘single-select’ field The first option works great, however the second one, which is the one I’d like to use to get the advantage of the colors, brings up the following problem :Whenever somebody fills out the ‘other’ option in the Fillout Form, it creates a new single-select option in my table, which is great, BUT, at the same time, the form is automatically updated and the new option is now available to new users looking at the Form, which in the end can be a problem if people write a lot of nonsense.On the

Hi all!Please tell me, is it possible to change the rights in the interface on a specific entry after the automation has been triggered?I want to do the following:1) I have a Kanban board - an interface in which, when opening one of the records, you can change the status, date, etc.Is it possible to prohibit changing the status or date of this record when a certain status is reached (for example, done) without restricting others?2) I would like certain fields in posts to be edited only by the record author (the record author creates the post via a form)?Thank you in advance and wish you a good productive week!

I have a tab within a table, the tab is called PTO. the PTO tab has two different views I am working between for this automation. The PTO tab as a whole is populated from forms that are submitted containing requests for time off from employees. This form contains fields for [start date] and [end date] and is intended to capture both single and mult-day requests off. The first automation sends an actionable slack message for approval, which is working correctly. The second automation I am trying to set-up is intended to send a message to a slack channel each day that there is an employee out of office, listing which employee is out of office. (Bonus points for this only running Monday-Friday, even if the dates fall on the weekend).My first attempt at the automation was setting up the second view of the same tab, which would be filtered to only show records based on conditions, but I wasn't able to find a way for the records to populate if the request required more dyn

Hello,I have a Database that includes a table of Users and a Table of inventory (Computers , Monitors, Docking stations and so on).All of our inventory is mapped by serial number.When I give the user a device I assign it to the Air table.I want to have the option to see the assigned history by user or by device.That means if I have a user name Tom, and I gave him on 01/12/2023 a laptop: Lenovo Thinkpad , S/N:ABCD123, and I took it back on 15/01/2024.Let's say I have the record of this computer. Through that record I want to be able to view the computer assigned History- that means when it was assigned and when it was unassigned. And also the opposite way, through the user record to be able to see which devices were assigned or unassigned to the user.

Hello and thanks in advance.  I have form submissions coming into Airtable via a Zap from Gravity Forms.  The problematic field is Location which contains lat, lng, and address. I need lat and lng in separate fields in airtable.  This is an example of the imported data: {"location":{"lng":-122.38418565202375,"lat":47.653449368341484},"address":"Magnolia Connector Trail, Seattle, WA 98199, United States"}I need to wind up with 122.38418565202375 and 47.653449368341484 in separate fields. I've created 2 new columns in my table with the names lng and lat and installed the scripting extension. What do I do next?  Also I would like to process all the existing records at once and then process all new entries one by one manually when they come in.Thank you so much! 

Hi,I am trying to set a date field value to today's date, when another value for that record is updated. e.g. when status changes to X, set date field to today's date. I am simply looking for UK date format e.g. 23/01/2024 Does anyone have any ideas? Thank you in advance. Thanks,O

I have a base full of contractor information (Name, contact info, addresses, etc.) these fields are concatenated into one field.I sync this contractor info base across our project bases so that the information is readily available. When I select a contractor from a dropdown list on a project base I want it to use the corresponding concatenated contractor info field from the sync'd contractor information base into a 'contractor info' field on the project base so my users don't have to copy and paste the info in every time. I've been trying to use automation? Is this possible? What is the best way to achieve this? Shouldn't be too hard to select an option then autofill info based on that selection right? What am I missing? 

Hi! I am teaching myself through online videos, and I stumbled across one that showed me how to create a form and automate an alert in a Team Channel. I did that and it is working great. Next, I wanted to see if I could insert a link so anyone that sees that alert, can be taken directly into the table/grid. I found a video that shows me how to do a custom message, and I can get the name added, but when I add the Base URL, it will not work. At first, it was adding a long ugly code but now nothing. I am not sure what I am doing wrong, and appreciate any assistance. 

Hi all, I'm trying to set up an automation using a trigger using a linked record field. What I want is to trigger an email whenever a record has two or more linked records in a field (but not one). Is this possible to set up?For example, let's say the records are individual baseball players, and the field "Teams played for" links to a "teams" table. In Babe Ruth's record, the field would link to "Red Sox", "Yankees", and "Braves". In Mickey Mantle's record, the field would only link to "Yankees". In Jackie Robinson's record, the field would only link to "Dodgers". How can I set the trigger to email for Babe Ruth's record and not Mickey Mantle or Jackie Robinson?