Solved

Hello,I am new to Airtable, and have started to import data from my existing data stores. As part of my import, I would like to import and sync data from two different google sheets into one table in Airtable. The first sheet contains all of our customers and their data, the second sheet contains the results of a survey, which was only filled out by a subset of our customers. If a customer fills out the survey, I would like to include their responses in the resulting table with their other data.Is there a way to do this?Tom S

We have multiple dates that we need to have automatically update for us in table.Example:Move-in date (4/1/23) plus policy day (60) = Lease end dateLease end date - NTV date (30) + 5 days= NTV date needArrival Instructions date = 2 days prior to Move-in date (4/1/32)How would you go about doing this in a table? 

Hi, Using the formula below I have an ERROR value issue when there is no date value available for {last deal stage change}. Can anyone advise how I would alter this to just leave a blank space or "no data" where there is no date value available in the date field column?I need to use the datetime format to tidy up and remove the timestamp TRIM({Status symbol} & " | " & {Pipeline} & " | " & "Stage last changed: " & DATETIME_FORMAT({last deal stage change},'DD/MM/YY') & " | " & {Deal Stage})Thanks!

Hi Community, I have 5 fields (checkbox) that can be selected or not, I need to assign a status triggered by these fields, if any field of the 5 is selected then a status will be set and if no one is selected It will assign a different status. Thanks for the help.

E.g. I want an automation be triggered every Monday OR over webhook. 

Hi all: I'm trying to simplify the process of converting a short ID code to a longer ID code inserting leading zeroes where needed. The ID codes are structured to track Week, Day, and Segment numbersFor example, if the input data is 1.2.3 (week 1, day 2, segment 3), the necessary output needs to be formatted W01.D01.S03The wrinkle is that while day and segment are always going to be a single digit, the week value could either be one digit or two digits. I've managed to get it working with a series of breakouts that takes the input field, breaks out the week, day, and segment into separate field, adds leading zeroes where necessary, then concatenates them back into the final output id. But it takes 8 separate steps/unique fields to accomplish.  I'm looking for a way to do it in fewer steps. Here's how I have it working currently:Input: "ShortID" (e.g. 1.2.3, 12.7.1) -- manually entered 1) "BreakoutWeek"   LEFT(ShortID, FIND(".", ShortID) -1) 

Hello, I'm trying to check if my "inputValue_1" field occurs in a string pulled from a lookup field (named 'test' in the screenshot below). I'm trying to use this to check if inputValue_1 has a valid input, as defined from this lookup field.The formula I'm using is `FIND({inputValue_1}, {test})`, which should ideally return the position where `inputValue_1` occurs inside of `test`.  I've tried SEARCH(), but just get errors. This leads me to believe that FIND() is right, but something is off, since I am just getting position zero no matter what. I would expect `new south wales` to return 1, and `victoria` to return 18. Any help is appreciated.

I have addresses in multiple lines and am using REGEX EXTRACT in Airtable to separate the components (street address, suburb, state, post code) before sending them on for shipping labels.I've used REGEX_EXTRACT({text input}, "^(?:.*\n){1}") to extract the first line and this works in most cases except when the street address is over two lines (see example B).Can someone please help me with a REGEX EXTRACT that extracts every line except the last line (whether the address is 2 or 3 lines)?Or is there a simpler solution I'm not aware of? Example A1 Test StreetRichmond, Perth 3021Example B1 Test StreetUnit 6Richmond, Perth 3021For reference on how I'm dealing with the rest of the components...I've used REGEX_EXTRACT({text input}, "^.\r?\n(.)") to extract the last line (Subrub, State, Postcode) and then used REGEX_EXTRACT({text input}, ".*(\d{4})") to extract the post code.Once I have the post code I'm matching it against a database to find the Suburb and State. I did this because I b

Hello,I have a multiselect column "Products" with empty, single, or multiple strings of product name inside.E.g. Xbox 360, PS4, etc...I want to create a separate column's, based on data from another table, that would take into account that column.1. Would calculate number of separate strings (Clear)2. Would replace string with number (Price of that product) (Data of price is stored in another table)3. Would calculate total sum of all those product prices. How would you recommend to achieve that, via Replace, Scripting or something else? And how? Would highly appreciate help!

Hi Airtable Community!I'm not sure what I'm doing wrong with this formula. We are changing our pay rates on April 1st and I want to program my payment field to reflect this change. My table has a date field called "Fecha !!!" and a lookup field for our new rates and our old rates.If the record has a date before April 1st I want it to use the old rates. If it has a date on or after April 1st I want it to use the new rates. Here's what I have so far! I'm a beginner! Thanks for your patience and  advice 🙂

Seems like it should be easy. I want to display the "Ending Balance" field from my most recent record. The summary type for monetary records doesn't have an option for most recent record. But the date record does have that option. So I can display the most recent date, but I want instead to display the Ending Balance for that record. Is there a way to do this? Thank you!

I've tried searching this, but can only find where people link two tables, then manually add the relationships for each record.This is my situation.  I have two tables.  One is a list of addresses (123 main st, 234 main, 345 main, etc) and also has owner name (multiple addresses can have the same owner), the other table is owners and info like phone.  I wanted to just link the two tables by owner, so in the owner table, if I click the owner name, it will show all the properties they have.  When watching videos, it seems I have to do this manually by adding each building to the respective owner.  Is there a way that I just link the table and it happens by itself?  I have thousands of records so I can't do it one by one.

