Other Questions

Hi there, I am a complete novice. I have a billing table with several procedure code fields, all of which are linked to a procedure code table from which they can be selected. I would like to build a macro where a type of surgical procedure (a surgical procedure may have one or more procedure codes) can be selected from a field in the billing table. the selection field contains the name of a surgical procedure and is linked with a templates table which contains the procedure name as the primary key with it’s corresponding procedure codes (the procedure code fields also are linked to the procedure code table. The aim is to improve billing ease and coding consistency. I really hope that there is a solution to this (knowing me, it is probably embarrassingly straightforward) - if there is code involved, I would be grateful if someone could write me an example. Thanks much, Nick

How do I send emails to a group of records within my Airtable base?

Hi everyone, I would like to know if there is a way to search in all the fields of a linked tab when you are in the other tab. Right now, all I can do is search inside the primary field, which is not very convenient. For example : I want to add a client in my tab. He is of course in the other linked tab. I don’t remember the name of his company but I remember his family name. In the same time, I also want to add a client, whose name I don’t remember, with his company name. To add them both, I should have write the company name and the family name in the primary field in the first place (although it is already written is the next fields), for each client. That seems odd regarding all the things you can do with Airtable. I must add that I’m using the free version right now (not for long though), so maybe it’s because of that? Thanks in advance for any help provided.

I’m trying to copy/paste data from a Google Sheet into airtable (import as a csv may work but for my use case I’d rather just quickly copy/paste, rather than going through the download/upload process). My problem: When I set the field as percentage or number type, the pasted values change from negative to positive. What I’ve tried: I’ve ensured that the “allow negative numbers” is toggled on (and have even tried it toggled off) but no luck. When I set the field as single line text, the number formats correctly but then I can’t use it as a “number” in subsequent formulas since it’s formatted as text. Anyone have a similar problem or able to help?

Good morning I am creating a base of control of parking lots, I have created the tables that allow me to make reservations. I want to create a table with a calendar where, in each day, can be reflected the lots that are reserved, for example: I have a reservation of lot 01, which is reserved from 01/03/2022 to 4/03/2022, I want that in the calendar I could see reflected in the days 01, 02, 03 and 04 than the lot 01 is occupied. Is this possible? thanks for the help

Hello Airtable Community! I was wondering if anyone knows the solution to my little problem - some of the records in my table will have almost identical information about the partnership programs we’re working with. Is there a way to sync specific records within the same table, so that, when in one of the synced records a change is made, it is automatically shown in all other synced records? Ideally I would like to specify in which columns these records should be synced, since there will always be one unique column per each record that identifies one record from another. Every bit helps!

Hello, We have a table set up which has several fields. We need to send a few of the fields to our finance team which we have worked out how to group but the key thing is to isolate the data by month. We can see that you can filter dates but not by actual month it would appear? We don’t want past month or future month as that can cross over 2 months(14th Jan-14th Feb). I would have thought that if you picked within these dates you could use a calendar to select say 1/1/22-31/1/22? However only option appears to be to select from the drop down list. It seems such a simple request so must be able to do it. Any help would be appreciated, driving me a bit mad. Thanks, Nick Read more REPLY

I have a column with employee start dates, called “Start Dates”, and I have a column called “Anniversary Dates” where I need a formula to show the start dates in the current year 2022. What is the formula?

request to https://api.airtable.com/v0/appoKBPaQhwtjz8TP/Sales%20items/? failed, reason: connect ETIMEDOUT 3.209.185.206:443 Please suggest solution

Hi, How can i count for a condition, i,e, COUNTIF for entries in fields of the same record, i.e looking at ROW Data, e.g. I want to count how many persons are Competent, which in this example is 2, but i could only get COUNTA to work, and that just looks at “is field empty or not”. Cheers, Si

In calendar view, events default to the 1st column, “Name” category. Is there a way to change the default column calendar uses? I want to create a shared calendar that allow customers to see which city I’m working in, without revealing the customer name for those jobs.

Hi all :wave: When I import messages from Slack (via Zapier) into Airtable, the emojis are presented in AT as text (like :emojiname:) instead of showing the actual emoticons in AT. Is there an easy way to easily turn this into emoticons? Thanks in advance. -Harold

Hello, i got this error but i don’t have any idea where to look for to fix this issue 1. Error {name: "SyntaxError"} 1. name: "SyntaxError" Here is the code : const wordAI = await remoteFetchAsync("https://github.com/braytonstafford/wordai", { method : "POST", header : { 'Content-type' : "application/json" }, email: email, key: wakey, input : "This is a test", rewrite_num: 2, uniqueness : 3, output: 'json', quality: 'Regular', }); try { const data = await wordAI.json() console.log('response data?', data) } catch(error) { console.log('Error happened here!') console.error(error) }

I don’t know if I’m missing something obvious but in many questions asked in this forum, after they are “solved and closed” I cannot see the reply, as in the image attached… what’s going on?

Hey Folks - I’m a new AirTable user using a not-terribly-complex base that someone else built. I love it and want to create something for my real estate business. At a glance, it would seem pretty straightforward, but after playing with it for a bit, I’m not so sure. I’d sure appreciate it if someone could tell me if this is possible or if I’m barking up the wrong tree. Here’s the simplified use case: The business is a real estate brokerage. There are agents, agents have multiple transactions, and transactions have multiple documents. Agents need to submit and update transactions. I have built three tables: Agents - Agent ID, Agent Name Transactions - Transaction ID, Agent Name (linked to Agents) Documents - Documents ID, Transaction Id (linked to Transactions), Document 1, Document 2 (the documents fields are attachments) Via a form, Agents should be able to submit a transaction. That submission should create the Transaction record and the linked Documents record. As the transaction p

Hi, I’m trying to build a small booking system. I have a pricing table with different rooms (for now there are only two rooms) based on the tourism season. There are 6 different seasons with different pricing and min. stays (name of fields): price_high_season: date range(July 1 to August 31) (min. 7 nights) price_christmas_season: date range(December 24 to January 9) (min. 7 nights) price_easter_season: date range(April 16 to May 1) (min. 7 nights) price_shoulder_high_season: multiple date ranges(June 1 to June 30, September 1 to September 30), (min. 5 nights) price_shoulder_low_season: multiple date range(March 1 to March 31, April 1 to April 15, May 2 to May 31, October 1 to October 31) (min. 4 nights) price_low_season: multiple date ranges(January 10 to January 31, February 1 to February 28, November 1 to November 30, December 1 to December 23) (min. 3 nights) When I start to input a booking from a form in a ‘booking’ table, I would like to calculate the total price based on the

Hi! Case: I am making a booking form for a hotel that has different rates per night depending on the month. Problem: I can’t seem to calculate the total costs when the check-in and check-out are in different months. Possible solution: If I am able to generate the days between the check-in and check-out date, I could link those to a sheet where I have every day of the year with a corresponding price. Thanks in advance

I can no longer copy and paste data from one table to another, or from an excel spreadsheet into an Airtable base. The table contains only text, currency, and percentage fields, and I’ve been using keyboard shortcuts CTRL+X/CTRL+V. (Using latest version of Chrome on Windows 10.) I have tried going column by column, row by row, and single cells - nothing happens. When copy from spreadsheet, the data is being copied to the clipboard; when copied from Airtable, it isn’t. If I double-click a cell, I can paste into that single cell–not helpful for copying lots of data.

We use Airtable to manage all of our data. We use Constant Contact to communicate with people within that database. How do I regularly update (export) email information to Constant Contact when an Airtable email record changes/updates?

Hi, I have customers who create different accounts. Each account contains 1-4 members. Among these members, I want to sort their ages into different cells like “age 1-18”, “age 19-59”. “age 60+”. Not only sort them into the right group(cell) but also show ages as well. Is it possible? For example in one account has 4 memebers, ages are" 2, 21, 63, 76", so it will show like this: “age 1-8”: 2 “age 19-59”: 21 “age 60+”: 63, 76 how can I write a formula like this? Thank you very much!

I have a column with fieldtype = checkbox. Is it possible to select all and uncheck it for every/multiple records?

I’m using the popular script for downloading attachments from a url to an attachment field in AT, but I’m running into issues with the file typing. The url I’m using is a direct download link to an mp3 file in Box, and this script has worked on these files before, but in some cases rather than downloading the mp3 file, it’s downloading the html of the download page instead and loading it into AT as a text file. The file it downloads looks like it’s asking for Box credentials, but I’ve double-checked the links in Box and they’re all set to be downloadable with just access to the link, so it isn’t (or shouldn’t be) a permissions issue. Has anybody run into this before?

Hi, New to Airable here! We are a non profit with almost 50 employees running many projects at the same time and we are considering moving our timesheets (used to compile time per task per project per person) to Airtable. So far, as a test, this is the base design we thought of : An individual base for each person, where they can enter their own data and conditions are calculated automatically (vacation left, sick days left, etc.) and not see all the other’s - each of these bases is synced with a « Projects » base, so the information can be updated easily. Compilation of all the data in one base to get an overview of time spent on each project. Since for now, there is a limit of 20 sync tables with the Pro plan, what would be an easy way to sync 50 sources to one table? Or would the solution would be to go with a completely different base design? We would really like each person to have their own base to avoid mistakes though. Thanks in advance, Marie

How do you delete unused fields in forms so that they don’t show on the left-hand column? (See screen shot)

I’ve built a sample projects database that uses this script. It works beautifully. Now I would like to add a field from the Templates table (where the tasks are listed by the type of project) that has “duration” (number of days). If I can pull that in when the script runs and creates all the tasks for the project/parent, I will be able to create a schedule based on the project start date. Has anyone done this? I am not a Javascript person, but I think one would simply add maybe 4 lines to the existing script. I just don’t know what those might be. Thank you in advance!