Solved

How do I get my projects (which is a primary field), to be linked to my tasks records? For some reason when I link two tables, they do not appear on the table to be linked. Here is the project tab, with the projects being the primary field Here is the Tasks field where the project field should be linked to I add the linked “tasks” field from the Tasks table And the linked field from the Projects table does not show up in the Tasks Table

I have a a base that has a set IDs (600+ unique IDs). I need to update their status’s weekly but the report to update has over 9000+ IDs. I only want to update my 600 without adding any other records to it. Is that possible with the CSV import extension?

I’m hoping someone can help me with a simple formula. I currently have a formula that counts the months between a start date and today’s date and displays it in months as whole numbers (ie, 2 months, 5 months, etc). The issue with just a whole number for months is that at 3 months and 29 days, it will show “3 months”, and at 3 months and 1 day, it will also show as “3 months”. A more accurate figure would be helpful. I also need the figure displayed in months, so the display in just weeks (ie, 9 weeks) or just days (ie, 52 days) wouldn’t be helpful in this case. I’m hoping there is a way to make it display in months with one decimal place (ie, 2.3 months, 5.7 months). I’d also settle for something similar such as “2 months 14 days” or even “3 months / 2 weeks”. I’ve tried using the formatting function within the settings and set it to “decimal” with a precision of “1.0” but it still just shows it as the whole number for the month with a “.0” at the end. For example, 3 months and 2 week

When I try deleting a record, it says “Unable to delete record. This table is configured so nobody can delete records”. Might it be something an administrator set? I duplicated the base and its still not allowing me to delete. Any suggestions?

Hey clever people, I got following single line txt fields in my table: {Prefix}, {First Name}, {Last Name}, {Suffix}. I already use a formula to concenate this data: CONCATENATE({Prefix}," “,{First Name},” “,{Last Name},” ",{Suffix}) … this works fine. My problem/question, is it possible to make a formula that will put between {Last Name} and {Suffix} a comma if {Suffix} is not empty/null, instead of the space like above. If I replace the space with a comma it will obviously be everywhere, what I don´t want. For example: Prefix (Dr.), First Name (John), Last Name (Miller), Suffix (M.Sc.) - Formula Result: Dr. John Miller, MSc. Prefix (Dr.), First Name (Leroy), Last Name (Thompson), Suffix (null) - Formula Result: Dr. Leroy Thompson I hope you understand what I mean :grinning_face_with_big_eyes:

Hi, we have a new collaborator that can’t add or edit any airtabels in the workspace. He has creator and editor permissions. Very frustrating, how do we fix it? We’ve tried logging in and out, as well as adding and removing him as a creator. Thank you!

I have set up a simple automation where the trigger is an email being put into a particular folder on my Outlook email system. This then triggers the creation of a task, taking some of the information from the email. It runs perfectly when you test it, so I then made it live and put 5 emails into this folder. Only 2 have come across as tasks - I simply can not work out why the others haven’t (I left it overnight, so assuming it isn’t a timing issue). Any help / pointers on this would be much appreciated.

I have a form with a cover image and logo. Up until today the images displayed properly, however now they appear as broken image. Additionally I have a small table with a few images in it and they are now also appearing as broken images. Is anyone else experiencing the same issue? I see some older posts where this was resolved but it seems to be happening again, at least to me. Re-uploading images has not helped either, it just ends up with the same result.

Hi, I want to create a formula field that will add a “$” to those number that doesn’t have that. I tried using different codes but I still haven’t achieved it, can you help me? Thank you!

Hi. I need to have a calendar overview showing two fields - a delivery date field and a publishing date field. What i am trying to figure out is, how am i able to delete the delivery date field entry, so whenever the date is the exact date of delivery i am trying to delete the delivery date field entry, so in my calendar the delivery date is not shown anymore - but the publishing date is still visible. Thanks in advance Martin