My goal is to use Airtable to manage orders of materials. The idea is to invite people in charge of the orders as full users in the paid plan, and create a shareable link to a form which could be used by others in our org to order materials - therefore they need the ability to create records through a form only.The people making orders do not need or want to use airtable - they just need a channel through which to make orders. They would be using these forms only very occasionally, like once a month or similar. Also the group of people is large, up to tens of different people with occasional needs.The people managing the orders would be active users of Airtable.Is it possible to use Airtable in this way or would we be billed for every single person who has access to the form? Obviously we don't want to pay hundreds of dollars per month for the ability to interact with Airtable forms every now and then.

Hi,We have a calendar view that shows pretty nicely on the desktop.However, the mobile app shows the meetings' auto number field, and overall it's not user-friendly.How do I customize the mobile app calendar view?Thanks,Giora

Morning everyone, I have a couple of questions about this solution posted by @Adam_TheTimeSavingCo (Thanks Adam, it works really well!): Create records from multiple select field choices Question 1: Is there a way to populate a field in the new table using data from the multi select? Using the example base linked in the topic above, I would like the 2nd table to look like this after running: Question 2: Is there a similar function for linked records? I have done the below manually, but the initial table would like this, and then would have the same output on table two: Thanks, Jordan

Hello - I am clear on the subtleties of Workspaces and chargeable collaborators, but one point remains unanswered.Does the top-level 'account holder account' have to feature as a collaborator in any or all of the Pro Plan workspaces that sit under that account? In other words, can I: make one of the collaborators a second owner of the workspace (assuming the workspace was created by the account holder) then ... delete the account holder as a collaborator on this workspace I don't have an environment in which to try this on my own at the moment.Thank you!  

I'm missing two fields plus two new ones (4 Total) I have created in PowerBI from Airtable Base's. I'm extracting data from many Bases's, and only have a problem with a certain one. That data isn't special, the fields are simple "Single Select" Fields.I get no error's in the PowerBI query, it just doesn't show the four fields.

Hi allI've just got into scripting, and have fallen at the first hurdle. I thought this would load an array of all my records as objects, with each field in the object with its value as a a key value pair. let table = base.getTable("Contacts");let query = await table.selectRecordsAsync({fields: table.fields});console.log(query.records); However, it only seems to load the record id and record name. All other fields do not seem to be within the object.I have tried specifying the exact fields in {fields: table.fields}, and then console.log(query.records[fieldname]), but this also returns undefined. I'm coming from Python to Javascript, and I'm not a proffessional. Am I doing something dumb? Thanks in advance.

Hi All! I have an automation set up so that when conditions are met (i.e I select a certain label from a single select menu), the an email is sent out the the attendees that were assigned to that meeting.The problem is that it is only grabbing the first email in the email field and not sending to all the attendees. Is there a quick fix for this?Table has a Row for each meeting with fields for:Meeting nametimeroomAttendees (pulls from the stakeholder table and contains multiple people)Email (pulls email from the stakeholder table based on the Attendees. Data looks like: name@email.com, anothername@email.com, thirdname@email.com)Automation:Action Type: Send an EmailConfiguration: TO= Look upfield: "Email"   Token="Value"In the Table the Email Field shows:  name@email.com, anothername@email.com, thirdname@email.comIn the automation preview it shows only: name@email.comEmail is sent to only name@email.com Open to any ideas- Am I just missing a toggle

Hi all,The data from the table below is from another table using Automation:Once the status of a request ID is updated, then the update time of each status will be automatically recorded in this table.Is there any way to calculate the time difference between each of the statuses and then update the field "Duration"?I've tried putting the update time of each status in different fields(Image 2), but still failed at getting the duration.(Image 1) (Image 2)   

Hello there,I have been using Airtable for a month and I absolutely love it.I am creating a basic HR system. I want to create a formula for the employees’ paid leaves.How do I automatically make it add up in Airtable, using the Hours off (8 hours/day)?Is there a formula for that?Thanks in advance.

I'm new with these and I think i'm having a big mistake but I cannot find it.I'm trying to extract the number of hours for an specific duration record.Obviously I use HOUR command but it doesn't work!As you can see in screenshots, the field Hours works in the following way:Hour({Time})But, it generates ERROR!What am I doing wrong?Thanks!  

I have a Payment Interface with a Form that creates a new record in my Payment table.  There is a field for Dues Amount and another for Donation Amount.  Both are define with a Currency data type, and with a Default Value of $0.00.  In most cases only one of these fields will be updated by the User.  The problem is that the default value is not being applied to the field the User fails to update.What am I missing?  It appears that the Default Value feature that is available when defining the field characteristics (e.g., name, data type, default value), doesn’t work properly.

Hello! Does anyone know how the default view for an Airtable Record URL? I would like my automation (Slack notification) to open the record URL with a specific view in the background, but I’m not sure how to to do that. Thank you!

Hi,I am needing help creating a formula.It would be if (15% referral says no then it would calculate the daily rate times 15%), if (15% referral says yes then it would be daily rate)