Solved

I have a base with a “multiple select” field type — and I would like to update some of the fields based on data from a CSV import. I’ve looked into three angles… As I understand it, CSV imports can’t update a field, just override it. But my fields have existing data that I want to add to, not override. It’s also not possible to merge fields (if I were to import the data into a new column, I couldn’t combine with the existing data). Because I only want to update certain records, I can’t do a batch update (which would apply to all fields). Am I misunderstanding any of these pathways — or is there something else I don’t know about yet? Thank you!

Hello everyone, I am trying to use workday_diff function to calculate whether my team is able to process orders within specified TAT or not. and hence needs to calculate workdays. We have a column that tracks date created ({Date Created})for any order and another column that tracks last modified time to track how much time we took to finish the order ({Date Completed}). Hence the formula is : WORKDAY_DIFF({Date Created},{Date Completed}) But the output counts weekends too and the output is same as using DATETIME_DIFF. Please help me figure it out.

Hi, I’m trying to figure out calculating correct fiscal year since our company fiscal year starts from April: 4-6: Q1 7-9: Q2 10-12: Q3 1-3: Q4 And I currently have below formula generating value from cell {ETA} but getting the YEARS correctly is tricky. Any ideas? IF(OR( FIND(04,DATETIME_FORMAT({ETA},‘MM’)), FIND(05,DATETIME_FORMAT({ETA},‘MM’)), FIND(06,DATETIME_FORMAT({ETA},‘MM’))),“Q1”, IF(OR( FIND(07,DATETIME_FORMAT({ETA},‘MM’)), FIND(08,DATETIME_FORMAT({ETA},‘MM’)), FIND(09,DATETIME_FORMAT({ETA},‘MM’))),“Q2”, IF(OR( FIND(10,DATETIME_FORMAT({ETA},‘MM’)), FIND(11,DATETIME_FORMAT({ETA},‘MM’)), FIND(12,DATETIME_FORMAT({ETA},‘MM’))),“Q3”, IF(OR( FIND(01,DATETIME_FORMAT({ETA},‘MM’)), FIND(02,DATETIME_FORMAT({ETA},‘MM’)), FIND(03,DATETIME_FORMAT({ETA},‘MM’))),“Q4”)))) & IF(AND(VALUE(DATETIME_FORMAT({ETA},‘M’))>=6, VALUE(DATETIME_FORMAT({ETA},‘M’))<=12)," - FY’" & DATETIME_FORMAT(DATEADD({ETA}, 1,‘year’),‘YY’)," - FY’" & DATETIME_FORMAT({ETA},‘YY’))

My organization (10-ish folks) is having problems buying into the value of more diligently managing contacts in Airtable. Airtable has been made the primary technology in the org, along with the Google ecosystem. However, it’s highly likely that a good % of the org is not updating info in a timely manner nor adding new contacts. I’m interested in discussing any good hacks that might allow the team to more easily initiate contact data updates in the flow of the vast majority of tools they use (gmail, gdocs & zoom). I had one idea to set up an automation involving Make and Airtable, where a team member can bcc an internal gmail address when communicating with a person (contact) they want to add/update info for. Make could parse the info from the email header fields and add a record in an Airtable base. This record would kick off an automation that would look for a contact matching the email in the contacts table, and then do something to begin the process of collecting updated/new i

Hi! I’m working on an airtable script where I’m trying to re-link records that were previously linked in another base. Context: I shared two tables from an OLD base to a NEW base. These tables had records that were linked(in the old base). After sharing them to the NEW base, the links got lost. I’m now trying to re-link these records. I have two tables, “Companies” and “People”. The “Companies” table has fields with the company name and employees. The “People” table has fields with people’s names and their affiliated company. Here’s the script I have written to attempt to solve this issue. //Define the company table and query let cmpTbl = base.getTable("Companies"); let cmpQuery = await cmpTbl.selectRecordsAsync(); console.log(cmpQuery) //Define people table and query let pplTbl = base.getTable("People"); let pplQuery = await pplTbl.selectRecordsAsync(); console.log(pplQuery) for (let allPeople of pplQuery.records){ let cmp = allPeople.getCellValue("Company") console.log(cm

Greetings Airtable Community! I have a base with 6 tables that is shared with two collaborators. The most frequently used “master” table—named Events—is at the far left of the upper tab structure. Each time I open the base, this “master” table is selected. However, when my collaborators open the base, another less important table is selected. Is there a way to force the base open to a specific table? Thank you!

