Solved

I have an Airtable account and so does my client. When they invited me to collaborate on their account it led me into my own account. I can see the collaborators in that company here and can talk to them but now I don't know if what I am creating is in their account or mine. I also want to know if there is a way to toggle between accounts so I can be clear about where I am. 

I have an Automation that is triggered by the appearance (in a new form-generated record in Table-A, {T.A-Rec.1} ) as having a non-empty value in a field {T.A- Field.1’}.  This {T.A- Field.1} is a link to a record in Table-B.Record {T.A-Rec.1} ALSO has a link field {T.A-Field.2} containing a link, {Ref.C.Link}, to a record in Table C.I wish to update a record in Table C, the record referenced by {Ref.C.Link}.  The field in the referenced Table-C record that I want to update is {T.C-Field.3}, also a link field to Table-B.  The value that I want to put into the {T.C-Field.3} in the referenced Table-C record is that of {T.A- Field.1’}, the link to that same record in Table-B.In my Automation so far, I seem to get the trigger to work OK.   But when I try to configure an 'Update Record' Action to update the {T.C-Field.3} field in the referenced Table-C record I get very confused about specifying what record/field to update with which record/field value.  Nothing tes

I would like to have a number field that increments by one whenever the “most recent sale” date field is edited so we can sort products by the number of sales. How do I make an automation that does cellA+1 when another cellB is updated? edit: If anyone knows of a way to do this without a third field, I’d be obliged.

Hello. I am trying to create an automation or a script that updates a cell in a given table based on a unique identifier that can be matched to a unique identifier in another table. In my mind, I'm basically wanting to do a left join, except that I want to populate missing values in a column instead of just bringing the whole column in. So, more of a if x is null, x = value from column in another table mapped by a lookup value/unique ID.More detail about table structure:Table A: File NamesColumn A- Name [short text- is essentially file names, as in ThisDocumentName.docx]. Is populated through a Link to another record column from another table.Column B- Google Drive Link, missing some values [URL]Column C- Unique ID [short text- is essentially a cleaned version of Column A]Table B: Google Drive LinksColumn A- Name [short text- is essentially file names, as in ThisDocumentName.docx]Column B- Google Drive Links, complete [URL]Column C- Unique ID [short text- is essentially a cleaned versi

Hello the Airtable Community! I’m working on a series of Airtable interfaces to handle different aspects of projects. It’s a kind of top-down structure, with interfaces drilling down into linked records e.g. clients > projects > invoices. The typical interfaces structure looks like this: Client A (Interface I) – Project A (Interface II) — Invoice A (Interface III) Client B (Interface I) – Project B (Interface II) — Invoice B (Interface III) To navigate between interfaces in the same client / project context, I’m using record pickers. At the moment, I manually pick the relevant record with the record picker and copy the URL parameters generated by Airtable back to my Airtable base. With such hardcoded URL parameters, I can repeatedly achieve the navigation flow that I’m eventually aiming for. Is there a way to do this “properly” dynamic, with a native Airtable function (such as RECORD_ID()) or similar? Is there an existing documentation that I missed? Is it not yet possible and

Hello! I'm trying to write a script that I can run to populate a field in one table with a value that lives in another table. There are key values in both tables that match. I have worked in SAS and a little in Python for data analysis, but I am new to Javascript. I am thinking of Javascript as adding the element of time to scripting ("wait to do this-- I'll tell you more about it later!")A simplification of what I have:Table1FieldA- unique record ID- stringFieldB- column to receive info from Table 2- stringTable2Field1- unique record ID, matches Table1.FieldA-stringField2- column to populate Table1.FieldB - currently is 'link' field type but could be string if neededI tried to this via automation but it's not working. My guess is the long strings used as the lookup values are causing the problem, but I really don't know why it's not working, it's very hard to troubleshoot that any further.I'm pretty close with the script... kind of. I used another script and can get the lookup functio

Since the forms layout in the interface is so limited (no ability to add new records in a linked table, no options for lists, grids, etc...), I'm basically using the record details layout as a form for new records entry. The problem is that the solution isn't very elegant. My users have to add a record to a list, and then open the blank record to get into the details. Any idea how to implement a page that would act as a record details form without getting there from a list or grid?

