Solved

Hi, what formula can I use to show many days remain for a task? For example, if there are 4 days remaining before the Due Date, I’d like that cell to read “4” I tried using a formula from another table but it didn’t work. The existing formula was: IF({Name (from Due Date)}, DATETIME_DIFF({Name (from Due Date)}, TODAY(), ‘days’)) My new formula is: IF({Follow Up Date}), DATETIME_DIFF({Follow Up Date}), TODAY(), ‘days’)) - but this one doesn’t seem to function correctly. Any help is greatly appreciated. Thanks! Christopher

Hello, I’m new to Airtable, so forvige me if this has already been asked or if it is not in the right category. In my database, I have cells that contain both text and one or more hyperlinks I want to extract the URL from those cells and put them in a new column and I have no idea how to do so. I would love to get some help on this please, thanks !

I’m trying to create a table using this code: I keep getting this error: Bundle Error: Cannot find module '@airtable/blocks/dist/types/src/types/field' from 'C:\dev\my_app\build\development\transpiled\user\frontend' As you can see…the type is found and no typescript errors are indicated on the line where it is used. Wondering if this is a bug or some issue that needs a work-around. I know this functionality is beta right now.

I want to combine a linked field containing a job title with each item in a multiple select field, which contains different statuses and sub-statuses in the application process. Ultimately, I need to be able to keep track of each status that a candidate has ever been in. I’m using the simple formula below: {Job Title} & "_" & Status But it seems like Airtable treats the different items in the multiple select field as an array. The formula produces the job title followed by a string of each of the statuses separated by a comma. I’d like for it to produce the different combinations - Job F_1.a, Job F_2.a. Does anyone know how to do this?

hi , everyone here’s quick question , can I setting a reply limit of linked record field on form view , linked record field are allow to selected more than one option now but I hope it can change into single select (maximum one option select) (not single select field , still Linked record field but only can fill one answer by user) is that possible ? because not native speaker and I’m worried about that I didn’t explain my situation clearly so please see the screen shot as below : thanks a lots !!! :grinning_face_with_smiling_eyes:

3 lookup fields “30 Min Call”, “Proposal Sent” and “Contract Signed” 1 result field “Status”, Formula needed IF “30 Min Call” has a date, enter “Prospect” in “Status” BUT IF “Proposal Sent” has a date, enter “Onboarding” in “Status” BUT IF “Contract Signed” has a date, enter “Client” in “Status” IF all three fields are EMPTY, leave “Status” blank Likely scenario would be when “Status” shows “Client” then all 3 lookup fields have dates (but is not a requirement). I’m pretty sure I am missing one simple thing but I have tried all kinds of strings and tried comparing in the help functions but still getting error results. Thanks for the help.

Happy to do the following in both Airtable and Excel (and involving as many steps as necessary). I have two separate tables with a similar multiselect column in each, involving many values or “tags” as I call them: Table 1: Table 2: I want to add an additional column in Table 1 titled “Tags”. I’m trying to populate this column. If Table 2’s Product Tags can all be found in Table 1’s Product Tags (not an exact match, but rather if Table 1’s column contains the content from Table 2), then I would like to return the name of the brand (column A) from Table 2. Please help!!

I have destination table set up to sync all new fields created in source table but it is not happening. Has anyone else had this issue?

Hi there – not new to Airtable, but new to scripting. I’d like to add a new row to a table (table:“Daily”) and set the primary field (column:“Date”) with tomorrow’s date, and run it every day. Simple, right? I suspect the best way to do this is set up a scheduled automation to, say, run each day at 7am, that creates a new row with tomorrow’s date. This would require declaring today’s date and tomorrow’s date in the correct format, either in the script or as an input config. I’ve poured through the documentation and these boards to find a simple way to do this, but am coming up short and appealing for the first time to the pros here for a little assistance. I’ve also tried to set this up as a simpler scheduled automation using the “Create record” action, but you can’t use a formula to declare the field value, either in the automation or as a computed field (e.g. declaring “Tomorrow” as a computed field in the row) Any advice on how to go about this seemingly simple task? Advanced apprec

Hi! I created an automation that, once a Single Select cell is updated, it will tag a Collaborator in another cell. However, I have to create one automation for each record. Is that right? Is there an easier way to do that? Thanks in advance!

Is it possible to fetch all records from the entire base without needing to pick a single table? I’m creating a To-Do list app that’s pretty much like the example provided by Airtable. We have multiple tables organized by “Offices” like for example “Development”, “Design”, “Marketing” and so on. Each record is a Task. Our goal is to simply display all Records in the App that are not marked as Completed so our manager can easily go through those tasks in one place. The useRecords method requires a Table to be passed as an argument so I thought of maybe looping through all tables and then fetching those records but then I figured that this would make the app not reactive… So… Is this possible? If not, do you have any suggestions of how I could accomplish this? We sure don’t want our manager to have to select which table he’ll be working on since that’s irrelevant to him… Thanks for your help!

Hello ! I am trying to calculate my margins on my projects. All my costs appear in the “Costs” box. I would like to add up all these costs in the next cell “total costs”. Which dormule should I write? Then what formula should I write to subtract “TTC cell” - “Total Cost”? Thank you very much for your help, very much appreciated :slightly_smiling_face:

I have Table 1 with thousands of records. In Table 2, I want to summarize the data by linking the records and then using lookup fields to get specific info from each record all in a single cell. I’ve linked Table 1 to a field in Table 2, but to get all the records, I’d need to manually select each of the thousands of records to add them to the linked cell. Is there an easier way to do this? I made a dummy database and screen recording to illustrate what I’m trying to do, but instead of 4 records per “company,” imagine thousands. Thanks for any help.

