Ask the Community

Hi,Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my data is clean it is a standard 03/05/2023 7:00:00, 10/05/2023 7:00:00, 17/05/2023 7:00:00, etc As you can see, the three rows show up blank after I try to convert to Date (with time) field.This is the original data after importing from Excel sheet. Would appreciate any advise on how I could convert all data successfully. Thanks!&nbsp

I have a project stage field that I need to convert into generalized phases. I have the below SWITCH formula and I cannot get it to save. All of the articles I have read have examples formatted this way - What is the issue? SWITCH(  {Project Stage},   ’Discovery’, ’In Progress’,   ’Planning’, ’In Progress’,   ’Account Build/Import’, ’In Progress’,   ’Execution/Migration Prepped’, ’In Progress’,   ’Imported’, ’In Progress’,

Hello! I have checked out the the community for an solution to my problem and can't find what I am looking for to help me with my formula and automation. I am trying to set-up an automatic alert announcing someone's birthday on the day of their birthday. It did work but it sent the announcement the day before as well as on the day of the persons birthday.This is my formula: DATETIME_FORMAT({🎂 Birthday}, "MMDD") = DATETIME_FORMAT(TODAY(), "MMDD") My automation is set up for when a record updates, it sends an email on the day of the persons birthday. However, it sent an email the day before and the day of.I onl

Hi there, I am trying to create an If/or formula and got it to work but I can't get the formula to be blank if there's no data in a field. I'm sure that makes no sense. Here's an example: Let's say I have a small list of produce in a column. I want to create a formula in a new column to give me the category of produce either as a fruit or as a vegetable. I got the formula to work but if no produce has been selected I'm still seeing "Vegetable" in the formula column and I want it to return a blank value. Any ideas? Here's the example formula. Thanks in advance!IF(OR({Produce}="Grape",{Produce}="Apple"),"Fruit","Vegetable") 

In the Airtable interface it came to my attention today that Read Only users can see all other users who have access to the same interface. I simply assumed they couldn't share or see this information.Does anyone know how I disable sharing for read only users, or the ability to see who it is shared with?This is totally work stopping for me on my current project. In fact this is preventing me from wanting to use Airtable interfaces for any public facing work, even for people who have paid Airtable accounts. 

How to remove the v5.airtableusercontent.com when automating posting on Facebook using Make from Airtable

I have set up a flow in Make.com with a webook-airtable-strip-airtable to create and send invoices from stipe using the data in Airtable.It all works apart from when creating the invoice in stripe it creates an invoice for £0.00. It looses all the pricing info. And yet I can track it through the input/output.Anyone help??I will happily post all the input/output data!  

I made an automation to create reminders in my Google Cal. They’re all-day events, which by default don’t show you as busy, but when they’re made through Airtable they’re ticked to show as busy. I couldn’t find a field to change this in my automation. Can I make it so my all-day events made from automation don’t show as busy?

I'm developing an automation with Make that should extract specific values (Email, Città and CAP) from an email body.  The values should be saved into airtable fields.Make returns the following error message when tries to save the extracted CAP value into the airtable field "Indirizzo_Immobile_CAP". The field "Indirizzo_Immobile_CAP" is linked to another table.I've contacted Make support and they told me what follow: "Upon inspecting the log, it looks like the field called "Indirizzo_Immobile_CAP" is the one causing this issue showing

Hello everyone, I am having an issue with my images. I uploaded all my images with a webp format to minimize size. I have an example where I am uploading an image that is 63kb but it is being returned as 467kb. Yes, 467kb that is insane. What can i do about this? If I can't find a way to fix this I might as well get rid of this api because that is completely unacceptable.

Hi new here, hopefully this wasn't asked before. Please link me to it if it was.Let's say I am managing a fruit plantation. Each fruit needs to be planted and harvested.I have already a table like so, where the Fruit field is linked to another table (eg. Basic info about the fruit: colour, size, etc)FruitPlanting dateHarvesting dateApple1 Jan2 FebOrange15 Jan1 FebIs it possible to create a table (or a view?) that somehow links to the previous two tables? I saw some previous post on how to make a static tabl

I have read a ton of guides and I cannot figure this out! I'm trying to add a button to an email automation that links to an external URL.I created a Button form field (with URL) to table data and added it to the email automation. But when I generate a preview, the button isn't there it's just the label! (See screenshots)What am I doing wrong? (Please and THANK YOU)

I have a large multi-select that I then need to turn into a list format. I did the usual substitute the comma for a line break but unfortunately the items in this multi-select (that I can not edit) also use commas so now it's adding commas where I don't want them. Is there a way to get the formula to avoid those commas but not the others?  SUBSTITUTE({Plot Themes},", ","\n")

Please see screenshot below. I have domain names in one field and want a clickable "click here" text in another field that hyperlinks to the domain name, how can I do this? Thank you 

Hi all!I've been scratching my head and couldn't solve the problem quickly, so I'm asking for your help.I need to display a progress bar with the percentage of completion of a specific task, under which there are subtasks. In order to understand the percentage of task completion, we take the subtask as the source. If out of 10 subtasks only one is completed, then we get 10% of the main task completed, a certain run rate.It looks like a similar task can be implemented through a formula, but I was unable to write a correct formula using if, counting and division.How can this case be solved?

Hi I am combining 2 fields (quantity and materials description) using the formula function (screenshot 1). I am then using the lookup field to display in one cell all the materials and quantities for one job in that one cell (screenshot 2). So far so good. I would like to be able to do a nice print out for the workshop staff but in order for it to look less cluttered, is there any way I could program it to display each (material & qty) to be displayed on a new line (new paragraph) within one cell? e.g. rather than 2 x 22mm MDF, 4 x 18 mm Birch plywood, 6 x inset hinges I would prefer it to look like this: 2 x 22mm MDF, 4 x 18 mm Birch plywood, 6 x inset hinges Any ideas gratefully received!

I'm running into race conditions some report summaries automations, and am wondering if anyone has come up with a better solution than I have in placeI have a table that is automatically updated when a user adds values from a csv report. I need to summarize that report with an automation. I have a multi-step automation that does the followingTriggers when a record enters a viewChecks to see if the date of the report is already listed in my summary table with a "Find Records" stepIf "Find Records" length is 0, it runs a few scripts to do math on the raw data enteredHowever, I've found that the automation runs for all records in the view simultaneously, rather than one at a time, so I'm running into race conditions where multiple lines are created for the same report. I know there are other solutions such as running the automation from a button click or at a scheduled time, but those are not options for me at this point. Any advice?

Is there a way to share a script between a record-create automation and a record-update automation?

Is it possible when selecting "Link to another record" to be able to connect to multiple tables? I can only see the option to link to one table (multiple records, yes, but multiple tables, no)? Or any workarounds for this?I'm building out a content model and for some of the content types, the source content fields can come from multiple other locations, so I need to be able to reference this in my data model. Thanks!

Hi, I am trying to create a sprint base / interface. The base is most likely already done, but I am facing issues with the interface, since I can set up only 3 hierarchy level.My Goal is to have an interface as a list with following "grouping" or nestingSprint - <DATE>Category (e.g. Webinars, Product Launch, Marketing Events)Project (e.g. <Product Name> Webinar)Tasks (e.g. Create Webinar Slides)Every level shown above is a separate table in my base and they are linked to each other.I tried several ways to solve this, e.g. with Grouping, but grouping is always on the lowest hierarchy level (Tasks), but I would need it for the Projects. Then I could group by Category and my problem would be solved. Another way would be to have no Projects, but instead nested Tasks (only 2 levels required then (Sprint + Tasks). However, th

Hi- are there any updates about this topic?We want to share only some tabs with different people. Thanks

I have two tables in a base named Appointments and Revenue. I use Zapier to send appointments and transactions from my CRM to Airtable. The appointment records include a Technician Name. The revenue transactions do not and cannot include a Technician Name. They both, however contain a Job # field.I'd like to create an automation that is triggered when a new revenue record is created. It would look into the appointment table to find the Job # that corresponds to the Job # in the revenue record and returns the Technician Name from the appointment record and populates a Technician Name field in the revenue record.Can anyone tell me how to do this (assuming it is possible)? Thanks!

Does anybody know how to actually get a response from airtable support? I submitted a ticket 10 days ago and got an automated reply saying typical response times are 1-2 business days. I've since followed up and still not heard anything,Is support usually this poor?On the off chance anybody from airtable reads this, my reference number is 00714333

How to edit cells within AIRTABLE as I have seen it detects values inside a cell like Listbox but not possible to edit like Excel cell F2.

I have two tables:A. MeetingsB. Representatives'Representative' on table A (Meetings) is a 'Link to another record' leading to the items on table B (Representatives).I have a need to filter the Representatives table so that it'll show stats for a given period only, for example - show only the stats for these periods:The closest I got was filtering each calculation field separately:  But this is not good enough as1. It needs to be applied to each calculation field manually2. The filter cannot