Ask the Community

I'm working on an employee directory and the context I'm trying to optimize for is when an organization is downscaling.My base has these tablesIn short what I'm trying to achieve is that when an employee is matched with a New Org Role a new record is automatically created in Assessments where I list the employee, the role and the manager that is reponsible for assessing that employee for the role. The plan is to then send a notification to the manager to conduct the assessment. It should look something like this:In this example the main column is a concat, the "Employee" and "Assessment" by column is linked to the Employee Directory and "New Org Role" linked to New Org Roles. The "Assessment" column is a free text field that I plan to expose in a form. My challenge is that an employee can be a candidate for several roles, and a role can have several candidates - as can be seen in this example.I have gotten as far as parsing the candidates field into text w

Hello everyone.  I am trying to create a formula with the following logic: I have two fields (A and B) and these fields can contain different kind of values. Let's say that field A contains value A and field B contains value B, then I want the formula field to return a specific price. The same goes for an example where field A contains value C and field B still contains value B (then it's a different price). How would a formula like that look like?

Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be greatly appreciated,Bart

Airtable Friends! I have a linked field that is pulling records from our vendor database, which lives in a separate workspace. This database contains a master list of vendors, which admins update when a new vendor enters the game. In our main working base that contains the linked field, daily users can then add vendors to a specific record if they are part of that job. I need to check off that the vendor has been onboarded in a field next to the linked field which contains the vendors name. So I’m wondering if it’s possible to: -when a user adds a vendor name to our linked field, could it populate a multi-select field with the vendors name as an option? even better, a checkbox field.

Hello,I'm a new to the AirTable API and trying to automate adding records with data from another API.  I have this function: async function updateCrewRecords(data: CrewDetailsType[]) { const crewBase = new Airtable({ apiKey: AT_API_KEY }).base('appxxx') const table = cewBase('tblxxx') const records = data.map((crew) => ({ fields: { CrewID: crew.CrewID, CompanyID: crew.CompanyID, IsActive: crew.IsActive, Position: crew.Position, }, })) try { // const response = await table.create(records, { typecast: true }) const response = await table.update(records, { typecast: true, performUpsert: true, fieldsToMergeOn: ['CrewID'], }) } catch (e: any) { const errorMsg = `updateCrewRecords(): ${e.message}` console.log(e.statusCode, errorMsg) // throw error(e.statusCode, e.message) } } The commented out table.create(records) works as expected, but the upsert doesn't.  The error I'm getting is:422 updateCrewRecords()

Sendgrid has been working fine, sent emails yesterday, all of a sudden I have a missing root. Got new key, restarted. Tried different tables views. Still emails are suddenly failing and getting the above error. Help!

Hi - can you help? I'd like to sync specific files in Sharepoint with their attachments in Airtable. Use case is:- User saves new version of an image file in Sharepoint- A specific attachment is updated in Airtable with this latest version Many thanks

I have a simple automation the is producing an error "The Record Does Not Exist." Yet, it shows the correct Record ID from the previous step.

I would like to send an email to my team whenever an event in the airtable calendar/grid has a change made within 7 days before the event date listed in the grid/calendar.  We used the system to put all our event notes.  Example, if I change the guest count or menu option field last minute, could that trigger an automatic email to the designated email so my staff is notified of the change?  I don't need all changes to be emailed because normally they review the notes 7 days prior to an event. 

Hello, I currently have a table which calculates the payment to be made to a person according to the number of hours and their category. Sometimes the same person may have several pending payments.When this happens, is it possible to create a new field with the added information with automation?The "Folio" field would be used if this is when the new record should be generated. That is, if you have a payment of 100, and another of 200, the automation should detect that you have the same folio and generate a new field where the payment is 300. In short, I need the values ​​that it shows me when I group them to be generated in a new record. 

The Insights function provides information on activity for a given base and/or associated interfaces. It doesn't get me what I'm looking for so I'm curious if there is a way to gather additional metrics such as:MAURatio of new to returning visitorsBounce RateThank you!

Hello all,We have a fleet of vehicles. The people still fill in the data on a sheet of paper. I'm trying to digitize this a bit and I'm using the interface function (Forms).The person in charge would like to have a function that ensures that people cannot enter incorrect kilometers since they have to split up their kilometers driven.Do you know if something like this would be possible? Unfortunately, I have not been able to make it work.Thank you very much.    

