Ask the Community

Hi there,I am trying to attempt to add a formula, that when a certain hotel name is entered in column A, then in column B, depending on that hotel name, it adds the hotel brand automatically. For example:If Hotel Name is Hyatt Centric, then Hotel Brand is Hyatt. I can get this formula to work: SWITCH("Hyatt Centric", "Hyatt")But my question is can I/how do I have multiple Hotel Names in one hotel brand? For example:If hotel name is Hyatt Centric, Hyatt House, Hyatt Place or Hyatt Regency in column A, then Hotel Brand is Hyatt in column B.How do I write the switch formula to have multiple options?Thanks!  

I am struggling here! I thought I was getting better - but I need help. Thank you in advance!My column is "Sourcing Manager" and I am trying to create another column with a formula to add their email automatically.If the Sourcing Manager is "Monique", then it should list Monique@theroomblocksource.comIf the Sourcing Manager is "Karen", then it should list karen@theroomblocksource.comIf the Sourcing Manager any other name, then it should list hello@theroomblocksource.comThis is the formula I am trying:IF({Sourcing Manager}=Monque, monique@theroomblocksource.com, IF({Sourcing Manager} = Karen,

When I go to choose a related record, I see the name of that record.Under it I see several other columns that provide more information, some of which are redundant to the record name. Is there a way to customize this to select the fields underneath (I would love to show the related Notes field, as example)

I currently have a table that has alllll of our data. We want to separate it so it's a bit easier to manage. So, here's what I'm trying to do:Tab 1 - Master Info. This will have a SKU#, a product name, and a materials cost.Tab 2 - Wholesale Vendor #1 - We will type in a SKU, and it will bring in the product name and materials cost from Tab 1. Tab 3 - Wholesale Vendor #2 - We will type in a SKU, and again, it will bring in the info from Tab 1.I don't want the tabs to be busy and have extra columns. I'd like it to be a basic "vlookup" type. However, I can't figure out how to do it without a) having the extra columns and b), going into each and every line to pull out the info.Any tips? Thank you! 

I am currently trying to format information for later use, and need to keep to a pretty strict format, as seen in the first photo below. The inclusion of P1, P2.... is necessary to differentiate between information that has been provided to us and what returns false. I have managed to format the lookup field to separate into the desired format, but I cannot manage to use my "NumberofValues" field to create the P1-P5 in order for me to concatenate the labels before each separated value. Any help or direction would be greatly appreciated. Please let me know if more information is needed.

I have the following in a field:Value 1, Value 2, Value 3, Value 4, Value 5, Value 1, Value 2I need a formula to show me the repeated values:Value 1, Value 2Alternatively, I have another field with the unique values of: Value 1, Value 2, Value 3, Value 4, Value 5So another option could be a formula to compare this field with the original one and output the differences? 

Hello ‌👋‌We are trying to publish new blog post articles from Airtable to Webflow using Make (Integromat).The table for the new articles is set up identically for the fields in the Webflow CMS collection. There are quite a few fields to map, some of which are single-select and multi-select fields. (Example below)https://ibb.co/Kyp5xQ7These single-select and multi-select fields are Webflow collections for category and topic tags used in the articles and are multi-reference fields in the Webflow CMS. The single-select and multi-select items are set up in the same base as separate tables to the articles table. The articles table uses a link to another record field to add these to the article record.https://ibb.co/Yjqvr2Dhttps://ibb.co/02Ys3x9