Hi everyone ! I am so sorry if my question has already been answered on this forum but I just spent my entire day trying to find a solution… I need to add some wordpress featured images on my Airtable database. To do so, I choose the Attachment field type and tried to add the url. Airtable is doing a great job downloading files, but it takes a kind of screenshot of the website whereas I only need the featured image (just a .png or .jpg file !). For example, if I take this url (https://lexpedia.fr/droit-administratif/arret-blanco-8-fevrier-1873/) and insert it in the Attachment type field, I will need to get the little girl image on a .png format. Don’t hesitate to tell me if I’m not clear ! Thanks by advance !

Hi! I have a slight problem that I don’t know how to solve: I’m working on some lists that need to be divided into different records. In this particular case, the lists that I was given contain the field “name” or “full name” but I need to divide that information into “name”, “middle name”, and “last name”. So, for example, if I have in one record the name “Amanda N. Pollard”, I need to divide that into Given name: Amanda Middle name: N. Last name: Pollard The extra complexity comes when not all people within the Company have middle names or when some employees have more than 1 last name. For example: “Jay Martínez Romero” which in this case would look like: Given name: Jay Last names: Martínez Romero Has anybody done this before? Thanks in advance!

Hi, I amm having a strange issue with MID(X,1,5) returning more than 5 characters and LEFT(XX,10) returning more than 10 :slightly_smiling_face: Is this a known issue ? Any clue to make it work ? See attached screens Valérian LEBERT digi-studio digi-studio Digitalisez votre entreprise avec digi-studio

I have 2 date fields and would like to calculate the midpoint between the two (as a date). I have tried a few the NGS bit not had any success. Any ideas?

Hello world I’m working on a budget base which requires a linked field to pull in cost data. It currently means manually searching for a linked record 20 times for each choir rehearsal (there are 10 venue costs, and 10 staff costs per choir)… And we have 19 different choirs to do this for (almost 400 manual ‘clicks’). I’m either being stupid and missing something obvious, OR it requires some form of scripting (in which I am clueless) or automation to make this happen automatically. Could anyone shed some light? Here’s a short video showing what I currently have to do. And here’s a link to an abbreviated version of the base. Any help would be hugely appreciated! Many thanks Curtis

Hello I use Integromate to use airtable data to send emails. When a form is filled, Make sends emails to the matching records from airtable. I use the following formula: {Vendor Country}=“Vendor country” If the form filler is also in my records. Make sends emails to the form filler. How can I exclude the form filler email from the emails to be sent?

I’m coding AT SDK extensions using Visual Studio Code, and most likely I’m missing something but I can’t output to console with console.log() function. There is no output on VSC terminal, debug console or output. I’ve tried running in debug mode, nothing changes. There is also a button “Log component to console” - a small bug icon - on the app editor interface, but clicking it seems to change nothing Thanks ahead for help!

Hello Airtable community! I founded an all-volunteer project to help street cats on the island of Vis, in Croatia, and design a calendar every year to raise money for the project. Last year was my first year dealing with calendar orders via Airtable, and I thought I had a clever set-up where people could fill out a form to order. It DID work for that one year, but I don’t think I designed the base correctly, because it’s not sustainable year-to-year. The base is called CALENDARS+ (in case we start to sell any other fundraising items in the future) and all the data I collected lives in a table called 2022 calendar. Each name entered via the form becomes a record, with the person’s preferred language, email address, postal address and the number of calendars they want. If I do this again for the 2023 calendar, there will be lots of duplicate records, so it’s obviously wrong. I need the people’s data to live in one place so that in following years when they come back to buy another calend

Im attempting to make an app that will allow the user to select a value from a dropdown, and then the table will filter the records for that value. I’ve gotten the dropdown working, however for whatever reason the last return has an error and will not work. The problem function is the one that will update the records. How can I resolve this return error?

Hello! I have an issue with a SUBSTITUTE formula I am using. I started with the following formula: SUBSTITUTE( SUBSTITUTE( {Email Body} & "", "{Appraisal Contingency Date}",{Appraisal Contingency Date} & ""), "{Conditional Approval Due Date}",{Conditional Approval Due Date} & "") It returns the following: Appraisal Contingency Expires: 2022-09-20T00:00:00.000Z Conditional Loan Approval Due: 2022-09-02T00:00:00.000Z Since the dates were not formatted properly, I updated the formula to the following: SUBSTITUTE( SUBSTITUTE( {Email Body} & "", "{Appraisal Contingency Date}",DATETIME_FORMAT({Appraisal Contingency Date},"ddd, MM/DD/YY") & ""), "{Conditional Approval Due Date}",DATETIME_FORMAT({Conditional Approval Due Date},"ddd, MM/DD/YY") & "") It returns the following: Appraisal Contingency Expires: Tue, 09/20/22 Conditional Loan Approval Due: Fri, 09/02/22 All seemed well, BUT, when there is a record that does

I’m getting an invalid hook call error, but I’m unsure as to why. My extension is intending to list all the values in a specific field in a dropdown to then select one to filter buy Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: You might have mismatching versions of React and the renderer (such as React DOM) You might be breaking the Rules of Hooks You might have more than one copy of React in the same app See https://fb.me/react-invalid-hook-call for tips about how to debug and fix this problem. at resolveDispatcher (https://localhost:9000/__runFrame/bundle.js:79388:13) at Object.useContext (https://localhost:9000/__runFrame/bundle.js:79396:20) at useSdk (https://localhost:9000/__runFrame/bundle.js:25061:19) at useBase (https://localhost:9000/__runFrame/bundle.js:32768:41) at ./frontend/filter.tsx (https://localhost:9000/__runFrame/bundle.js:34:74) at webpack_require (https://localho

Currently experience a bug? I think… I’m trying to sort by A-Z on column 1, then sort by selected radio check marks? Just me…?

I am trying to addd an automation that does the following: When a Multiple Select Field has a specific value entered, it then creates a record in a second table with some of the fields from the first table. That part is easy. The problem is that I want it to place today’s date into a field in the receiving table. I cannot see how to tell it to simply place today’s date in that field when creating the record. Thanks!

Hello. This seems like it should be an easy solve but I cannot for the life of me figure it out. I have a table in a base that automatically receives responses from a Typeform survey. It puts the email address (manually entered by person taking the survey) as the main record, and the responses follow in different columns. There is another table in this base where the main record is an employee name, and then we have Department, and 3 columns of 3 different email addresses (there are potentially 3 different ones for each employee, or 2 or 3 can be the same). I have linked the email base to the response base, and as the responses come in, I use a lookup to select the employee and pull in their department. I am trying to get this part to happen automatically. So, when an entry comes in, if that email address matches any of the three emails in the other table, it will bring that employee name in. Hopefully this makes sense and someone has a solution… Thanks!

What is the difference between “one month ago” vs “one month from now”?