According to https://support.airtable.com/docs/airtable-sync-integration-zendesk, automatic syncing happens around every 5 mins. But from my experience, it is around 10 mins. Is there anything to do to decrease it to 5 mins? 

Hi!I would like to order the records, find by 'find records" in automations, based on the date field. Now, al the records are views complete random... Does anybody has any idea? 

Sheet here: (can’t post due to new user) Column 1 is “Date” type with the time field disabled. Column 2 is “Formula” type: IF({Due Date} != "", {Due Date}, TODAY()) On row 2, if {Due Date} is empty, it automatically fills today’s date, ie, November 5, 2019. On row 1, {Due Date} if set to April 20, 2019, for some reason reports Due Date? as April 19, 2019. GMT setting is disabled.

I'm fairly new to JS and I'd love feedback if this script is the most effective. I'm trying to link records between tables, and I know it's not a simple copy-paste.I have two tables: enrollments (students) and courses.Enrollments has the fields:Course ID: integerCourse ID Link: link field to the Courses tableThe integers directly correspond to a 'Canvas Course ID' in the Courses table. Manually, I can copy from one column to the next to make the link.From what I've pieced together, you need to query to find the AT recordID for that matching integer. Here is how I'm approaching this:let enrollTable = base.getTable('Enrollments'); let enrollList = await enrollTable.selectRecordsAsync({fields: ['Course ID']}) for (let student of enrollList.records) { //find the matching Course from Courses table let coursesTable = base.getTable('Courses'); let courseQuery = await coursesTable.selectRecordsAsync({fields: ['Canvas Course ID']}); let filteredTerms = courseQuery.records.filte

In the last few weeks, we have been experiencing a bug when scheduling posts to Hootsuite. It will schedule to post, however, it duplicated the attached image. We have reset our automation to make sure we didn't have something duplicated as well as recommended our accounts. It is still creating duplicate images in the post. This adds an extra step as we then have to go into each scheduled post and edit them on Hootsuite. Does anyone have a solution?    

I was able to automatically update a record with a “need to start” status when created, but I’d also like it to automatically put today’s date in as well. I’m just not sure what I should be typing in the date field. I tried typing Today, but that didn’t work. I’m going to admit to being a total novice here so please feel free to spell it out to me like I’m five.

hello the Community i am building in stacker link to an airtable base. But when i add a field in airtable  and refresh the schema in stacker, the new field do not appear un staker  thanks !!!

Hello, Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using- DATETIME_DIFF({Start Date/Time}, NOW(),'days'). I now want to create a field that calculates number of days 'after' a workshop. I want to use this for an automation. So for eg: if days after training completion =7, send email. What formula can I use here? I tried using a dateadd formula but I'm getting it wrong. Thank you 🙂

I have an automation that converts input data into MD5 using custom script and the script’s output along with a field from the table is appended to the Google Sheet. All steps work when testing. But when running all at once using ‘rerun’ or through the form (the trigger is when “When a record is created”), all steps work except appending into Google Sheet, with the error "Row Data" could not be converted to a string.. Any help is much appreciated.

Hey folks,We recently received an email that Zapier's users' Airtable API keys will be automatically switching to OAuth tokens. How would this be possible? And how can we do the same for Softr users? Who would be the right person from the Airtable side to support this? Zapier Email: Your Airtable Zaps are switching to OAuth on Sept. 25

Hello all,I have a table with 3 fields (columns). First is for names,Second for passwords,and the 3rd one is a concatenation of the 2 first ones.This table is filled up from a form. (this step is working)On the next table, I have 2 fields, the first one (primary one) is empty, and I want to have in the 2nd field the information from the 3rd field of the FIRST TABLE. (still following? )But no matter if I use 'link to' or 'look up', nothing happen in the 2nd column of the 2nd Table.   

HelloI have a table that is effectively a Risk Register Which has been scored by probability (1-5) and Impact (1-5). What I want to be able to see how many risks score 5 and 5, how many score 4 and 3, show on a typical risk matrix/heatmap like the attached jpg. I'm sure it must be possible but I can't figure a way.Thanks!Andrew

Sorry if this has been previously addressed, but I can’t find the information. Is there a simple way to separate a base into multiple, small bases?Thanks.