Feel like I’m missing something obvious…Trying to link records and for some reason my linked field is showing unnamed record…

Hello, I am trying to create an automation that would take a new record in my Table 2, and find the respective record in Table 1 and link the two together. For example: In table 2, I have a new record, John Smith, that has been added. In table 1, I should have a record, John Smith, with a different set of data. I want to make sure that in Table 2, John Smith is a linked field from Table 1, to connect the Table 1 data to Table 2 data without manually having to do this each time. I was referencing this article, but the struggle I’m hitting is that the “find record” action is never the same. It is all variable to what the Table 2 record ID is and then it should find the equivalent in Table 1. Do i need to use a script to find record that matches the table 1 record in table 2? I’ve never used scripts before within automations, so help would be appreciated! Any ideas?

Not sure if this will be possible but figured this is the group to ask. I’m attempting to automate delinquent account reminders for a dental lab. The auto email reminders will ideally have generic friendly text reminding offices of their past due balances along with our credit card authorization form and the invoice in question.

If I want to specify the last day of the current month in a cell as a date, what is the syntax? In Google Sheets & MS Excel it is EOMONTH (End Of Month). EDIT - HERE IS THE FORMULA - THANKS KAMILLE & JUSTIN DATETIME_FORMAT( DATEADD( DATETIME_PARSE( DATETIME_FORMAT( TODAY(), 'YYYY' ) & '-' & (VALUE( DATETIME_FORMAT( TODAY(), 'MM' ) ) + 1) & '-01', 'YYYY-MM-DD' ) , -1, 'day' ) , "MM-DD-YY" )

Hi! I am totally stuck here, so maybe I can ask you guys where I went wrong. I have the following situation as in this demo base: Airtable Demo220708 - Airtable Explore the "Demo220708" base on Airtable. In the first table I have different investments as rows with their total values for different periods as columns: Everything is great and I can see the total sum of all investments in the bottom row. Now my question - how do I get the total of each column into the period summary? I.e. The problem is that I cannot use rollup - because that is linked to a specific column, hence I get the same sum for all periods. Thanks in advance… :pray:

i have two tables that are linked. People and Service. Many different People Records can be linked to one Service Record. Additionally, one People Record can be linked to more than one Service Record. Service Records include date fields- Start & End. i would like to display a list of all of the People Records who are linked to any Service Records that fall within a specific date range. i want the list to show each People Record individually, with some key information from both their People Record and the associated Service Record. (e.g. from People Record- name, cell phone, emergency contact; from Service Record- country, start date, end date). i tried creating a junction table, but when i used the fancy junction table script i realized that was a big mistake. i also tried building an automation that triggers when a Service Record enters a view (filtered for the date range i’m aiming at), it creates a record in a different table and lists the people. But i couldn’t figure out how t

Hi there, I am struggling with a trigger, that should add all possible IDs from another table’s row to a specific record. When activated, the ‘visibility_all’ trigger should fill in all possible regions via an automation: Screenshot 1: The automation method I use is “When a record matches conditions”, see here: Screenshot 2: Everything works perfectly as long as I add the IDs manually from the other table, see here: screenshot 3: screenshot 4: My question: Is there a way I can solve this not only more elegantly but maybe completely dynamic via either the correct way to use this automation or via script? (there are other visibility triggers like ‘teams’, that could grow in numbers and therefor would need manual updates in the future) thank you in advance! best regards florian

I want to use an IF statement in a field where the logic will basically be the following: IF({Calibration Frequency}= Annual, ({Last Calibrated}+365 days)) I know this isn’t a valid way to code this - strictly an attempt to explain the intent. But basically, the {Calibration Frequency} field is biannual, annual, or 2 years. Depending on that value, i want the field to display the correct “due date” in the coded field based on the calibration frequency and the {Last Calibrated} date.

I like the comment functionality and it works great for tracking comments for 1 row BUT when I have data where I need to insert a comment across N rows it is quite tedious to open each row individually and add it in. How do I add the same comment to multiple rows at the same time? I am looking for a right click and comment option or similar.