When I first set up my base, I established one field, mistakenly, as single line text instead of a number. I recognized it with 100+ records in, and have lived with it ever since. Now I want to change the field type for this field from single line text to number, without losing the entries. I could probably sort the records by that field and add a new field as I want it, then add in all the new field entries, and last delete the old ones. Is there a faster or base-wide way to accomplish this? Many thanks.

Hi! I need assistance if possible! I have a table where I’m tracking information about a wave of people (table 1). I have another table where I have the names and individual information for those people. (table 2) I have a linked field connecting the names from table 2, to the wave on table 1. Part of the information on table 2 is a formula that rolls up from another table with possibilities of 0-51. I have a look up field bringing the numbers for each person into table 1 separated by commas and I can use Average() to get an average. BUT if there is no one linked, there are no numbers to average and it returns NaN. I would like it to either return 0 or stay blank. I have read previous articles but they mostly seem to focus on dates and I am using integers.

The view is shown as “Shared”. Every time I try to add a filter, I get warned that synced tables/bases will be affected. I want to find all the synced tables so I can change them to a different view that is specifically built for sharing. How do I find all the places a shared view is use? (If I rename the view, it gets reflected in all the other bases that sync it, but how do I find them all?)

Hey everyone! I have a database of customer feedback that I’ve compiled and categorized by theme. I’d like to extract the top 5 themes and show them as a bar graph. Additionally, I’d like to have an option to change the week # and the bar graph will adjust the top 5 themes accordingly. Is this possible on Airtable?

Hi Everyone, I’m newbie on Airtable. I want to make my first formula. I want to know the latest date. I try to use Max, but the result is zero… I used this formula : MAX({Starting date (from Activity journal)}) (first colum is Starting date, last colum is used for the formula) Data in “starting” column look OK, since is able to calculate the MinDate in the summary… Any idea ? Thank you!!

Hello Everyone, I am submitting our Content for an award competetion, so submissions fees differ. 1st Submission is : 400 2nd Submission and up are: 210 Each another competition 1st submission is: 400$ 2nd Submission is: 120$ 3rd and up is: 60$ each How can I create a formula read the 1st, 2nd, 3rd, and so on and add the right fees amount through a formula? or a rollup? Some help is needed here Guys, appreciate your time. Thanks, A lot

Hi, I am trying to make a Button that will open a Gmail compose message screen that has the To, CC, BCC, and Subject fields pre-filled. The CC and BCC are static; To and Subject change depending on the record. This one works but doesn’t have the cc field, and I want to add a BCC too… “https://mail.google.com/mail/u/0/?authuser=example@gmail.com&view=cm&to=”&{send to email} &"&su="&({load}&" - confirmation")&"&body="&{load numbers} now trying to add a CC field and it won’t save the formula, get an ‘Invalid Formula’ error “https://mail.google.com/mail/u/0/?authuser=example@gmail.com&view=cm&to=”&{send to email}?cc=traci@example.net&"&su="&({load}&" - confirmation")&"&body="&{load numbers} What am I doing wrong?

Hello! Does anyone know a way that I can use a formula to convert a year to a decade? Forgive me if this is simple, I am new to formulas… Thanks!

Hi Trying to create a formula to show all records before an actual date but not say today, last week etc. Can see how to do if I want today etc but not an actual date Originally, wanted to created formula to show records that fall in my accounts year end so within date range of 1 April 2020 and 31 March 2021 = 20/21. And to use for every year. Going around in circles to find! Can anyone help please?

I run a fleet, and we log trips data with relevant info (date, driver and vehicle#). I’d like a way to count ‘how many days a person/vehicle is active’, in a given date range. Generally, we would know this with the count function. But in this case, we only get the trips count, and not the active days count. Within a given date range, I need a formula to calculate how many days a driver was active (has atleast 1 trip/day). how many days a vehicle was active (has atleast 1 trip/day). Just couldn’t find a solution to this simple requirement, however hard I try to find. Is there a way to do this? Any ideas are welcome. Cheers

I have created this formula that will set the duration when something is selected: SWITCH( {Select}, ‘Code Review’, 1200, ‘Design Review’, 1200, ‘Resume Review’, 1200, ‘Career Coaching’, 1800, ‘Team Coaching - Design’, 3600, ‘Team Coaching - Code’, 3600, 1200 ) It is then connected to another formula field to create and End Time: DATEADD({Time}, {Duration}, ‘seconds’) However, the time I get returned is 5 hours later not the minutes I have added. Anyone have a suggestions.

Hi Everyone, I’m currently working on what feels like it should be a relatively simple formula, but I’m consistently getting a #ERROR! result when I try to implement it. Context is: I have a table that lists students’ work experiences, their start dates and end dates. I want a filtered list of records where either the start date or end date was in the month before the previous month. e.g. if I was looking at it at the end of May, I’d want to see all work experience that started or ended in the month of April. This is the formula I’ve written: IF( OR( AND( {Start Date}>(DATEADD(TODAY(),-60,’days’)), {Start Date}<(DATEADD(TODAY(),-30,’days’)) )=1 , AND( {End Date}>(DATEADD(TODAY(),-60,’days’)), {End Date}<(DATEADD(TODAY(),-30,’days’)) )=1 ) =1,TRUE(),FALSE()) As I said, I’m getting a consistent error message on this formula. Apologies if I’ve missed something incredibly simple, but would anyone be able to cast a fresh pair of eyes over this and point out any mistakes I’ve mad