Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
A
Antoni_IsclaNew Participant
posted in Other Questions
Parking Lot Reservations

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

122
JonathanBowen
A
Archie_TimosencKnown Participant
asked in Other Questions
Synced records within one table? O_o

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!

145
A
B
Black_Isle_GardNew Participant
posted in Other Questions
Selecting specific dates within a table

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

31
A
T
Tarah_KendallParticipating Frequently
asked in Other Questions
Formula for returning another column's date in the current year?

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?

60
Kamille_Parks11
S
Shashaank_JaiswNew Participant
posted in Other Questions
Failed, reason: connect ETIMEDOUT 3.209.185.206:443

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

80
S
S
Simon_WarrenParticipating Frequently
posted in Other Questions
COUNTIF Function across Row Data

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

4191
W
C
Christopher_LeaNew Participant
posted in Other Questions
Using a different column as a name for calendar event

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.

61
X
H
hdkstrNew Participant
posted in Other Questions
Emojis are presented as text (:emojiname:) instead of showing the actual emoticons

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

30
H
M
Marc_Justin_RaiKnown Participant
posted in Other Questions
Syntax Error wordai

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) }

4219
M
I
Isaac_SRNew Participant
posted in Other Questions
How do I see the answer to a question that has been "closed after the last reply"? Sometimes replies aren't anywhere in the discussion thread!?

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?

32
I
R
Richard_PriceNew Participant
posted in Other Questions
UseCase: Is This Possible With Airtable (And Only Airtable - no extensions, if possible)

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

42
ScottWorld
G
gregoreNew Participant
posted in Other Questions
Returning Total Booking Price based on Seasonal Pricing

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

30
G
W
Wessel_van_der_New Participant
posted in Other Questions
Use date-fields to calculate rent costs

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

133
G
D
D_AustinNew Participant
posted in Other Questions
Copy/Paste not working

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.

1383
Justin_Barrett
A
Airtable_AdminiNew Participant
posted in Other Questions
Keep Constant Contact Up-to-Date

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?

471
ScottWorld
T
Ting_ZhengNew Participant
posted in Other Questions
Show other two cell's result in one cell

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!

00
T
G
Graig_StettnerNew Participant
posted in Other Questions
Can I mass-uncheck records?

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

401
E
A
Alyssa_BuchthalInspiring
posted in Other Questions
Url to attachment script downloading incorrect file type

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?

20
A
M
MarieHCNew Participant
posted in Other Questions
How to sync 50 bases into one table?

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

111
Justin_Barrett
A
Airtable_AdminiNew Participant
posted in Other Questions
Delete Unused Fields in Forms

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

151
Ben_Young1
L
Leah_GoodNew Participant
posted in Other Questions
Adding fields to the "Create records for multiple templates" script

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!

00
L
E
Emily_GOLDMANNew Participant
posted in Other Questions
Header Image in Gallery View

Hello, Is there a way to add a header view to the entire gallery view. Not just like for each card - but like our company logo to the whole gallery view? Thanks!

21
ScottWorld
T
Tim_McJunkinNew Participant
posted in Other Questions
Adding Outlook Mail Message to Airtable database

Hello, I can created an applicant tracking system with airtable. I am trying to add interview feedback from multiple panels to a candidates record. I tried saving an email chain from outlook and uploading as an attached to the candidates record on airtable but that didn’t see to work. Is there another way around this or better way to do this?

00
T
B
Bethany_Law1New Participant
posted in Other Questions
Anybody else suddenly not able to add new records unless you're an "owner"?

Suddenly, only our “owners” can add new records in one of our bases. Editors, creators, etc get a lock icon. Anybody have this problem or know how to fix it? I’m awaiting a response from support.

792
B
S
Stefan_WNew Participant
posted in Other Questions
Combining data from different tabs (like VLOOKUP) with same primary key

I have a question and I was trying now to find a solution for a few hours. Problem (simplified): I have a few tabs: One with the list of all stores (imagine these are thousands of stores) And for each month I have an excel with the store name and the revenues I would like to “import” the revenue data from the “Revenue 2022-01” and “Revenue 2021-12” sheet into the “Store overview” sheet. What would be best way? Do I really have to use the “Link to another record” and duplicate the name of the store each time? There must be a better solution… :slightly_smiling_face:

31
Ben_Young1

Badge winners

Show all badges
Terms & Conditions