Solved

Hi, all! Is there any way to open a specific record in a table by clicking on the value in a single select field? Or is there a way to create a button with the functionality “if {single select field} says “value” open {specific record in another table}?”

Hi guys, it’s a mess that cannot change or set the name for Run a script. If I have more than one module - it’s difficult to navigate among them. Please consider this ability

Hi there, I have a base with the following tables Issue Log (All incoming issues raised) Issue type (All issues and how many times the can occur before an action is taken) Users (All the users linked to a specific issue) I am trying to do the following. a) User fills out the form logging a specific type of issue for a specific user. b) I am looking at the number of times the specific type of issue can be logged before an action needs to be taken. Where I am having trouble is the following I want to know for that user how many times the specific issue has been linked to them to determine wether to take an action. Ideally I’d like to do thing using something like a COUNTIFS based on the user and the number of times the specific issue being logged has occurred for that user. The two fields I want to conduct the rollup for Rather than having the total issues related for a specific shopper I want the number of times that specific issue has occurred for a shopper. I can create a roll up

I tried to use csv import but apparently it doesn’t support importing to long text fields. I have 1100 records I need to populate a long text field for and I would prefer to not attempt a copy and paste here with such a wide margin for error. Has anybody scripted this? I have the data to import in both xlsx and csv format, ready to go, just need to find a way to get it there intelligently and don’t see anything on the market right now.

Hi Folks, I have a Zapier Zap that is working beautifully to create invoices in Craftmypdf and then email them, but I have noticed a problem. The Airtable view I get the data from has a rollup field that is a sum of charges in another table, a currency filed that contains any money due from previous months and a formula filed that adds those 2. In Zapier I use the dictionary function to assign the value in the field Due to a key, also named due but the value is no longer 51.90 but 51.900000000000006 Is Airtable passing this or is Zapier corrupting it? What can i do about it?

Hi, For each record, I have a start date (Date de parution) and an end date (Date 6 mois). They unique to every record. I want to count how many we have sold of every record within those date (Sales are in the Ventes 2021 tab, which is already link to my working tab). I cannot filter by a Date field, it seems. How can I work around this? Thank you

Hi everyone, I’m a new user on airtable and I would like to create a table which contains a number field type, but when I run the script, I got this notification : We have a table A containing the list of clients we work with and each client has their own table. So when we add a new record in this table A, we are supposed to create a new table for this new client, that’s why we need this script. In the part of script below, I have those lines that I think is the right syntax to create a new table for the new client. const tableName = await input.textAsync(‘Choose the name of this new client’s table’); const primaryFieldName = await input.textAsync(‘Enter the name of the primary field’); const primaryFieldType = await selectFieldAsync(‘Choose the right type of the field’); // selectFieldAsync is a custom async function that prompt the user to select the type of the field let tableId = await base.createTableAsync(tableName, [{ name: primaryFieldName, // type: primaryFieldType, options:

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