Solved

Hi Brains trust. I am wanting to show the days a job has been active for, from the date the job was created. All the formulas i’ve been trying aren’t working. Any tips please?

Have a table I create records with using a form - since this morning after airtable was down I still haven’t been able to upload attachments. Have tried multiple browsers, iOS, have even tried uploading straight to airtable. Wheel just sits there and spins saying upload. Any ideas? Haven’t had any issues with my tables thus far until this morning. Thanks

Hi Everyone, I was wondering if I can create a formula that gives me a certain number of months ahead instead of changing the filter from a certain date to date each month, sometimes we miss it, so I want to set up the filter to read from the formula I want the formula to read from my ( Release Date ), this exiting month and 2 months ahead like give me Feb, March, and April as true, so when I tell the filter to give only what is “true,” it will give me those 3 months, and it will automatically drop one and add another each beginning of a new month. Thanks a lot Ahmed Elagami

Hello, I have a script that is intended to copy a set of predefined task records whenever a new project is created. The problem I am running into is with the multiple-select columns. The documentation says that I should be able to write to a multi-select column using the selection ids, but I always get this vague error when testing despite having no syntax/linting errors: “ERROR Error: Field “Phase” cannot accept the provided value. at on line 30 at main on line 15” Here is my script, plus a picture of the error: // get respective project const inputConfig = input.config(); const project = {id:inputConfig.project}; // get tables const sourceTable = base.getTable("Source"); const destTable = base.getTable("Dest"); // get all template tasks let query = await sourceTable.selectRecordsAsync(); // for making dynamic functionality later // TODO: make dynamic functionality later let cols = sourceTable.fields; let getColName = (c) => { return c.name; }; let colNames = cols.map(getColName);

I want to create an airtable column that will say Yes if two other columns are identical, say No of those other columns are not identical, and say N/A if one of the columns is empty. Is there a way to do this? For example: Column A says Cow Column B says Cow So conditionally formatted Column C says Yes Column A says Cow Column B says Duck So conditionally formatted Column C says No Column A says A Column B is blank So conditionally formatted Column C says N/A I’ll take any solution, doesn’t have to be conditional formatting. Thanks ahead!

I’m new to Airtable, but have extensive experience in SQL databases. I could do something like the following in Access, but I want to make this database cloud native. Any assistance would be appreciated. I’m working with a consulting firm that has ~50 consultants who relate to one or more legal affiliates of the firm through independent contractor agreements (ICA). Each ICA formally connects one of our legal affiliates with an “external entity” (an LLC, a sole proprietorship, etc.) to which a consultant belongs. Each consultant may have one or more external entities that they are themselves connected to. I have built my base like this: I want to be able to create a Consultant view (ideally a card/grid-view) that would show me the consultant’s information and a list of all the agreements that are related to him/her through the external entity table. However, I can only figure out how to display data that is from the directly related table “Consultant/Entity Relationships”.

I have a base that I’m using to track projects, which have a start date and an end date. Sometimes those projects get modified for a variety of reasons with one of those reasons sometimes being that the end date gets extended. We track all modifications in a separate modifications table that gets linked to the original project. We want to be able to dynamically display the new project end date by referencing all mods and returning the latest date. To do that, I have set up a Rollup Field linked to the Modifications table that returns the maximum value: MAX(values) But if there are no modifications, that Rollup Field will be empty, which won’t work. So, after reading the forums, I created a formula field date with the following logic: IF({Rollup Project End Date}>{End Date}, {Rollup Project End Date},{End Date}) It appears to work at first, but upon closer inspection, the date getting returned in that formula field is one day earlier than it should be. I need it to be exact bec

Hi, I am reading a date from a field and want to include it in an email (as part of an automation). How do I go about converting the date that looks like this “2021-02-10t11:30:00.000z” into something like this - 10/02/2021 11:30am (or similar)? Thanks!

