Ask the Community

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

Hi everyone!I use airtable to manage my business, a monthly subscription for football shirts, developed on woocommerce.After each order from my customers, an entry is created describing the order in question (customer size, address and all the information needed to prepare the order).The problem is that a customer who has a subscription for the year creates 12 independent entries for me, so I don't have the possibility of noting useful information and they remain on the customer in question, airtable and woocommerce don't consider the occurrence with this same customer.Ideally, I'd like Mr Smith, who has a subscription for the year, to have a "file" that updates automatically thanks to the occurrence of the surname + first name + address so that I can note down all the particular requests or wishes of my customers month after month, with feedback on each of his requests.Sorry for my horrible aglais, like a good Frenchman I use translation software

Hello, I have a whole column of data with html links and I need these to be clickable links with the respective titles: DATA: <a href=https://www.coronavirus.tas.gov.au/media-releases/important-coronavirus-test-information>Tasmanian Government: Important coronavirus test information</a> Needs to be Tasmanian Government: Important coronavirus test informationHow can I achieve this via airtable? There are so many, relinking them all by hand is going to be tedious. ThanksI will ultimately be exporting this to excel.

I want to create an Project Management Table with the following requirementsI have several project stageseach stage has a start date and an end date (automatically calculated based on duration for each project.)the start date of one stage should be dependent on the end date of the previous task. So if "task A" ends on July 5th, the start date of task B should be the 6th. The end date of task B should be start date of task B + duration,... and so onso whenever something changes, the following dates should change as well. (also reflecting the dedicated duration set for each task)I tried with formulas or dependencies but could not figure out a way to automate this, instead of updating all records manually if one date changes.ThanksHelenelene 

i am new to airtable i want to connect database of airtabe with my project of laravel. i need to operation on that like we do in laravel with models with local databse. Is this feasible and or tell me the other easy way to connect it and do operations on it

Hi,I currently have an Airtable base connected to Softr that has 198,322 / 250,000 records. When one of my stakeholders are currently endorsing in Softr, they receive this message (see screenshot).I would like to know the root cause and a possible solution to this please.Thanks

I'm trying to follow this guide, but everytime I reach the "Concatenate step" the link that shows up to me says "The private share link you tried to reach is not available.".That's a copy of the table I'm using to, why it doesn't works and how to fix it?https://airtable.com/appFaino3o1b2cqEG/shrHoTe908izs7JPn

Is there a way to download multiple attachments at once? A group of photos has been uploaded for a project and the designer would like to download all of them at once instead of one at a time. Is this possible?

Is there a way to do a mass download of photos from my airtable? The Bulk Upload worked well, now I need to do the reverse! Thanks, All

Hi there! I am looking to see if it’s possible to download a zip file of all attachments for a particular field. I did look at This Post and it does not seem to cover what I’m looking for. I don’t need to download ALL files attached to the base as the aforementioned thread is describing. I want to be able to zip and download the attachments for one field instead of having to download each one individually. I could have sworn I was able to do this at some point in the past, but can’t seem to repeat it! Any advice would be greatly appreciated. Thank you!

#needhelp! I have a gallery view, in my records there is a field with 20+ attachements (pictures). When I share this view, and I would like people to be able to download the 20+ images from a record all at once. Just by clicking on a button. How can I do that please ? Thanks for you help.