Solved

I want to find a way to automatically mark a record as “Used” if it is linked to another table. Is there a formula for an IF statement for “IF a field has information in it (if it’s NOT empty), add “Used”” Right now I have the following, but I’m receiving an invalid formula error message: IF({field}, “USED” Thanks in advance!

Hello! Context I am trying to develop a base to effectively manage project management and task delegation for my company. We create art assets for clients, where each asset goes through multiple stages of production before final delivery. This is somewhat standard project management, where each “Asset” roughly corresponds to a “Project” and each stage of production corresponds to a “Task.” We offer a semi-specific menu of asset types, so each asset type may also have different stages of production (and therefore, different associated “tasks”). I had posted a question earlier regarding batch creating tasks from a template to operationalize this process and was thrilled to get connected to the Creating tasks from a template script located here: Creating Projects/Tasks From Templates | BuiltOnAir Although I have no background in scripting or coding, I did manage to successfully integrate the script into my base, which is linked here as a tester (stripped of other functions I’m working on

Hi! I’ ve encountered a possible Airtable quirk and was wondering if anyone has a hint how to work around it. I have a Long Text Field with RTF enabled. In this field I have RTF formated text / Markdown text. In a formula field I’m trying to search this field for Blood Type: AB and if found output AB. Nothing strange so far. Only issue is that no such instance is found and the cell remains empty. I have tried IF( FIND('Blood Type: AB',{Profile}), 'AB' ) and IF( REGEX_MATCH({Profile}, 'Blood Type: AB'), 'AB' ) As I figure that it’s the markdown messing with it I have also tested IF( FIND('**Blood Type:** AB',{Profile}), 'AB' ) and IF( REGEX_MATCH({Profile}, '**Blood Type:** AB'), 'AB' ) and IF( FIND('__Blood Type:__ AB',{Profile}), 'AB' ) and IF( REGEX_MATCH({Profile}, '__Blood Type:__ AB'), 'AB' ) I even tested adding a &'' at the end of the field name, just in wild fishing/testing effort. No luck. Does anyone know how to do this? If I change the text to ‘n

Hi there! I’m losing my mind trying to figure out a formula for something I thought would be quite simple. Basically I have one field into which we input a URL (which comes from our CRM). I want to extract a particular portion of this and then add it to text in another field. To explain: The original field might have something like the below: https://author-p4650.adobeaemcloud.com/editor.html/content/dd/au/en/the-project/**about-us/our-favourite-restaurants-with-a-view**.html I’d like to extract just the section in bold and add it to the following: https://www.danmurphys.com.au/the-project/ to create the below in the formula field: https://www.danmurphys.com.au/the-project/about-us/our-favourite-restaurants-with-a-view I’m not super well versed in formula writing but have tried quite a few things. While the first portion of the original string (ending with “the-project/”) is always that exact number of characters (80 in this example), the issue I keep having is that the portion I want

I have a form that prefills a unique ID for each customer. They then need to select an event that they are signing up for from a drop down menu linked to another tables primary key. The problem I am running into is that I cannot autofill the event they are signing up for and I really want to limit the view on the events to events that have not occured yet, or even better yet, event that triggered this form being sent out. Eventually there will be 50-100 events and I do not want them all to show up, and I don’t want to have to delete events etiher. Is it possible to run an automation that sends all information from events to a past event table that has the same options and then delete the event record form the ongoing events field? Any other thoughts or suggestions would be greatly apreciated. Justin

Hi everybody, we are a small French NGO supporting family carers. We use Airtable since last year. We need to develop simple online training courses for carers : do you know with which LMS (Learning Management System) Airtable can interconnect ? Is there any you would recommend ? We need something quite simple - to push video contents & have simple quizz and interactions - and cheap (or free) ! Thank you for your reply! Helene

I’m not very sure this is achievable or not. Basically I want to automatically order all records sequentially all the time even i Reorder them. I have auto-number field. when I insert new record anywhere or move existing record I want to maintain the sequence, but that was not happening in Airtable. Am I missing any formulae or anything else?

Hi all! So I’m trying to make things a little easier for our Training Team and automating their Class Agenda creation process. Currently I have 3 tables in the base: Classes, Agendas, and Class Agenda Templates. Using automations, I am able to select a template in the Classes table (through a linked record field) that generates all agenda items for the given class in the Agenda table. Each agenda item created is also linked to the specific class through the linked record field. I’ve gotten as far as you can see in the screenshot of the Agenda table below. I’m trying to figure out a solution that will allow me to use the Start Time (given) of the first Agenda Item along with the Duration field to generate the start and end time for each topic throughout the day. I’m aware that I will most likely need to create and use formula fields as well. Any help is appreciated!

Hi there! I’m trying to develop a base to manage my company’s work and break out tasks effectively. We create artistic assets for clients, where each asset involves multiple stages of production (each stage roughly corresponding to a discrete task). I’ve created in my base an “Assets” table and a linked “Tasks” table - for ease of use, I was in search of an automated way to batch create multiple records linking “Tasks” to specific assets. I found the “Create child linked records script,” which is a great solution for this. However, this script only creates empty records (excepted for the linked field) - after records are batch created, I need to go in and manually enter the stage of production for each new task record from a single-select field. I’m wondering if there’s a way to further automate this function by “templating” the script so that it creates a record for each production stage? This would be especially helpful, as we create multiple different asset types that involve differ

Hey there guys. Im completly new to Airtable and having some difficulties integrating Airtable to my website forms. So these are the values on the website: I need these values to the Airtable aswell Right now I got: truefalsetruefalse. Is there a way to change these?

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?