Hi guys, We have multiple servers with remote desktop access, and we’re using them on a daily basis. The current solution is a sheet with the server IP, username, and password. As you can imagine, it makes it very difficult and inefficient to search the relevant server, insert its address and credentials, and log in. In order to solve this problem, I’ve started to read and look for a solution. The first and easy-to-implement solution I’ve found is to create an “RDP” (Remote Desktop Protocol) file, with the relevant credentials - and connect directly to the server without the need of adding credentials each time. Still, from what I’ve seen - you can’t create a hyperlink to this file, either locally or on the web. So, I’m looking for a creative way to add a column to my table with a direct link to each server. The ideal is that a user clicks on the link, and the session opens and logs in automatically, but we’ll be more than satisfied also with a simple link to open the login page and th

Hello! Hoping I could get some advice on a formula field that accepts my formula but the cells won’t return any data (not even an #error message). Maybe it’s a bug…? Since I’m dealing with multiple formula fields, lookups and a Rollup result that is being fed back to the original table, I’m thinking it’s an issue with Airtable recognizing the data…Any workarounds or syntax advice? Problem formula is in table 2: IF({Legal Wraps After}=‘Episode’, {Episode Legal Wrap Date}, IF({Legal Wraps After}=“Season”, {Season Legal Wrap Date}, BLANK())) Table 1: SEASONS {Legal Wraps After} - Single Select Field (episode / season) {Last Shoot Date} - Rollup Field (MAX {Shoot Date} of all Episodes in a Season) Table 2: EPISODES {Shoot Date} - Date Field {Episode Legal Wrap Date} - Formula Field: ({Shoot Date} + 7 days) {Season Legal Wrap Date} -Lookup Field: (Lookup the {Last Shoot Date} Rollup Field) Any help here would be much appreciated! Thanks!

Hi! I’m trying to create a formula that would display a “week of” for a given date where Monday is the start date of the week. The below is the formula I came across on Airtable’s blog - it works great except it displays the start of the week’s date beginning with Sunday. My formula expertise is very limited so there might be a very simple solution to this - I just can’t seem to find one. Any help would be greatly appreciated! CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Date},-DATETIME_FORMAT({Date},‘e’),‘days’),‘M/D’))

I’m currently using the following formula for tracking Project Health: IF({FOC (Current)}<TODAY(),“LATE!”,“ON TARGET”) however there are times when the “FOC (Current)” date field is appropriately blank. Right now it’s labeling it as “Late” but I need it to show “No FOC” instead. If FOC (Current) is < today = “LATE” If FOC (Current) is =/> today = “On Target” If FOC (Current) is blank = “No FOC” I can’t seem to make the multi-IF’s to work. Thanks in advance!

Is there a way to rename a step in automation or to give it a pseudonym? This would be very handy for future editing. You could see what each block does, or is supposed to do and save you time from opening it and looking into what it does. It can still hold its original name, but can it have a label or something, saying finds record from such and such or calculates the average… Cheers

Hi. I’ve combined two tables into one but when I sort by any of the single text it sorts into two A-Z lists one after the other. This happens when I sort cells with numbers or with letters. I’ve checked and can’t see any leading spaces in either list (although may be checking for these wrong - I’ve been clicking into a cell and scrolling to the start to make sure the first character is a letter and not a space). Any other thoughts?

Hi, just started out on here so please excuse if this is an old topic! I would like to see the autonumber on a form so that when an operative places an order from the form template he is able to provide the supplier with the number. Is this possible or is there another way around this? Many thanks

What I am trying to do is use 2 nested if statements to check if 2 variables are blank (A and B). If A isn’t blank it will post A, but if A is blank it will then check to see if if B is blank and if B isn’t blank it will post B. But if B is blank as well it will post the safety string C. I thought below would work but its not working. A and B are cells and C is a string that I have as a safety net. IF({A} =BLANK(),IF({B}=BLANK(),“C”,B),A) Any help would be great thanks!

