Solved

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:

Hello community, I’m using an Airtable form and Make’s (formerly Integromat) Airtable module “Watch responses”. Every submission trigger the hook twice within 5-6s. Has anyone experienced this or an idea of how to avoid the duplication? Thanks!

Hi folks, I’m using filterByFormula param to filter records of a table but I’m able to select for a specific date. Below and example: request: https://api.airtable.com/v0/appFOOBAR/Spese?filterByFormula=AND({Importo}=111.22,{Data}='2022-04-01') response: { "records": [] } while with the request below I got a result: https://api.airtable.com/v0/appFOOBAR/Spese?filterByFormula=AND({Importo}=111.22,not({Data}='2022-04-01')) response: { "records": [ { "id": "recXXXX", "createdTime": "2022-05-24T09:38:50.000Z", "fields": { "Tipologia": "Spesa", "Data": "2022-04-01", "Importo": 111.22, "Name": "Prova 1" } } ] } so the example using not operator shows that there’s a record with Data=2022-04-01, I don’t understand why this record isn’t extracted using the first request.

I want to make formula that tells you in what Season we are. I have the seasons divided as follows: Summer = July-Oct Spring = Mar-June Winter = Nov-Feb I have a column which shows the number of the month we’re in with help of the formula MONTH(TODAY()) Then in the column next to it I made a nested IF statement which should determine which the season we’re in based on the division I set above, but it’s only showing the season ‘Summer’ when the month column has a number between 7 and 9 (July-September). With the other month numbers it show no result (i.e. a blank cell). Here’s the IF statement I’m using: IF( {Current Month} >= 7, IF({Current Month} <= 10, 'Summer', IF({Current Month} >= 3, IF({Current Month} <= 6, 'Spring', IF({Current Month} >= 10, IF({Current Month} <= 12, IF({Current Month} >= 1, IF({Current Month} <= 2, 'Winter') ))))))) It would be great if you could help me out. Thanks in a

Hello, I use the timeline view on this table to manage my rentals : in the column “Grouped By” I have all my chambers, and each record is a reservation. The chamber are Cottage 1, Cottage 2… until Cottage 20) But, when sorted A-Z, it do not includes the numbers : Instead of : Cottage 1, Cottage 2, Cottage 3, etc… I have : Cottage 1, Cottage 2, Cottage 11… What can i do to sort the column “Grouped by” from A-Z and 1-9 ? Thanks.

Greetings Airtable Community, Several weeks ago I received great assistance with a formula quandary involving the combination of two multi-select fields: {College(s)} & IF({Department(s)}, " and " & {Department(s)}) This formula assumed that the {College(s)} field would always be populated. Unfortunately, as we’ve progressed, I’ve discovered this will not always be the case—there will be rare instances were the {College(s)} field will be empty. In these cases, the formula returns: “and Athletics” instead of just “Athletics.” Is it possible to adjust the formula so that it will return just the name of the department (i.e. the " and " will not appear)? Thank you very much!

Hi, I want to query and filter a table based on several filters sent via the URI as parameters. I found the Airtable API doc suggesting that I use the AT API encoder and use FIlterByFormula. I tried it and it all works perfectly. but for only one formula. meaning it only works for one column. but I have around 8 columns I want to query. How can I add more than one FilterByFormula in the URI? If the URI Looks like this: “https://api.airtable.com/v0/app0uHEtrxyWp3uzn/tbl1MB1FIAfGmnX4I?api_key=NULL&filterByFormula=REGEX_MATCH(Socials_Lookup,‘Instagram|Twitter’)” how can I make it like: “https://api.airtable.com/v0/app0uHEtrxyWp3uzn/tbl1MB1FIAfGmnX4I?api_key=NULL&filterByFormula=REGEX_MATCH(Socials_Lookup,‘Instagram|Twitter’)&filterByFormula=REGEX_MATCH(Parent_Category_Bubble,‘Animal|Food’)” And keep adding appending to it, This is me testing it on Postman. When I try to add more than one Formula:

Hi everyone, maybe its not a new question, but apparently i couldnt manage to find the answer :slightly_smiling_face: I m trying to et a Single Select field by ticking a Checkbox field in the same table, so in my understanding it has to be something like: IF Checkbox ticked THEN set Single select field to Value I am trying to automate following function: IF my client is ticking the checkbox for approval - the task should automatically set the Single select field to ARCHIVED. Anyone a idea. THANKS in advance. -M

Hello, I want to be able to import transactions from Quickbooks, and link those transactions to a Client record from another table (Clients) in the base (relational). The first issue that I ran into was having an automation update multiple records at once. It seems the solution to this is a script. I modified one that seemed popular here to the following: let config = input.config() let records = config.QBRecords //.step2Records must match the Name field of the input field. let table = base.getTable("Quickbooks 7-14-22 YTD"); // Replace with your table name. for (let record of records) { await table.updateRecordAsync(record, { "Client": [{id: config.clientRecord}] }) } However, it’s throwing an error: “Error: Field “fldOyEuNcD7vGj42h” cannot accept the provided value. at main on line 5” Can anyone help with this? I have a feeling it’s something dumb… but I can’t seem to fix it. Thank you in advance. Script: Automation: Quickbooks table: