Other Questions

So I’m trying sync some records from one base (base 1) into another (base 2). Base 1 contains my inventory, base 2 contains my service records FOR that inventory. I can’t have them in the same base due to record limits. My idea is to have two tables in base 2. Table one will be a sync back to my inventory, so as I add or remove units the sync takes care of adding them/removing them for me. Table two in Base 2 will contain my service records themselves, and through a combination of formulas and lookups in Table one, I’ll see the information I’m after within Table one. Primary field in Table two is just an autonumber, so that way the second column can be a linked field back to the inventory in Table one. This is where I’m running into issues. In base 1, I use a concatenated formula for my primary field to pull in location #, year, make, model, etc. as an easily findable and searchable value for a few other processes we have. So when I sync that into base 2, that concatenated value

I’m trying to work this one out but I don’t have sufficient coding experience to really crack it. I’m looking to generate an image into a dedicated field, based on a record’s {firstname} {lastname} fields. Examples of code to do this are here: javascript - How do I set profile image as first letters of first and last name? - Stack Overflow Can these easily be turned into a script? If it isn’t possible to create an image file, generating unique embed codes per record might be just as useful.

i made a mistake and generated a new link to a form. i want to go back to the old link. i tried restoring a snapshot, but the links to the form are new each time, instead of going back to the snapshot of the previous form. is there a way to restore back to the previous version of the form, including the link? or is it gone forever? thanks!

Hi everybody! I could use some advice. I’d like to use Airtable to manage my company’s SKU database, but I’ve run into an issue that I can’t seem to figure out. Hopefully it’s an easy one. I’ve created a SKU base and, within it, the following tables… SKU_Images (with columns for SKU and a checkbox indicating whether an image exists) SKU_Allocations (with columns for SKU and then the number available for each) SKU_Merchandising (with columns for SKU and the stuff like product name, product price, category, subcategory, etc.) Let’s assume those would all be updated regularly by either importing CSVs or just copying and pasting data. All good so far. I’ve also created a table for SKU_Marketing. Whether or not we market an item depends on whether it’s available (referencing SKU_Allocations), whether it has an image (refencing SKU_Images), and whether it matches the categories we’re promoting this week (referencing SKU_Merchandising). So my SKU_Marketing table includes columns for SKU and t

Hi all! I have a table of records that has a few hundred entries. These entries essentially connect two tables, the “Websites” and the “Elements”. In my main table, I connect those two reference fields to each other and have for example: Netflix (website) | video player (element). What I’m looking for is a way to be able to count how many times those two combinations have been used with each other. If you can imagine, I’d have 10 different records of different versions of Netflix + Video player, so I need to be able to have a formula with something similar to {websites} & " - " & {elements}, count up. End result should be something like: Netflix-Video Player-1 Netflix-Video Player-2 Netflix-Video Player-3 etc. Keep in mind, there are many different website names, and many different element types. So each website + element should be able to be counted for individually. Let me know if that makes more or less sense! Thank you :slightly_smiling_face:

Hi, we are an event organizer start up firm based in India, our core work profile is creating event program and updating same on website. With airtable we came across the possibility to embed data(program) to website directly in a reactive way. However, from past few weeks we are constantly struggling to create a mobile optimized website with iframe code generated for airtable view. The problem is that when we try to embed card layout for grid view(which is strict preference) with 5-6 field values, the program on mobile shows only 4 field values and to view other we need to expand record which isn’t user optimized, so requesting the community to kindly help us with some valuale inputs. thanks in advance

Hello, we have a “Pro” plan for our bases. I have a base that has a table with 3 sync sources (all coming from other bases on the same Pro account). I’m planning to have at least 5 more syncs to take place for the same table and when I’m trying to add a fourth one, I get the error below. However, In one of the threads I read that the maximum is 20 per base/table (which I have not nearly reached When I “request”, the notification comes to the owner of the account and there are no next actions, as we already have the “Pro” plan. Upgrade to add more sync sources This table already has 3 sync sources. To add a new source to the table, contact your workspace owner to upgrade your plan

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.