Ask the Community

Hi - I am trying to update a forecast in case the field hasn't been updated for over a month. The idea is that if there are no updates, the forecast would lower by 10%. It all looks great, until I have to "Update record", I pull the record ID (dynamic) and added the field "Forecasted" and also make it dynamic. I add the field "Forecasted" and multiply it by 0.9. However, this creates an error. Here are the different versions and the results: "Forecasted"*0.9 --> Error"Forecasted"(0.90) --> Error"Forecasted".9 --> If the original value was $15,000 it shows $150,001 (maybe it thinks I want to move the decimal place?)"Forecasted""Multiply by" --> I created the field "Multiply by" to all equal 0.9 in the data, but whenever I place both of them together, no changes"Forecasted"*"Multiply by" --> Error"Forecasted"10% --> ErrorThis should be simple, the formula is pretty easy, but for some reason I can't get it to work. Can someone please help me? Thanks!

Hi all, I have run into a problem with an automation where I am copying values from some formula fields into fixed fields. I have narrowed the problem down to 2 different fields that halt the automation. Both the formula field and the fixed field I am copying to are formated as decimal with 2 places (x.00). I know this worked before while I was developing it, but now it fails. The error message shown is “fields could not be converted to a string”. I see 2 questions for this topic in the Community, but I can’t see the solution. This is making my head explode, so I would appreciate any help you can provide.

Hello,I'm trying to create a mapping using IF and OR statement, in order to map a set of values for the 'Status' field to this new formula field.  This formula doesn't cause an errors, but it only partially works.  Does anyone know why this doesn't work?IF({Status} = "Complete",  "Completed",  IF(    OR(      {Status} = "Low Risk",      {Status} = "Candidate"    ),    "On track",    IF(      OR(        {Status} = "Medium Risk",        {Status} = "High Risk",      ),      "At risk",      IF(        OR(          {Status} = "New",          {Status} = "Needs Investigation",          {Status} = "Need More Info",          {Status} = "Under Review",          {Stat

I have a field that can at times have existing linked records inside them. I have an automation that when a record matches conditions will input a linked record to that same field. The issue I am running in to is that it replaces the existing linked records in there. I tried doing a dynamic input on the automation to include the existing linked records then separating with a comma, but it fails when testing. Any idea how I can keep existing, but add a new linked record in that same field with the automation?

Hi All,I'm trying to set up a resource tracker using the summarise function within the timeline view.In short, I want to be able take the days associated with a task and spread these across the length of the task. So if a task takes 20 hours and the task length is a week, then the summarise function would say 4 hours for each day and would group accordingly dependent on the scale we were looking at. I'll be grouping by individual, so want to be able to get this value summed across multiple tasks. This must be what the system is doing under the utilisation function, as it'll this to compare the available days to create the percentage, but I don't seem to be able to get it to work. When I go to summarise, and go to sum, it just shows me the total number of hours and doesn't spread the amount across the days. Crucially I don't want the percentage of available time used, I just want the number of hours themselves.  Thanks in advance!  

Hello, I am looking to build automation.I have 2 tables: Task and Sub Task (both are linked). If a subtask is created under the task record, then the project selected on the task should be auto-populated in the subtask project field related to the specific task. Thanks in advance!

HiI am trying to use below code (Google Apps Script) to get data from Airtable. The fetch request succeeds but the fields are returned as text [Object]. I am not able to see actual data. However the request works from other HTTP clients like Bruno.I have observed another issue. The code with small change marked below used to return data perfectly till couple of days ago but suddenly started throwing error 422. Hence I made below change and the result is missing data.Even GET method results same.Please suggest how this can be resolved as this is a show stopper.Currently the result is like below{ id: 'recrR654MViYPpGG5', createdTime: '2024-01-30T10:38:29.000Z', fields: [Object] }My code is as belowlet invoicenumin = "EI000002"const scriptProperties = PropertiesService.getScriptProperties();airdbKey = scriptProperties.getProperty('airdbkey')const fieldObj = ["quantity","unitprice","lineamount","itemdescription"]let filter = "{invoicenum} = " + '\''+invoicenumin +'\''const atdata = {//"rec

I gave access to a couple of people who are actually my clients to a database I designed for them.I want to know what is the exact charge for those licenses / users so I can charge them for those expenses.

I have a payment tracking table. It has fields that are Original Cost, Variable Cost, and Fields for each month(Jan - Dec): Formula Field). The original cost is linked from another table. If the user does not provide any value to Variable cost, The original cost value will be split into 12 months in respective fields for each month. Otherwise Variable cost value will be split for each month. But my requirement is User can add the cost for each month manually if the client has paid a different amount for each month So that we can calculate the balance amount for the rest of the month.