Hello, maybe someone had a similar issue and can give me a hand After I do Block run on my extension the resulting localhost URL has an expired SSL certificate. It is my understanding this is a self signed certificate created on the fly when I do Block run (but I might be wrong) I searched for the certificate everywhere but it just isn’t there, which makes me believe it is created on each run for the server. Does know if there is a way to specify the certificate I want to use when I do Block run or any other work around to this issue. I am pretty sure I might be doing something wrong since I couldn’t find any other report on the same thing but I have spent 3 days now on this without luck. Any help will be appreciated!

Hello community! Here’s what I’m seeking assistance with: I have 3 fields total: Length of Service, Service Start Date, and Service End Date (or anticipated) I would like to write a formula for the Length of Service field that does what I currently have, but takes it one step further. Currently, I have a simple DATETIME_DIFF formula to display in Years the difference between the two dates. However, I would like to use today’s date (I’m guessing the NOW function) IF the Service End Date is in fact an anticipated date in the future. So if the Service End Date is greater than today, I would like to use today to calculate the time difference, and if the Service End Date is in the past, I’d like to simply calculate the date difference between the two. Any help is greatly appreciated!

I’m new to Airtable Thanks in Advance

This formula worked fine, until we brought on an additional team member in another country. I am now tracking this data for 3 team members in the US, UK, and Germany. I think I ultimately have 3 issues I’m trying to resolve: I’ve seen the great U.S. and U.K. Holidays tables created by user W_Vann_Hall, but my company has a number of additional days off outside of federal holidays I’d like to include. I’m going to go ahead and assume there is no easy way to do this. I don’t see one for Germany, and I’m not up for building that myself. But would it be possible to alternatively upload .ics files with the holidays for each company into a single table (in ISO-Format), and link those records for each team member? Assuming #1 above is more advanced than I’m capable of at this time, and #2 isn’t possible, is there a way to double nest the IF statements in my current formula to include 3 sets of holidays? Here is the formula: IF({Date Contract / Redlines / Feedback Returned to Stakehold

I have a situation where I need to display the linked records in a field like this (including the double “” on either end): [““recFMVIujI5jqSiSD””,““recf8rGUjcM0li5f4"”,”“recztuGU7Tl4GSSYU”"] Is this possible? I have this code to format it, I just need the ID part. '["' & SUBSTITUTE( {Relations}, ', ', '","' ) & '"]' Which displays: [“record1”,“record2”,“record3”] Instead of the record primary field name, I need it to display the record ID in a text field as formated above. I have a linked record column, then I added a new text field column that grabs the name from that linked column but I need it to be the record ID. Does that make sense? (replace the name with the record ID in the brackets)

Hi, I need to update field iloscZetonow to 5 each week. Where is the mistake?

Greetings Airtable Community, I am seeking help with formatting the formula below that combines data from two multi-select fields: {College}&" and "&{Department} Example of what the formula returns: Humanities and Department of Religion {College} is always be populated, but {Department} is sometimes empty. When this is the case, the formula returns: Humanities and Is it possible to edit the formula so that if {Department} is empty, the " and " will be removed, returning just the name of the College? Thank you very much!

https://videos.pickleball.ist/conversations/31657156-59b7-5196-9007-377d0b5a1ac8Video until 1:40 shows the context of what we’re trying to accomplish. After 1:40, shows the details of how we tried to set up our automation.We already have a “Zap” set up through “Pabbly Connect” where all new orders create a new record in our ORDERS table. We want a Airtable automation that looks at the records in our PLAYERS table and checks to see if the user that created the order, already exists (based on the phone number being the unique identifier).Consider that phone numbers have been entered in a variety of formats.Please see the linked video to see exactly how we’ve set up the automation… but we can’t get it to work.Any suggestions?

Actions are not executed although the conditions are met and the automation is displayed as runs successfully. If I then run the automation again in test, the actions are executed. Trigger: When a record is updated Conditional Actions: Condition: IF lookup field value contains <text> AND multiple select field values has any of <selected value> Find records Which meet the condition above. Update record Record ID: <record ID> linked field: <List of ‘Airtable record ID’ from step 2> How can this be?

I have a client that I am working with: has a content production company and they have their production timeline split in phases like Shooting , Pre production , post production and Delivery with start and End date like this: What I want to do is to break it through into separate unique records so I can group them together in a Gantt chart and able to see each phase inside the same project like this gird view : Gantt Chart view Is that something I can automate if I have all dates starts and ends in one record , that would be great to automate , because they still want to use the same structure and not to break it down to this as insertions .Thank you guys for your assistance . My Best