Solved

Hi!I am new to airtable (love it!) and figuring it how to use it for project management.I'm stuck right now and trying to figure out one issue and am looking for advice.I have a "check list" of 25+ items that need to be completed for each build we are working on. How would I build the table to show the same items for build A, B, C, etc... so we can keep track of what is in the pipeline?Thanks!Matt

If I have these values in a formula field, 0_99_123_456_abc_wantedtext1_ppp_876_333_wantedtext2hhh_kol_ggb_hhh_sss_wantedtext3can someone please tell me how to extract the following text into a new field please?wantedtext1wantedtext2wantedtext3Thanks in advance.

Evening! I am trying to create a table with multiple purposes: 1. Share and store meeting notes2. View date for next meeting 3. See who attends each meeting - this is the one I need help with. _______ So I have created this table:Each Record has its own form link. The form currently contains a Single selection option with the names of the users and the name of the meeting. What I need now is to somehow include the date of the meeting so that when my colleagues receives the form, they'll be able to also see the date of the meeting; w/o the date it will be difficult for them to answer yes or no to the invitation. In the shown table, I have created a formula that automatically generates the next meeting date based on a rule (eg. 14 days from now). Can I in any way include that date field into the form? Thanks in advance for your assistance!  

Hi all, so I have this situation in which I would need to use a double IF.- Chechbox Field- Formula field where: IF checkbox is selected > Value1; if not selected > Value2- Then I have a subsequent Single Line Text field in which I need to have another IF in the formula field above where: IF this field is NOT empty > Value1.Attached are a couple of screenshots. I have the first IF formula down already, I can't come up with the other one. In the second screenshot, where "DANIELA" is typed on the last field, the IF formula should bring me back to "OK" (Value1).Hope I made myself clear enough, would be super helpful if anybody could help me!Thanks

Please how do I loop through a data like this and create a records in airtable I got this from an external API and parsed it to json format

Hello I am creating a time to value metric reporting system for our course.Our goal is for our students to complete their first submission within our course in 14 days.  I have created a formula field that calculates the days from the student's enrollment date to the date they submit their first submission within our course. (see below).So my question is; how should I create reporting in the base interface that reports the number/percentage of students who completed their submission within 14 days? 

Hello all my first post and i'll probably be embarrassed if answered but, I have a formula in excel that tells me how many total years and then months and then days since someone has been hired and I'm not quite there with Airtable as I am getting how many total years and then total months and then total days. 

Helle everyone! I am trying to make a table where I'll have an overview of different kind of meetings. Let's take meeting A as an example. This meeting happens every 14 days. When the meeting has happened (the date is yesterday) I would like a new Record to be made automatically with the updated Date (14 days later). The reason that I would like a new Record to be made is that each Record will have a document attached with a resume from the meeting.I've tried different approaches but yet to hit the mark. Can someone help me make this happen? Thanks a lot! 

I'm working on setting up a system in airtable for generating project pricing/quotes. I would like it to have 3 tiers of organization where a project is built out of a grouping of "components" each of which is a grouping of "materials". The reason for wanting components is so that I can reuse these to build quotes faster by piecing together existing components as well as define a labor price for the assembly of a component. I've been able to create the basic structure for this just fine using intermediate line item tables to define the quantity of different materials in a component and quantities of different components in a project quote. I've set up a simple example base here for illustration: https://airtable.com/shrd46DwWkldZpeJvNow here is where I've run into the problem that I haven't been able to come up with a solution for. I would like to be able to create a full list materials that corresponds to a project quote. The difficulty is that some materials may be use

Does anyone know how to simply program an automation that would allow for clients to be assigned to employees based on first letter of last name.So if clients with last names starting with:A - G --> Employee 1H - M --> Employee 2N - S -->  Employee 3T - Z --> Employee 4i figured this might be a combination of a formula field that just isolated the first letter of last name. But i think there should be a quick second step that would maybe group letters in alphabetical divisions easier than just manually input a condition automation for each letter.  

I have a table of products that includes a linked record field to a “tags” table. Each product can have multiple tags. I want to create an automation that auto applies one of the tags, called “New Product”, to the product and auto removes the same tag at a later date but does not remove all the other tags in the field. I was able to get the first part to work wonderfully – I have a field that is the last modified date and I setup an automation to apply the “New Product” tag to the the product if the item enters a view and the last modified date was within the last 30 days. But, I can’t figure out how to remove the tag without also removing every other tag in the field. Any thoughts or threads of wisdom? Thanks, Justin

Hi good people. I'm building a base to track my handstand progress. I'd like the base to go to Pexels (or another free source for images) each morning, grab a picture of someone doing a handstand, and add it to "today's" record. Can anyone head me in the right direction to build this automation? Or have some advice/insight on how to make this happen? Appreciated in advance. 😁

Hi, all. I'm transitioning from Google Sheets and I understand things are different here, so please have patience with me :-). I am basically trying to implement a VLOOKUP functionality.I have the following use case: I have two tables, customers and orders. Their only commonality is the User ID.I am now trying to look up a field in the customer table (name) and display it in the orders table by using Lookup. Each customer has a large number of orders.When linking the two records and creating a lookup field, I can get the name to display on the orders table. But only for that one particular order and only by manually linking a record. My expectation was that Airtable recognizes that each "name" field in the orders table should now be filled the relevant value from the customers table. Like I would do with an arrayformular in Google Sheets. But that's not happening. What am I doing wrong?