I’m currently using nocodeapi.com to reduce the costs associated with my Make operations, but their app hasn’t been updated to the new API specifications yet.  Does anyone know of a similar app or service I could use?

Hi Community,I have a lot of tabs which are all green, however all these tabs consist of various process flow.I would like to assign different colors to the tab, may I ask how to change grid tabs to have multiple colors?Thank you! 

I have a date in CurDt and I want to add YrOffset to it and end up with a new date in a date format. YrOffset can be negative, positive or 0. I’m not sure how to do it.

Hello world, I’m new to airtable and to this community and I think that I need your help :pray: I have a integer field (called “votes”) that is set to 1 when a record is created. I have a checkbox field which is not filled by default. I created this automation : When record matches this criteria = Checkbox is filled Then I want to update the record’s field “votes” by adding 1 But as it’s a integer field I can only “Add a number” :confused: Can you advice me on what should I do please ? Thanks :slightly_smiling_face:

Hi all, newbie here - is there a way to create multiple columns in one go from a list of column title headers I have as a list? I have 60 + columns and have written the Column names down as a list (which can be also as rows in one column) and want to create all the columns in one go rather than one by one as it is time-consuming (all the columns are of the same type - text) . Thanks

I need to restore, or more exactly, copy part of a snapshot into the base we are currently using. I realize Airtable's intented way of restoring is just to go on using the snapshot instead of the latest version, but this is not possible in this case because there are too many extensions, apps and syncs connected to it + we haven't stopped using it .Details and difficulties disclaimer:The base is a very complex BOM with thousands of records made of different combinations of hundreds of records from 4 or 5 other nested tables where all the names/primary records of all those tables are a formula composed of abbreviations of those linked records. What happened is that I lost data from one of the innermost of those nested tables and that changed the formula names of the parent records, so I can't match them to their copy in the snapshot by finding each by name. The record ids in the snapshot are different than the original, so no api or copy paste method that i know about works, not by name

Hi Community,May I ask is it possible to make airtable connect to Navision via API?Also is it possible for Airtable thru API to tabulate forms in Navision simulataneously?thank you! 

Hi Airtable community, Looking for some help with setting up a basic CRM. Context: This company runs multiple programs. 1 person can sign up to multiple programs Want to create 2 tables: Table 1: Sign-up forms: All sign-up form data sits here, there will be multiple rows per person in this table. Table 2: CRM: This table has one row per person. Each row/record/person links to that person’s forms in the sign-up form table. I have created a quick Loom video to explain

Hi guys,I currently have the below in a grid view.I would like to have a formula in the "Timeframe Status" column which will do the following:1. Check whether text has been added to the "RFI Resolution" field.2. If the "RFI Resolution" field is not empty, then check the hours between the "Date Created" field and the "Due by" field. If this is less than 48 hours, then return the text "Within time". If it is equal to or greater than 48 hours, then return the text "Past due". I would like the hours to be shown decimal 0.003. If the "RFI Resolution" field is empty, then return the text "Ongoing". Again, I would like the hours to be shown decimal 0.00Thanks

Hello Airtable Community,I'm new to writing code and am struggling to combine two different formulas into one. I have 4 columns I'm working with - Due Date, Days Until Due, Date Posted, and Priority. I want the Priority Column to output "Due Today", "Due This Week", "Due Next Week", "Upcoming", "Overdue" or "Complete" based on the number of Days Until Due and the Date Posted columns. I have a formula working that will output "Due Today", "Due This Week", "Due Next Week", "Upcoming", and "Overdue":IF({Days Until Due} < 0,'Overdue',IF({Days Until Due} = 0,'Due Today',IF({Days Until Due} <= 7,'Due This Week',IF({Days Until Due} <= 14,'Due Next Week','Upcoming')))) and another that produces "Complete" if the Date Posted field contains data, but I can't seem to combine them in the right way.IF((AND({Days Until Due} < 0, NOT({Date Posted} = BLANK()))),'Complete')

