Solved

Howdy, I have a database that deals with inventory for serialized items. For each item, I need to know when they have been found to be in-stock. Here’s what my setup looks like today: Records are items uniquely identified by a serial number One link-to field is Inv_Seen In which collects values each month that that item has been present for. As an example, one record will have been “Seen In: 2022-06” which means it was seen in June 2022. I manually type “2022-06” for each item. This setup is working fine, but requires a lot of typing the same exact thing over and over again Here’s my “dream” setup that I’d like help writing a script to achieve: Records are uniquely identified by a serial number One link-to field is Inv_Seen In and collects values… BUT… …There is ALSO a button field called Inv_In Stock? whose action is “Run Script”. That script will populate Inv_Seen In with “2022-06” (or whatever the month currently is. I am a-okay hardcoding the month value in the script.) for jus

Good morning! Does anyone have any idea what will happen to interfaces created for free accounts once they (the interfaces) are no longer in beta? I have a client with the Legacy Free plan and I don’t want to set them up with a bunch of interfaces unless they’re going to be able to keep having access to them. Thanks so much and rock on, Michele

I am new to Airtable. I am on free tier now. I have an extension to run a script - essentially for lookup. I am using a script for lookup as my base needs two conditions for reference and I cannot use the native Lookup functionality. My issue is that the script works perfectly for the first 15 records. The script stops working from record 16 onwards (I have total 29 records currently). To check whether there was anything wrong in records 16-29 that was causing trouble, I copied the base, deleted the first 15 records and ran the script. The script worked perfectly in the copied base on the remaining records (erstwhile record no. 15-29). I am quite perplexed. Can anyone guide me why is this happening. I checked if I had exceed the record limit. The total records across tables in my base adds up to ~600. Thanks in advance for helping

Is there a way to quickly see all of the different values in a field, similar to how you can click to filter on a column in Excel and see all of the possible options (similar to screenshot from Excel below)? As an example, I have a field that is mostly blank but has a few records with varied single line text data. I want to quickly see what those different single line text lines are to see if I want to filter on any of them, but they’re not consistent enough to make it a single select field. For another example, I have a field of various dates and would like to filter by certain dates, but don’t know all of the choices off the top of my head. Is there a way to quickly see the list of choices without creating a separate view or using a pivot table? Again, I could choose a type of ‘single select field’ but it doesn’t organize the dates nicely to see by year/month/day like you can see when clicking to filter values in Excel. Thanks!