Hey Airtable Community!I have a problem that's been bugging me for some time and I can't seem to solve it, so I decided to ask for your help.I have an automation on Make.com that pulls data from my bank account, looks for transactions by [transactionId] in my Airtable base and, if not present, adds a new record. The problem though is that the filter formula I'm using in my API call sometimes works and sometimes doesn't.What I mean is when I perform tests, everything runs fine and after a few days the formula stops working - it doesn't identify correctly the records that are already in the the table and adds them again, effectively duplicating existing records. When I trigger the Airtable API call manually, using the [transactionId] field with filterByformula, it returns records correctly, but when it is executed in the workflow, it doesn't work.This is the formula in the API call I'm using: FIND("<transactionId>", {transactionId})=1Any help or guidance about what might be ca

Hi,I'm evaluating if I can user Airtable for a Job Requisition Approval process.Hiring manager fills out form for new vacancy  (done)New records ends up in table (done)Boss of hiring manager get's email notification (done)email includes a link to a form showing the recordset data and a approve/disapprove choice (not done)I don't get how I can do 4. Any ideas?ThxMarvin

Hi everyone, I'm a beginner at airtable automation (so excuse the novice question) - I'm trying to figure out how to set up an automation to send an email with attachment when a new record is created. Same attachment will be going to all emails. More info: 1. User fills out a form on website with email address. 2. New record is created in Airtable table "Contacts" with the email address3. I think this record then needs to be updated to include the attachment (unsure how to do this) so that it can be attached in the email automationAny help would be greatly appreciated 🙂 

I just found all my personal info including social security number on a public link on airtablewtf is this site? I reached out to airtable’s customer service support I’m freaking livid  

Hello, I find it difficult to work with time frames in Airtable. Am I missing something?Example:Let's say I'm selling cars and with each sale I add it as a sold car record to Airtable with its details.Manufacturer: AudiType: A6Date: 22/3/2024Price: 50 000 €Condition: NewNow I have a DB of all cars sold in last 4 years and I would like to make an interface where I would filter variables (type of car, condition, ...) and timeframe it was sold in to see my average monthly sales of cars that corresponds with my filter. So basically I would know that based on data from last 24 months, I've sold avg. of 0.8 Audi A6 per month.Any ideas? Thanks.

Hi! I'm trying to use a Task Template table & an automation to create Tasks aligned to an Account based on a specific criteria. I've got the automation working with the following set up: When a record matches a condition in the Accounts tableProduct/Service [LinkedRecord to the Product/Service table] is not empty Find Records in Task Template table & create list based on Product/Service dynamically pulling in Product/Service of Airtable ID in triggerCreate Records in the Task List for Accounts table with the relevant fields. Here is the problem: I want the "trigger" to be a multiselect field (IE there could be one or many product/services purchased by an account). I am having trouble figuring out how to change the trigger such that it creates tasks that are linked to multiple Product/Services. (In the Task Template table I've also linked the Tasks to the Product/Service. Some of these tasks can be for all three services). I want to look at ALL of the tags in the&

Is it possible to only show certain fields to certain users?For instance, if someone is logged in and has an email that ends in @whatever.com, we can mark that field only visible to those users.Any other suggestions would be welcomed!

Hello, I'm fairly new to the paid version of Airtable and I've been able to figure out most of the features and automations I need. I'm specifically wondering (especially with the updates that have come out) if there's a way to validate entries and form conditions. Example: students input their e-mail address in a form. If it does not meet the condition of having their .edu e-mail address, there's no way to reset the form or put an error message up. I have tried putting a conditional field that it must include the .edu student address portion, and I made it a "check box" format with an error message. Students do not seem to read this and submit the form with incorrect data or the form not even being filled out. Is there a way to not allow the submission if certain things are incorrect?Also with attachments, is there a way to condition that attachment to only accept certain types of files? Thank you!

Does anyone have any ideas on how to label relationships in this CRM we are building? We have multiple relationships we want to label such as spouses, siblings, advisors, parent-child. We also want it to work in the inverse so it shows that Sally is the child of Tom and Tom is the parent of Sally. 

My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples:  Site A's publication will be taken down on May 31, and the new one will go up on June 1.  Site B's publication will be taken down on May 31, and the new one will go up on June 6.These require different processes ("turn this one off, wait some days, then turn the next one on" vs. "replace this one with the next one"), and I need to indicate which process should be followed.Each publication has its own record in the tableSite A / Start Date: May 1 / End Date: May 31Site A / Start Date: June 1 / End Date: June 30Site B / Start Date: May 6 / End Date: May 31Site B / Start Date: June 6 / End Date: June 30How can I check to see if the Site's records are "back-to-back" dates? In this case, Site A records are back-to-back, while Site B has a five-day gap in between.(I'm assuming this is going to have

Hi Folks, I need to find the linked table id of a lookup type column. Airtable metadata api returns this information for record links type field but it does not return for lookup type fields. I share sample response of metadata api for those field types. { "type": "multipleLookupValues", "id": "fldXYZ", "name": "Column 1" }, { "type": "multipleRecordLinks", "options": { "linkedTableId": "tblXYZ", "isReversed": false, "prefersSingleRecordLink": false, "inverseLinkFieldId": "fldYYY" }, "id": "fldAAA", "name": "Column 2" }

Hello, I am building an Airtable integration for my product to use the Airtable API on behalf of users. I would like to use the Official API client which is airtable.jsIn the interactive documentation link given, I had a look at the "Javascript" tab to see code snippet about Authentication, but it is using apiKey.In the airtable.js documentation saying :"OAuth access tokens can also be used." I would like to know how.Do you have any code sample with OAuth or documentation showing how to use OAuth access with airtable.js please ?

I've read through several help topics and I am still having issues, hoping someone can help me. I have a field that is counting the days between the due date and todays date. I need to use these numbers to create a formula to provide an aging report. I'd like the 'Aging' Field to use age count to represent I need to group my table by aging, which I am trying to do by creating a formula based on the age count.if age count has a number between 1-30, aging is 1-30if age count has a number that falls between 31-60, aging is 31-60if age count has a number that falls between 61-90, aging is 61-90 Daysif age count has a number that falls between 91-119, aging is 91-119 Daysif age count has a number that falls between <120, aging is over 120 daysI’ve read through many articles and forum discussions about the nested formulas, but continue to run into errors, as a lot of the examples are not for so many options.Not only am I having trouble with the formula the age count formula

Hi, I don’t know whether this is a bug or something has changed - we have calendars on our outlook account - we did this using ‘sync to external calendar’ links. We noticed the calendar events are no longer showing in our outlook - they previously were. I am unsure when this changed. I have deleted and re-added the link and the calendar is still not syncing. Has anyone else had this problem?

Hi, I’m looking for a way to query the “line number” (based on the current manual sorting of a table) when iterating over the records. I don’t have a table column which reflects the actual sorting so I can’t use a column as sort criteria with selectRecordsAsync(). Please see this simplified example: let table = base.getTable("MyTableName"); let result = await table.selectRecordsAsync(); for (let record of result.records) { // if record matches a certain criteria -> output certain record fields // including the line number according to the current (manual) sorting sequence } Any hints are appreciated! Thanks, Stefan

Hello!I am looking into creating a workspace where my team would manage information in tandem with our vendors. There will be sensitive information within our workspace - is it possible to give access for a workspace to a vendor, and restrict specific columns, tables, rows or custom fields?Any help would be greatly appreciated!Thanks,Harry