I've seen variations of this question, but can't seem to find the best solution for my use case. (FYI - I'm on the Free version) I need to create sequential numbers based on a linked record. Example: Our "Jobs" table has all our jobs and their corresponding data. At times, certain jobs require a change order.  The format we use for this is the 544-01, 544-02, 652-32, 652-33, and so forth. The first number specifying the previously assigned Job# and the second being the change order #. When using autonumber the numbers aren't sequential if a record in between isn't specified by a single select as a Change Order. Making our records seem scattered and really confusing the customer when they received change order 15 and the next one change order 18. Any suggestions? 

Hello folks! I am trying to run updates to a table with a CSV file but I’m not seeing the option to merge records, only import them. I tried this on a few different tables and am still not seeing it. Anyone else? Troubleshooting ideas? Thanks!

I am looking for a way to import data from a CSV file but match on more than just one field. The CSV Import App appears to be limited in allowing matching to occur only on one field. Is there an alternative solution to importing data and matching on multiple fields? My use case is I am importing people who have purchased tickets at a recent event but I know some of the people are already present in the base. I would like to match on Full Name, email address, and Street Address 1 to avoid duplication of existing records while also preventing inappropriate overwriting of data. Thanks!

Is there a limit on sending a number of emails to collaborators and non-collaborators? Is see there is a 100 email limit in the Pro plan and wanted to find details for the Enterprise plan. I appreciate your help.

Hi Airtable and Airtable Community! Huge fan of your product and work. Is there a limit on the number of emails that can go out in a given period of time using the Send an email action? Thank you, Brea

Привет! Я пытаюсь импортировать данные из Google Таблиц в AirTable через «Импорт данных> Google Таблицы». Доступ к аккаунту Google открыт. Я выбираю нужную мне таблицу и настраиваю столбцы для импорта, но возникает ошибка. Пытаюсь ответить и снова открыть доступ, но ошибка остается.Мои коллеги имеют доступ к этому рабочему пространству AirTable. Когда я пытаюсь импортировать эти данные из Google Sheets в AirTable в своей личной учетной записи, все работает.Пожалуйста, помогите мне решить проблему.  

I organized my timeline groouped by rooms and I filtered the events so that only the ones happening on today or later. The thin is that airtable stop showing the rooms that doesn't have events planned in the futur neither. How could I do so that only the past events disapear but the rooms (even empty) continue showing?

Somehow the base I was working on erased some critical information from my base. is it possible to reverse these errors as in a time-machine backup? 

[iOS] Unexpected cursor jump to end of textbox by_a_Replacing Paste :::1️⃣ The flaw.  Here's a crooked example of it – just for putting an Airtable non-rich text data box to the test on iOS.  All I would ask you to do is go through the almost stepless scenario of an immediate and in-place "Select / Copy / Paste", or perhaps "Select / Copy / Reselect / Paste" – the latter in case the selection gets dropped upon Copy.  The selection can be just a_single word, or it can be whichever text portion you choose to select. The outcome of this essentially meaningless scenario will be particularly striking when performed from an editing position somewhere early in the text box at hand.  Indeed, the result of the "whole" operation is supposed to have nothing actually changed, but a side-effect makes the insertion point out of the blue jump to end of field

AirTable v9.6 on iOS (v16.6) seems no longer able to open up any linked record. At least that's what I_see when checking out the "Simple Project Tracker" demo base.// AirTable v9.6 on iOS ;// 2023.07.26.Wed.16:44.

The Goal is that I will have a new formula field, which gives me the lowest value of all 6, to be more precise a word which belongs to one of the dedicated fields (here it would be value "8" - field "1.6+2.6+3.6 traditio..." matching word which should be shown is "traditional")Best case would be, I also have a second field with the second lowest value of all 6 (here it would be value "9" - field "1.5+2.5+3.5 traditio..." matching word should be "social"

Attached Screenshots. Issue 1: View - Slack-Send Tomorrow's ScheduleThis view will send tomorrows(Friday) employee schedule to a Slack channel at 7pm every night. I'd like this view to automatically change to Saturday's Schedule, on Friday Morning. Issue 2: View - Working Schedule_Current Week + View: Working Schedule_Next WeekI'd like these Views to Auto Populate as many fields as possible, except Employee Names. Main fields would be the date with start and end times. 7 Lines for Summer Camp 10am-3pm, 3 Lines for Summer Camp 8:15am-3pm, 3 Lines for Open Level Fly 4pm-6pm, ect. Then on Sunday at set time_Current Week removes last week and populates new week, then the Next Week Schedule View pulls in. Appreciate the help!   

I’m trying to create a custom block, but when I run: block run I get: Error: listen EACCES: permission denied 0.0.0.0:9001 I’ve checked and there’s a system task already listening to this port, so I’m not able to just kill it. Is there a way to change the listening port so that I can make this work?

I am creating an asset register with the current values of assets. I have two formula columns in use to output the current data. Wondering if I can combine/nest the two formulas into one? This is what I have now, any advice on how I would combine these into one forumla? Top row is one column, bottom is the final row with current value.   (DATETIME_DIFF(TODAY(), {Purchase Date}, "years") * {Depreciation Percentage} * {Price}) MAX(SUM(Price-{Depreciation}),0)   

I am updating the "File" field of a record.  The cell is a long text field with rich formatting enabled.When I PATCH with this body:{ "fields": { "File": "~~[2022-23 letterhead doc34.docx](https://contoso.sharepoint.com/sites/ServicePlans/Shared Documents/General/Worksheets/2022-23 letterhead doc34.docx?d=w16af26ee9f084a6ba700aaa4bb4467a4)~~" } }Airtable returns the below:"fields": { "File": "~~\\[2022-23 letterhead doc34.docx]\\(https://contoso.sharepoint.com/sites/ServicePlans/Shared Documents/General/Worksheets/2022-23 letterhead doc34.docx?d=w16af26ee9f084a6ba700aaa4bb4467a4)~~\n", ... }Notice the \\ before the opening bracket of the hyperlink markdown.  This breaks the markdown and results in a visually unappealing field:   Expected behavior is a strikethroug

Hello. I am new to AirTable... not new to the concepts of relational databases...I created a simple "base" that I used the Lemonade stand template to get me going. I added a few fields to the main inventory table. I added a table to link to the inventory called Categories. It will help with filtering and sorting. It is for a small restaurant to help with ordering inventory. For now, I just need to use it as a shopping list, but see the potential. This thing could track inventory, etc.... Next, I imported the data. Roughly 350 rows. Next, I created a form to enter new items. Lastly, I created two new views into the main table... one that only has the item name, the category, and the supplier with a checkbox for a field called "Order". The workflow should be that i bring up the Shopping List. It sorts, groups, and filters things so it is easy to walk around the place with the iPad and scroll through the list, tapping the "Order" checkbox for the items I would like t

I’m using Airtable as a database as that’s where my clients data was already. Integrating in a react app using node/express/webpack deployed to heroku. When I bring in data from a long text block from Airtable, some characters are automatically escaped with backslashes - these are not visible in the UI of the airtable database. When I console log within the server it appears as below - Name: ‘Power Pose’, Notes: ‘INSPIRED BY: \n’ + Want to learn more about body language and how much our body impacts our mind? Watch Amy Cuddy's TED Talk, "Your Body Language May Shape Who You Are." https://www.ted.com/talks/amy\\_cuddy\\_your\\_body\\_language\\_may\\_shape\\_who\\_you\\_are\n, ‘Area of Improvement’: [ ‘Self-Awareness’, ‘Presentation Skills’ ], ‘Number of People’: [ ‘Solo’ ], Description: ‘Find a quiet space where you can be alone. Set and start a timer for 2 minutes. Spread your arms wide, making a “V” with your arms. “V” for th

I'm generating HTML emails and sending them using the Gmail automation.  They work great, except when a user puts a return character in the form used to generate the email (i.e. hits return on the keyboard inside the field (type=long text, rich text NOT enabled).  When there's a return character, even though the HTML looks solid, and is passed directly to the gmail automation, when the email is received on the client, where the return character was a bunch of closed HTML tags are inserted ( </p> </td></table> </div> etc) which totally breaks the HTML code and makes the rendering awful.Anyone else dealt with this?