Ask the Community

I have a field that gets the id from a different line, for example: iddepends on id (void if doesnt)statuscan be done1 In Progressyes21To Dono In this table, each task have an ID.This task might be done only after another task is done.For that, I want to if there is a value in "depends on id" and the status of that task is Doneshow "yes"otherwise show "no" As a workaround in the meantime I used a Link to a Table and a Lookup, but I don't want extra columns to avoid clutter if possible. How can I accomplish this?More specifically, how do I reference another column given an id?Thank you for your help!

Hi there - I am having trouble creating automations to change the status of a single select field based on start and end dates.Example 1 - I need the status to change from "Scheduled" to "Live" once a start date has passed. As in, if a class has a start date of 1/5/24, then this record would switch from "Scheduled" to "Live" once 1/5/24 begins.Example 2 - I need the status to change from "Live" to "Completed" once the end date of the class has passed. I set the automation trigger for "When a record matches conditions" If END DATE is before today. The action step is "Update record" but this is where I believe I'm having trouble getting the automation to read the entire table and make all applicable changes.Attaching screenshots of what I tried based on END Date, but it did not work. Any help is appreciated.

I started with help from this support topic: Formula help for an IF(logical, value1, value2) Formulas So I’m using a formula in a column to pull data for another table. This is my formula: IF({Test Type} = “CAT 1”, {Date Only}) Which is basically: If the test type is CAT 1, then display the date from the ‘date only’ column. My problem is this… sometimes tests are both CAT 1 AND CAT 5, but I still need it to pull the data. So what I really need is IF test type CONTAINS CAT 1, then display the date from the ‘date only’ column. I used Fieldbook before Airtable and in that instance I was told t… But I need some help matching a partial string. In my example: Students have a set of “awarded units”, which is a lookup field with multiple values. Those values are matched on a second table to return the “current equivalent” unit, this result is returned in a string. I then want a set of fields, each dedicated to single unit, to test whether or not that unit e

Hi everyone, I am a beginner and I'm quite overwhelmed with how everything works!&#x1f605  The templates I am finding don't seem to help with what I need. I'm wondering if anyone knows how to build a simple airtable base where each staff member on the team can have their own private view to track their overtime hours and where the owner/manager can view them all? We don't actually pay for overtime, instead, we offer time in lieu, so a column that calculated their hours based on whether they worked the overtime on a regular day or statutory holiday is a formula I think I'd like to have in the base. Does anyone have any advice? 🙏

Hello! I am attempting to recreate some data I have in Google Sheet and improve my work flow. I am currently counting things by hand and it taking to long. What I am trying to do is create a "Master" sheet where all my info lives. But have a "Stats" table that will then automatically aggregate the data by Photographer and month. It would count the specific "Production Type" and sort it by "Photographer" and month. I have attached some screen shots. I have been trying to google it for days with not luck. Here is the start to my "master" tableHere is my current "Stats" tables I have in Google Sheets:By Month:It then feeds into a yearly data sheet

Hi, I have a column where the information is linked to a value in the same tab. I would like the information to be automatically filled with the information on the other line. For example on the screenshot, I would like to have John Doe in the cell for Brandon Walsh when I update the john Doe line.  I tried with the automation but couldn't figure out how to do that.  Thank you very much...

I have a formula for my primary field that looks like this: CONCATENATE({Last Name}, " - ", Type, " - ", DATETIME_FORMAT(Start, ‘MM/DD/YYYY’), “-”, {Job Address}) and it turns out looking like this: Thorton - G, DS, GC, - 08/17/2020- 692 Chateau Ln. Holly Lake, Tx 75461 I would like only the House number of the address to show in the primary field. How do I shorten the address in the formula? Thanks in Advance!