HelloI have three tablesCONTRIBUTORS, with Name and other infoACTIVITIES, with Title and other infoCONTRIBUTIONS, with Contributor name (lookup), Activity title (lookup) and DurationThe latter looks likeAlan, Hackathon A, 12:00Melinda, Hackathon A, 10:00Alan, Presentation C, 4:00Now, I would like a field Total contributions in CONTRIBUTORS that sums up the Duration of CONTRIBUTIONS per Name. 😊This would show 16:00 for Alan, 10:00 for Melinda, etc.I got the result in a pivot table but I need it as a table field.I tried the following, which does not work. 🤔 🤔Total contributions (rollup) in CONTRIBUTORSLinked from CONTRIBUTIONS, field Duration, where Contribuor contains {Name}, aggregate SUM(values)Thank you for your help. 🙂

Hi.I know how to display items from two bases in the same calender.But I realize I do not know how to easily display items from two tables from the same base.That should be easy, isn't it?

Hi all,I'm looking to roll up a set of linked records into one total linked records field.I am building a sales CRM and have different recruiters being labeled for different phases. Below is an example of my "leads" database. All items in brackets are [linked records] to the recruiter tab, where i've build recruiter interfaces for them to interact with their current lead statuses and etc.For example:Prospect LeadRecruiter Phase 1Recruiter Phase 2Recruiter Phase 3Total RecruitersProspect 1[Sally][Jane][Sarah][Sally] [Jane] [Sarah]Prospect 2[Jane] [Sally] [Sally][Jane] [Sally]Right now, I can't get the "total recruiters" field to autopopulate based on linked records in phases 1, 2, and 3. Recruiters, via the interface, can select a different recruiter to be on phase 2 or 3 once past phase 1. Ideally, I want every recruiter who is in touch with a prospect to be linked in the "total recruiters" column so that recruiters can easily see all of the prospects they have, and then what

I can add a button on my interface page that navigates (go to interface page) to a form. However, I'd like to set a field value (within that form)  based upon current focus.The application is an ideas board so I'm focused on Idea A (main page) and I navigate to a voting table (form) but I want to pass idea A to that form.So I'm thinking I need to associate the button with a script but cant find example code for this application eg interface page navigation. Can anyone point me to an example?

While I can do this manually, is there a method either when creating a linked field.. or after, to determine the the field it is linked to.For instance, we are tracking several fields in a loans file with our contacts table. So, for instance, the fields, Borrower, Co-Borrower, Buyer's Agent, Buyer's Agent TC, Listing Agent, Listing Agent TC, Title Rep, etc. all link to our Contacts. I created the relationships from the File_Loans table. So, in the Contacts table they look like this:I can link a record in each field and determine the linked field - allowing me to provide a better name on this side of the relationship but... Is there a better way?Thanks. 

I have contact records in my primary tab (we’re using Airtable as a CRM) where the contact’s Full Name is the main record. Then in another tab, we’re logging interactions with the contacts, and have a column that links to the contact record in the primary tab. In our primary tab, we have a column “Follow Up Date” that looks at the interactions in the other tab and grabs the follow up dates from each interaction with that contact (also from the column “Follow Up Date”). Ideally though, we only want it to grab the most recent date. If you see in my below examples, the contact Brian has 2 dates in his follow up column. This is because there are 2 interactions linked to his contact, both of which have a follow up date. However, the only date we need is the June 3rd one, since it’s the most recent. Is there any way to add this as a condition? I’m not seeing it. Thanks! Tab 1 Tab 2

Hi,I watched the getting started in airtable webinar on Tuesday 25th July 2023 and they said they would email the link to the recording, which they haven't. I want to share the video with my colleages before a meeting with the sales team tomorrow. I can't find the link to that specific webinar on the website and if I click the links in the answers to this question that has been asked before, I just get the sign up page.Where can I find the link please?

I want to populate a calculated field using data input into other fields.Example: Q1 = XYZQ2 = ABCCalculated Field = Q1&Q2 = XYZABCIs this possible to achieve in either an interface or a form?Thanks!