Hi all Here is the challenge I need to solve - I track some small time investments for an investor club in companies. i.e. records are the company names (Apple, Netflix, etc.) Fields are James $ Invested and Adam $ Invested James invested $100 in Apple Adam invested $50 in Apple and Adam also invested $50 in Netflix I have a formula field that sums up the total amount invested in each company (e.g. Apple is $150 ($100+$50) and Netflix is just $50. What I would also like to do is link this to another table and have James and Adam as the Records and then show the total amount they each invested in aggregate (i.e. fields would be Total Invested, and for James it would be $100 and for Adam it would be $100) I saw this link below but it does not work for me since I have more than one field (James and Adam) linked to the same record (Apple) Airtable Support Find the sum of an entire field A core difference between Airtable and a traditional spreadsheet is tha

I got a notice from airtable. my records are over 1200. and I counted all records in each table in 1 base. (1 includes sync table from another base). my detailed questions are below. Is airtable import all records when I sync records from another base even if I filtered some records? Is there any other hidden things I need to know when I count records. I counted all current records and all synced records, but still 100 records difference between my count and airtable count.

I have 2 date columns that are only completed on some projects. I need this rolled up to show the MIN of each of these dates on another table. Arrayunique shows the value, but its not a date, its text. Any other formula like if value then min will only show 0. Essentially any time I add Min to the formula it is showing 0 because of the blank cells.

Good afternoon I am currently doing a personal nutrition project and I want to solve the following question: There is a table of products, and I want to check for a duplicate when a new record is entered, maybe such a product was already in the database I tried to do it through automation, and mark a duplicate, but automation does not work drive.google.com Untitled: Jul 28, 2022 1:10 PM.webm Google Drive file. Maybe someone else knows how to deal with entering duplicates in one table?

I am creating a base to keep track of a collection for insurance purposes. I have the list of items in one table and then I have a checklist of what I need for each item in another table all in the same base. I want to copy the items that are in the main table over to the checklist table’s main field dynamically. The main table is already a mile long column-wise, so I didn’t want to put the checklist in the same table. I thought about just using another view, but…it junks up my table, even though you can hide fields. Unfortunately, the type of field the primary field can be is severely limited, but it is able to be a formula field. So I was wondering if there was a formula that could use to dynamically copy/update the primary field with the items in my main table. For example, you can display items from another column with a formula field by simply using the formula: {FieldNameHere} Is it possible to “call” on another table? I only get one automation as well since I only have a free pl

Hi!! I am new to airtable(using it from last 6 days). I want to get notification whenever my partners add the data in a table but problem is that whenever they upload the data, they add more that 100 records in that table at a time and I got that same number of notifications. But I need this notification otherwise I have to check table daily whether someone has upload the data or not… So I just want a single slack or email notification if records are added on that Day/Hour.

Hello airtable community, I have a query, I would like to know how I can do so that a button can have more than one link when pressing and that activates a pre-filled form. I share images of someone who has been able to do this that I mention. in image 1 it shows that it has the gallery view and below is the button and it is marked when you click on the first button it sends it to the url with the pre-filled form that is marked in image 2, and finally when you click Clicking the following button sends you to another url in image 3 with the pre-filled form. Thank you very much for your time. IMAGE 1 IMAGE 2 IMAGE3

Actually, I have a field “School Name” that can contain duplicate values. There is a condition that the id should be the same for duplicate values. So how can I do this without taking the help of another table? if there is some script, please share as I am new to Airtable.

Hi All, i am using airtable with some of my clients and i set up some automations as well, e.g. for checkboxes like “approval” and stuff. Now that i am trying to setup interfaces i am wondering how i can lead a user to the interfaces. For example - i have a table with a checkbox which i am ticking myself for an approval of my own work - tthis triggers an automation and my client receives a mail where he is leaded to a record so he can approve it too. Unfortunately it always opens the original table and not my newly build interface. what am i doing wrong? Thanks in advance -M

Hey guys, I need some help and can’t find de answer for this! I have some projects and tasks, but each one have a kind of “weight” in certain steps, like: When a task is in To Do, it have a weight of 5% When a task is in Doing, it have a weight of 40% When a task is in Validation, it have a weight of 5% When a task is in Done, it have a weight of 50% When I sum all of them, the result is 100% I don’t know if it’s clear. I just want to do something like this /

Hello, I am tryig to setup automatic CSV import of our product catalog to Airtable. Every morning it should update in case there are changes in prices or stuff. I was able to setup the Make.com (Integromat) scenario to: Get the CSV from FTP Parse the CSV And I can even create new records in airtable sucesfully BUT We use our codes for every product (and it is unique). I amy trying to setup that it will “Create new” record if it doesnt exist and “Update” if it does. I am trying to use “Upsert a Record” in Make.com scenario. But that only let me to pair it with Airtable “Record ID”… which the CSV of course can’t have. Does anyone figured out how to pair the records by OUR id? (which is IN the CSV and also Airtable first column) Thanks! Matt

Hello! I’m working with a base that has a record of all our organization’s projects, and I’m trying to design a project-level dashboard where people can go in, select the project they want from the record picker, and see all the relevant info for that project. I have already set up the record picker and added some key project fields, but also want to include a timeline element based on key dates. To do this, I’ve tried clicking on Add element > All elements > Timeline and adding it to the dashboard. The problem is that this displays a timeline for all projects, and is not filtered to the project already selected in the record picker. Is there a way to link my record picker to the timeline element? I tried editing the filter on the timeline element and connecting the record picker as a filter element, but that doesn’t seem to be doing anything. Thanks!

Hello Airtable community :slightly_smiling_face: First of all, apologize if I missed something, I’ve tried to find a way -as usual- before posting here. This seems so obvious that I can hardly believe it’s not possible … or I am totally wrong about how to use Airtable ! A few months ago, when discovering AirTable, I separated things on multiple bases within our workspace. Now that I have a better understanding of our needs, I would like to gather various bases, adding new tabs … but from what I see, using “+Add or import” only allows to create an empty table or to sync data from another table. I can’t import an existing “tab” from another base. Sure I could simply copy/paste records, but doing this, I’d lose the views I set up for the tables I’d like to import. I’d need to do this all the more that I’ve recently discovered Image MarkUp extension, that we badly need, and it seems the only way to get what we want, is to get our various bases in multiple tabs. Thanks in advance for you

I keep attendance with airtable. I would like my clients to be able to request a copy of their attendance and see it automatically. Ideally they would go to a website link “please show me my attendance” and it would show them their attendance for a range of dates. Is this possible? If so, how? Thank you.

I am having trouble figuring out how to adjust my automation so that Airtable emails all of the attachments in a field versus just the first attachment it sees upon a condition being fulfilled. Sometimes there’s only one file to attach, whereas other times there are multiple files to attach. It takes time to upload all attachments, but my email is triggered faster than the uploads finish. Is there any way to ensure that the automation is triggered after a certain delay after files are uploaded? It needs to happen as needed (it cannot be scheduled for a specific time of day).

I’m working on a fun, friends and family base for recording daily quiz results (Wordle etc.). The idea is that people can use an iOS shortcut to parse their score and past it to an Airtable base using the API. The eventual goal is to build a friends and family league for these types of games and maybe use interfaces to display the league. I’ve got the shortcut working for the most part in so much as I have game name, the game #, date and number of attempts to successfully get the answer working. However I thought it would be nice to bring through the visual representation of the attempts - this is the bit normally displayed using emoji. For example… :brown_square: :brown_square: :orange_square: :orange_square: :yellow_square: :yellow_square: :green_square: :star2: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :arrow_up_small: :hammer: :star2: I was simply going to add these lines as a multi line text field in the base but I am st

Hello! I have a formula for a “status field” that keeps tripping me up. I have tried multiple ways and can get parts of it to work, but not all. Undoubtedly I’m a comma or similar away from the solution, but by now I’ve tangled myself so far in my own head that I have to admit defeat and humbly ask for assistance. I have the following columns that should be considered in the formula: {End Date} = Formula field {BiU} = Checkbox field {Last Shared} = Date field {Next Share} = Formula field What I want to achieve is: If {BiU} is NOT checked = ‘-’ If {BiU} is checked AND TODAY() is after {End Date} = :white_check_mark: If {BiU} is checked AND TODAY() is BEFORE {Last Shared} and {End Date} = :ballot_box_with_check: If {BiU} is checked AND TODAY() is AFTER {Last Shared}, but BEFORE {End Date} = :link: Any and all help would be greatly appreciated.

Greetings wise ones! I have a base to track family medical history which includes a Doctors table and a Dr Appointment table. All appointments in the Dr Appointment table are linked to a doctor in the Doctors table. This includes past appointments and upcoming scheduled ones. In the Doctors table I would like one field where the date of the next appointment is calculated and shown and one where the most recent appointment is calculated and shown. How do I write a formula/rollup that looks at only the past or only the future dates and chooses the last of the past or next of the future? I’ve created fields calculating the appointment dates from TODAY if that helps. Thank you!

I need to make a automation that will reflect the date I update a Status field on my table to ‘Filed, Letter Received’. These are the two ways I tried, but i’m not sure what I’m doing wrong in both situations. Please help?

I have sample db like this here i want to retrieve only Card colum for last 4 digit alone. I have used the below formula but it returns the whole data But i was success with other filterByFomula like searching InActive members from Status col like this Please help me to resolve

There doesn’t seem to be a way to create a new record with Interface Designer other than the button attached to the record picker. This is too bad because the record list is an elegant navigation element, but it’s redundant if you add a record picker pointed to the same table. And although there may be a good reason for this, they don’t sync. Also, unlike other elements, you can’t delete a record list, so it looks like I’ll have to create a new Interface from scratch. Someone please tell me I missed these. :fearful: