Ask the Community

I have a table that has a column, lets call it Food. I want to create datasheets for the drop down options I have set up for the food column and I am looking for a way to cater a page set up based off what drop down option is selected. For example: There are two drop down options. Option one is Soda and option two is Carrot. Some important information about soda would be sugar content, manufacturer, calories, etc... and some important information about Carrots would be, pesticide use, region grown, etc... I have all of these bits of information created in my table and I now want to be able to print of datasheets showing the information. The problem I have is that I don't want to display the same information for both Soda and Carrots because only certain fields apply to each. So my question is, is it possible to create separate page designer layouts for specific field values in a table? If not is there a clever workaround I am missing to make it possible.&nbsp

Is there anyway to generate an automation that updates field records within a table by matching values in a different column, similar to an Index/Match function, between AirTable and Google Sheets? Essentially, my team manages IRB protocols and we need to track due dates for annual reviews. I'm trying to have the due dates updated in AirTable once the annual review due date is scheduled. Due dates are updated arbitrarily by my institution throughout the year, so I was planning to do a manual export from the institutional data source to a google sheet on a regular basis. Then, once the google sheet is updated, I want to run an automation that updates the Due Date for each corresponding IRB Protocol. Is there currently a way to do this only using AirTable & Google Sheets? My institution doesn't allow for 99% of external extensions. 

Is it possible to edit the email notification that is sent out when you @ a specific user?For context;  as our purchase order moves through various stages, the access to those stages is dynamic.  When a user a elevated stage access comments at a user with a lower stage access, the lower access user receives an email notification with a link.  However, the link takes them to the interface that they do not have access to.  We would like to update the URL that is provided to send the user to an interface where they can see the record and interact with the comments field.Thanks!

Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above the line and below the line)Table 3) ActualsTable 4) Cashflow forecastCHALLENGES: 1) On the budget - certain line items are subject to fringe (payroll fees, withholdings on a state-by-state basis, admin fees, etc.) and need to be calculated on a per line item basis. This is not consistent across the budget. How to solve for this? 2) From the above - - for things subject to fringes - we need to have a number calculated and roll up to the first table outlined above (the budget top sheet). How best to do this?3) We also need to calculate contingency - which is only calculated on Below the Line costs... how best to delineate this - calculate this - and have the

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 so

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"    ),

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","

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})=1

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'm writing to inquire if it's possible, either through an extension or natively, to track whether an email sent via automation has been opened or not.

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

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? 

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

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" }