We have a lot of projects and i want to create a refined high profile project interface. Option 1 is for me to manage what projects show up here, and its a singular list no matter who you are. We are all looking at the same high profile projects. This is easy to do, but less affective. Option 2, which is preferred, is to create a customizable high profile interface. So that each user can go to the page and see the projects they want to monitor. The problem i have with this is that it would need to be a multiple user field, and we would need to trust that when someone edits said field to add or remove their name that they dont mistakenly delete other names. So im looking for a way to make this happen with less risk of user error. one thought is to make a checkbox field to add to your report, and a separate checkbox field to remove from your report. then setup an automation that watches to see what user last modified one of those fields and then the automation would update

Hi. I'm not sure if this it the right place to ask. At the moment, I handle all the Airtable development, base design, formulas, etc.I would like to start looking into delegating this to a third-party, in order to be able to focus on other aspects of the business. My concern is how to do this in a way which safe-guards both my data, and as well the functionality of the existing base.How can one control if any third-party knowingly/unknowingly breaks down part of the base? I assume any such third party would need Creator access, which would give them full access to everything. My concern is not access to data, but making sure that nothing breaks.Apart from Airtable, we also use heavily Make (ex-Integromat) as well as Softr for an internal portal.  While I know that Airtable has snapshots, which one can recover to - one of the issues is that Airtable recovers into a new seperate base. Hence, any scenarios of Make would not be linked to the recovered base, and it would be quite a nig

So, I'm pretty new to no code apps and have unsuccessfully tested several other products for this feature.  Can Airtable perform this feature?  I've poked around the community but couldn't find anything, feel free to describe it like I'm 5.  Any help is appreciated...I'm trying to build a calculator app off of an existing excel model where a user can populate months worth of records into the app and then the app runs through the calculations to find a forecast of the data and gives some output, values, chart etc.  The ideal method is that a user would copy and paste from XLS, website or TXT files and just paste into an "input form" or grid/table and then the app would calculate.  Here is a basic version of the setup...Date (user input)          Widget Production (user Input)     ------>  Calculations and Output3/1/2010                           

Hi Folks, I'm trying out using the rating field for a ongoing review process and want to be able to roll up an average of those ratings. I've managed to get the rollup to work but can't get rid of the NaN for fields that don't have ratings yet. I've tried a couple different formulas that I've seen for similar questions but nothing seems to be working. Thanks!

Good morning I created a script that displays a result I want this result to be displayed when we click on the button linked to this script thinks

Hey everyone,I have a question regarding second-level filtering. In a classic CRM setup, I have a table that holds all my opportunities. I have another table that holds all my activities (say to do items that can be linked to opportunities in airtable) that contains a status field (to do, doing, done)My goal is to display all opportunities that do not have a planned (planned = status is not done) activity linked to the record  (every sales deal should have a next step planned. 100% stolen feature from pipedrive).Any way to achieve that in the interface?So far, I was able to half-achieve it by using the "when linked record field is empty" but that doesn't solve my problem since it would fail to highlight opportunities that have a linked activity marked as done, but not other activities linked.

Hi,I am fairly new to Airtable. Sorry for my newbie question.We are looking for a way to trigger an automation:when the Field STATUS changed FROM "Assigned to" TO "Working on it".It's the:FROM "..." TO "..."option we can't find in Airtable.We often use these trigger types in monday.com, but now I just can't find it in Airtable.Is there a way to work around to get this "from" - "to" trigger in Airtable?

Hi,I'm attempting to locate a know record with an email address containing a "+".  I've tried introducing a '\' and '\\' before the '+' to no avail.  Tried CURL with your API encoder, no luck.CURL EXAMPLE:curl -H "Authorization: Bearer patZZZZZZ" https://api.airtable.com/v0/appXXXXX/tblYYYYY? filterByFormula=%7BEmail%7D%3D%22bob%5C%2B1%40gmail.com%22I can get results with an email without a '+' character in nodeJS and CURL.How do I specify a filter that enables the retrieval of a record by email address containing a plus?  This does NOT work:const header = {   maxRecords: 1,   filterByFormula: `{Email}="${email}"`,   fields: [      "Record ID"   ],   view: "BulkEmail"} 