Hi!I have a single select field with two campaign options: Paid Media and Email Nurture. I am trying to create a name field that would concatenate different values, depending on the selected option. I wrote the following line, which is not accepted.IF({Campaign Type} = "Paid Media", "CONCATENATE{Campaign Tactics}, " — ", {Asset}, " — ", {Webpage}", IF({Campaign Type} = "Email Nurture", "CONCATENATE{Campaign Tactics}, " — ", {Steps}, " — ", {Persona}"))Would appreciate any suggestions on how to write this correctly and make it work. Thank you!

Hi guys,We have a field that lists the publish date + time for a piece of web content. We want to be able to organise all of these dates into 'week commencing', ie. add a field that gives the date of the Monday of that week. So, an item published say on Thurs 22nd December 2022, falls into 'Week Commencing' 19th December 2022. Something published on Friday 23rd December 2022, also the same Week Commencing date. The formula we're using to do this is:DATEADD({CONTENT PUBLISH DATE},1-WEEKDAY({CONTENT PUBLISH DATE}),'days')And it sort of works. But it seems to want to force some content pieces from the end of the week into the next week and I'm unsure why. For example, I have a piece of content dated for the 11th December 2022, 3pm, yet it forces it into week commencing 12/12/2022. Any ideas why this might be?

We had Twilio automation running perfectly sending sms to a phone field on every new record added to a base.Today the automation started failing noting "Twilio reported an error while processing this action: An unexpected error occurred, please retry or contact Airtable support."When looking in the Twilio console I don't see related errors in the error log.Attached is a screenshot from the automations run history.I am new to airtable, and not sure if there's some better way to report such cases. Would highly appreciate your help! 🙂

I have a multiple select field I am attempting to update within an automation, but I can’t seem to add an option to it without overwriting. Pared down, this is essentially what my code looks like right now: Val = record.getCellValue("The Cell") if(conditions met) { await table.updateRecordAsync(record.id, {"The Cell": [Val, {name: "NewVal"}]}); } And this isn’t working, as it says it can’t recognize this input type. I’ve also tried using getCellValueAsString and then passing that as another option, but that didn’t work either. Right now the code is working but is overwriting the cell value when it does, so I want to add this functionality where it doesn’t overwrite. Any help appreciated!

First things first, for all you airtable users, all the best for 2023!Context:I've got a newspaper that appaers 6 days of the week: monday, tuesday, wednesday, thursday, friday and saturday.Every day i have in this newspaper 2 free spaces that needs to be filled up with an advertisement.I would like to use airtable to make a kind of reservation tool so i can follow up when the correct advertisement must appear in the newspaper.Through a form the user must be able to input:the name of the advertisementa start date of the apparitions (date selection from a linked table to exclude double bookings)a frequency of apparitions (1 = one day / 2 = two days / 3 = three days / ...)ProblemI really don't have a clue how i can automate that airtable assigns the dates to the record when the frequency is more then 1.And then for the icing on the cake... the frequency should be every other day => monday - wednesday - friday - (sunday) - tuesday - thursday - saturdayExam

Hello,I'm new to logic formulas and need some guidance. I have an AT to track company orientations. I have three columns- {Start Date}, {Orientation Complete Date}, and {Orientation Status}. I would like to create a formula for {Orientation Status} to show "Complete" when {Orientation Complete Date} is filled in, "Almost Due" when {Start Date} is within 14 days of todays date and {Orientation Complete Date} is empty, and "Overdue" when {Start Date} is after 15 days from todays date and {Orientation Complete Date} is empty.Any help or a link in the right direction would be appreciated!

Hi!Right now I get an #ERROR in Column A when the date is blank. However, I'd like it to return "N/A" instead.The formula below still results in an error.  What do you suggest?IF({Formatted Date},CONCATENATE({Formatted Date}," - ",{Event/Release}), "N/A")

Hey everyone! I have copywriters and designers uploading content to our bases on a daily basis. It seems as though previewing Microsoft Word documents (.dox extensions) is not available with the current Box app that Airtable uses to preview attachments. Or am I missing something? Screenshots below are from our interfaces. If you have any ideas how we can get these previews to show it would be greatly appreciated!

Hello, I have observed some performance decrease for the last 10 days, no matter the size of the database I am working with. The message “Loading this view may be slow due to a large number of records or fields” appears very often (it even appears when I call the airtable “What’s new” menu) Calling linked records is slower than it used to be. I am using Airtable every day to consolidate different data sources and my daily work has increased due to this performance breakdown. Am I the only one to observe a performance breakdown and, if not, is there anything to do? Thank you Pascal

Hi,How should I write the IF function to calculate commission based on A or B ? See below:If Take Rate is filled: Commission = GMV x Take Rate %Otherwise: Commission = GMV - Achat DistributeurThank you    

Hi,In one column I want to get shown a trend more obvious with colours.So I want the difference to the week before and in this case a green or a red broken heart.But somehow I am not allowed to put the heart at the front and the difference at the end ...(se result: NaN) 🤔 🤔Any idea, what I cannot see right now?Best regards,Martin

Hi there!Does anyone know if there is a way to do the following:Say you have a customer that orders 5 items, you have each item as a record and then the customer in a different table with the email address. I would like to trigger a button to start an automation to email a customer with the grouped 5 orders tagged to that customer. Thank you!