Solved

Hey Everyone,  Needing help with another if statement.  It is not behaving in the manner I am expecting. I have 3 fields Odo calculated (Formula Field), Odo miles (Number field) and Final Odometer (If statement).  I am trying to have the Final odometer field populate with the odometer calculated field if the odometer overwrite field is empty.  If the Odometer Overwrite field is not empty I want that number to populate in the Final Odometer field.I currently have IF({ODO Miles} = " ",{ODO Miles}, {Odo Calculated})

hi! trying to get a nested if formula to work based on market and the only country that is pulling is the first (US) but not FS. if i switch "US" to "FS" for example, it will pull into the FS market and US. it seems to be an issue with the conditional statement finding a match and then stopping. any idea how would i fix this? IF(Market="US",IF(Channel="Natural Search",0.59,IF(AND(Channel="SEM Brand text",Quarter="Q1"),0.1,IF(AND(Channel="SEM Brand text",Quarter="Q2"),0.1,IF(AND(Channel="SEM Brand text",Quarter="Q3"),0.1,IF(AND(Channel="SEM Brand text",Quarter="Q4"),0.1,IF(AND(Channel="SEM Nonbrand text",Quarter="Q1"),2.12,IF(AND(Channel="SEM Nonbrand text",Quarter="Q2"),1.92,IF(AND(Channel="SEM Nonbrand text",Quarter="Q3"),1.7,IF(AND(Channel="SEM Nonbrand text",Quarter="Q4"),1.7,IF(AND(Channel="SEM PLA",Quarter="Q1"),1.55,IF(AND(Channel="SEM PLA",Quarter="Q2"),1.47,IF(AND(Channel="SEM PLA",Quarter="Q3"),1.18,IF(AND(Channel="SEM PLA",Quarter="Q4"),1.18,IF(AND(Channel="Affiliates",Q

Hai, I need track sales team for visit customer, for this I created form on AirTable Which problem when Sales team go to customer and submit report visit, there is no Geo Tagging ( Longitude and Latitude). I need to know information when Sales person is on customer location Can this possible ? if Yes, how to do? Thank you

I use the Typeform integration with AirTable but when sending multi-select data where the user has chosen the “other” option and entered a custom value it doesn’t get added to my AirTable. This uses the Typeform integration on the Typeform website and not the AirTable block so not sure if anyone here can be of help.

Hi, I have three tables : - students - challenges - attachments There is a form that allow students to submit challenges in the table attachments. When I receive a challenge submitted by a student, I review it and if it is correct, I manually link the challenge from the table challenges to the row challenges done in the table students. Here are screenshots for an exemple. In this example, student 1 submitted challenge ex3 and it was correct so I added ex3 to the list of challenges done by student 1 in the table students. Attachments : Challenges : Students : I want to automate this. When I click on success for a row in the table attachment, I want to automatically add the challenge succeded in the row challenges done in the table students. I chose this as a trigger : But when I automatically update the record, it replaces the list of linked records in the row challenges done by the new challenge only instead of adding the new challenge to the existing list of challenges done by the

Hello, I can see that this topic was marked as solved, but I cannot see a reply/solution. I am struggling with the same issue. Has anyone manage to solve it? Thank you. Continuing the discussion from Change the Order of Fields in Embedded Card View:

Hi, I need some help in creating an automation. My goal is when I create a new record in my Projects tab, it automatically adds today's date in the "Date Created" column. I've been looking into using an update record automation or a TODAY() formula, but I can't seem to get it to work. Any help appreciated!

Happy New Year, Airtable Community!Each year I document my Airtable environment. Does anyone know if there is an easy way to obtain a list of synced tables (with source and destination) that would save me the effort of going into each base to look for this information?Thanks in advance!

Hello, I need to create an aging formula with an If statement to track when a record is open with a count of days until it gets closed and ultimately stops counting.  I then want to be left with the difference of days between the date opened and the date completed,  in the days-old column.   Currently, the Days old column counts days open from the date the record was created.  DATETIME_DIFF(TODAY(), DATETIME_PARSE({Opened date}, 'MM-DD-YY'), 'days') and just keeps counting.  Any help is appreciated!   

Hello! I have read some forum posts about sending emails with images embedded, but I can't seem to get it to work. I have tried<img src="https://uploads-ssl.webflow.com/628cd622b5f08a77e670bc2d/63b83af885c7d8b02f984929_Artboard%201%20copy%202.svg" >And I have tried the markdown The above generates the image on preview but does not render live and the latter just creates a link.  Anyone have any tips? Thank you!

Hi folks! I'm trying to create a Base that tracks all the calendar entries in a shared Google Calendar, and then every week (or so), archives all the new entries in the Calendar Sync table into a separate "Archive Table". The first part is easy, I have our AT Base syncing with the correct Google Calendar we need and pulling all the info down into AT. The second part is where I'm running into problems. Because our Google Calendar policy deletes everything older than several (I believe 3) years - I need to find a way to archive that information separate from the sync table (since when things delete in Google Calendar, they'll also delete in the synced table).I also don't want to have it automatically pull new entries anytime a change is made to the Synced Calendar table - as we're likely to adjust the entries multiple times and/or delete and add new versions based on our needs - so if I have it automate pulling every entry over when it's created, I'll end up with a ton of

Hi everybodyI am having trouble with an IF formula.As background – I have a table that includes three multiselect fields. I am trying to count the number of instances of a particular keyword (could be a single word, or multiple) in each field. Below is the formula I am trying to use:  IF({KW Taxonomy L1}=Natural Sciences,"Yes","No")Which isn’t working.The fields are not linked to another table. Should they be? Am I barking up the wrong tree and should be using another formula entirely?Many thanks

Hello! I run a weekly publication and we have a number of freelancers who get paid different amounts for stories and columns. I have an Airtable table with their names and rates.So in my payments table, I have a Single Select field which chooses the type of writing. Then I have a SWITCH formula that uses the name and type of story to access the right rate. Works perfectly.Until I give someone a raise. When that happens, all of the rates in the old issues from previous weeks get updated, too.I'm trying to figure out how to either "freeze" the numbers in old weeks ... or something. Anyone help?

This seems like something I should have been able to figure out, but I've been struggling to come up with a solution. Duration fields are handy for inputting data, displaying data, and manipulating it in Airtable. But the underlying data is the number of seconds in a text string. For example, one hour, seven minutes, and seven seconds will show as 1:07:07 but the underlying data is "4027". When I use the output via automation, the field output is 4027. I want to use 1:07:07. Does anyone know a formula or automation that I can set up to convert seconds into a HH:mm:ss text output?

In my CRM, I am trying to compare two date values in a formula, in order to figure out which "Next step" value is the most recent. In my Interactions table, {Last contact lookup} looks up a value in my Clients table which is the output of a rollup that outputs the MAX date value from interactions for a given Client record. {Actual interaction date} is the result of a formula that compares the Interaction record's creation timestamp to an optional user-entered value, and outputs the user-entered value if it's non-zero.My formula is simple: IF({Last contact lookup}={Actual interaction date},{Next step}). Unfortunately, that formula fails to produce results. The fourth row should have "Find information" in the Last next step column. Any ideas why this doesn't work?Just looking at the screenshot above, it looks like a problem with formatting, given how the timezone appears. But Airtable understands the lookup value as a date:My only other thought is that the problem is that Next step is a

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 guys,I'm relatively new to scripting, so I've mostly used scripts I find in this amazing community and adapted them to my tables. Once such script I've tweaked to create junction tables. It automatically creates entries in a junction table when a linked record field is updated. It has been working pretty well for a 5-6 months now, then all of a sudden earlier today, it started giving the error:ERRORTypeError: Cannot read properties of null (reading '0')at main on line 38"Usually I can figure out what is going on and fix it, but this really has me stumped. I didn't touch the script today (I'm the only one who manages them). I took a snapshot of the base from this morning and the script works in that, so I tried to copy/paste the code from that to the live version, but it still didn't work. Which lead me to believe that has something to do with a change in the base, like a changed field or table name. So I thought, okay maybe someone accidentally changed a field name. Double chec

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