Hi folks, appreciate any help you are able to give here....  I have a base where the users enter pricing information from suppliers.  Sometimes the pricing is given to the users including tax and sometimes excluding tax.  At present all data is entered excluding tax forcing a manual calculation which is clunky.  I would like to have an either/or useability whereby the price ex tax cell is locked for input if the price inc tax cell is entered and vice versa... is this possible?Thank you 🙏 

Hi,How do you sync PropertyMe properties to Airtable?

Hi all!Maybe someone has solved a similar problem.I'm making a kind of task tracker, but I can't solve the following problem.If a task (record) is created with several responsible people, I need the automation to work and split one record for each responsible person separately, that is, for 1 record to have 1 responsible person, but initially the ability to create a record for several people remains.The resulting flow is as follows:1) A record is created through an interface with several responsible persons2) Automation creates similar records by alternately assigning one responsible person to each record until the number of responsible persons ends3) The first task created through the interface is either deleted or the first responsible person is assigned to itHow can such a problem be solved?

Here's what I want to do. I have a field that lists percentages for the fees my company wants to add to a contract. Admin fee 10%, Late fee 5%, etc. If I were to stack these fees, I want to have a field that returns the sum of each percentage multiplied by the contract subtotal field. Is there any way to do this? Like: SUM ( (10% x $800), (5% x $800) ) but where it could recognize the array and do the math for each percentage. 

I have a small team plan with 3 accounts users and pay on one credit card. However, there is a base where I need to collaborate externally. If we have a paid plan, can our external partner collaborate/edit our base for free? If not, can they create their own separate account and pay but still be able to collaborate/edit our base?I am trying to avoid the need to put them on my payment plan? Please recommend the best course of action for external partners. 

Hello All!I'm trying to make the Airtable search function in Make/Intergromat say "IF a google drive file name contains an Airtable content id, then show me that record" so I can then add the files web view link to the record.  So the finished automation would be: WHEN "finished file" is uploaded to "finished folder" THEN add the google drive link to the records Finished URL field The current formula im using us IF(FIND("{{1.name}}", {Title}&""), "yes", "no")It's "working" but the results are unrelated to the file name... see screenshot What forumla should I use to tell Make/Intergromat to search for the record?

I have created a formula that gives employees a personalized link to fill out a form so that when they fill out the form, they only need to answer the questions and don't have to put their name, employee id, etc. Is there a way to get around not having them sign in to use the personalized links?I have already turned off the "See who submitted this form" box and the under Share Link settings the "Restrict access to enterprise email domains" option. It doesn't make the person sign in with the regular link to the form, only the personalized one. Hoping there is a way around this. Any help would be greatly appreciated. Thanks!

Hey guys, I’ve got several automations set up where the action is sending emails from my Gmail account. However, the “From” name in these emails isn’t aligned to the “From” name on my Gmail account - it’s simply displaying my email address as the “From” name. Can anyone help?

I have a Table that lists everyone who has taken our leadership courses (Participant table). Fields include Participant Name and FLL Attended.I have a second table listing everyone who is a salaried leader in our company (600 records). I want to have a column (field) in the Salaried Leaders table that shows if they have taken our FLL course. How do I set it up so that the Salaried Leaders table links to the Participant Table AND populates the field with the class they took?  I know I can do a linked record, but then I have to manually select and that is inefficient.I know the answer is probably pretty simple, but I just can't get there on my own 🙄

In my scenario, I have a trailer that may have multiple batteries assigned to it. When a battery needs to be removed, the client brings up the battery detail in an Interface and clicks 'Remove'. This launches an automation where multiple things occur:A ticket is opened for the batteryNotes are added to both the trailer (in the trailer table) and the battery (in the battery table).Then, I want to run a script to remove the battery from the trailer.I found another post that was doing something similar, and after much troubleshooting (I'm new to coding), I've got it down to one error that I'm not sure how to troubleshoot. Error: Request parameters failed validation. at main (script:14)A few notes, yes, the input values from the automation are lists, but there will only ever be one value in the list, which is why I used JSON.stringify. I also suspect the code in line 13 may be wrong.Thanks so much for your help!Code:   const inputConfig = input.config(); const inp