Hello, Currently I have a Pro Plan with only 1 billable collaborator and I need to transfer the ownership to another user. But my concern is to follow these FAQ instructions (How can I transfer ownership of a base or workspace to another user? – Airtable Support) and being charged for adding a new billable collaborator. Is there a way of replacing the owner without being charged for a second one, since I have to add the new owner before I remove the other?

Hey there, I have a question: When I open a record through clicking on it in a linked record field, what determines the order and visibility of fields that I see on the record? I often see fields that aren’t helpful for me, and I wonder: what do I have to do to make sure that certain fields are visible and appear at the top of the record? Thank you!

Hello Airtable community ! :grinning: I am once again asking for your advice. My problem is that want to remove a month on my date formula which is : UPPER((DATETIME_FORMAT({Date}), “MMMM”)) So my result looks like this “FEBRUARY” but i want my result to be -1 month so if the date is FEBRUARY, i want it to be JANUARY. I don’t know how to do that can somebody help me ? :thinking:

I am currently working on setting up a time sheet on one of my bases. I am having an issue with a formula to ID my entries. I am trying to Concatenate the date, name of person, and total worked time all in one. I have the date and name figured out but I can’t get the total worked time to format in anything but seconds. CONCATENATE(DATETIME_FORMAT({Start Time},‘l’), " - ", Who, " - ",{Total Hrs}) {Total Hrs} is currently this formula, DATETIME_DIFF({End Time},{Start Time}), which is fine because I can change the field to be a duration. I have explored the community but haven’t been able to find a solution. Thanks in advance for your help!

Hello, here is my formula below IF(DATETIME_DIFF(TODAY(), {Course Joining Date}, ‘months’) > {Course Payment Duration}, ‘Payment Complete’, ‘’) What I need is to ignore the course payment duration field if it is blank, at the minute this is still getting marked as payment complete. Thanks in advance Chris

Hi! Very new to formulas and slogging my way through thanks to all the great advice in this forum! I’m trying to get the formula to return nothing if {days b/w successions} is blank, and to calculate the next date if there is a number in that field. I wrote this, based off what I gleaned from other posts, but it isn’t working. IF({Days b/w successions}=BLANK()," ", DATEADD({Field Date 1},{Days b/w successions}, ‘days’)

Hi there, I’m trying to debug an issue with the Airtable automation, but don’t know how to re-test the trigger as the instructions indicate (see image below). Apparently Airtable cannot email non-collaborators on my current billing plan, but the email recipient is the owner of the base, so I guess it’s a level up of a collaborator. What’s could be wrong with this automation? I’ve tested with other email records and it worked perfectly. Can anybody help? Thanks :slightly_smiling_face:

Hi Community! I’m working on a table that allows my company to easily track and time rental property application processing times. Fields I have are listed below: Unrelated fields are hidden. We want {Hand Over Timer} to start timing once a record gets updated to “Processing”. We don’t want to track time over weekends. For this, we decided to implement the help of the WORKDAY_DIFF() function. The problem is, this works horribly when time is involved. I’ve had to create this monstrosity to make it accurate: IF({Processing Activated (Automation Requirement)}, IF( {Application Tagged As Handed Over}, IF( (WORKDAY_DIFF({Application Started Processing}, DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'Australia/Brisbane'), 'M/D/YYYY h:mm') ) >= 1), (((WORKDAY_DIFF( {Application Started Processing}, DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'Australia/Brisbane'), 'M/D/YYYY h:mm') ) * 24) * 3600)) - 172800, (((WORKDAY_DIFF( {Application Started Processing}, DATETIME_FORMAT(

I’m building a custom app and need to show an attachment’s thumbnail image as part of an info card. When I enter <div>{record.getCellValue("Attachment field")}</div> to view the cell values, I get the following error: Error: Objects are not valid as a React child (found: object with keys {linkedRecordId, value}). If you meant to render a collection of children, use an array instead. I’ve tried adding record.getCellValue("Attachment field").fields.url but it comes up as undefined. I’ve also tried {record.map(value => {value.url})} to try access the object’s properties but map is not a function of record. How can I access the thumbnail’s URL?