Ask the Community

Hello,I have a base where I keep track of projects and their status (in production, review, completed) organized in months. So, my tables look like: Jan 2024, Feb 2024, and so on.For monthly reports, I just grab information from a table (ex, Jan 2024) and create a interface. No prob there.The problem comes for QUARTERLY REPORTS, because so far I haven't been able to create an interface from several tables (Jan 2024, Feb 2024, Mar 2024). How would I go about to do so?Thanks, everyone!

I have developed an extension with specific business logic that I would like to release to multiple bases at once. I do not want to publish this extension to the marketplace as it would not be relevant to those not working at my company. Has anyone found a good way to release an extension to multiple bases at once? Or to release an extension to all bases owned by an organization?  Ideally anyone at my company could release the latest version of the extension to a base without much hassle.My current process is to follow https://airtable.com/developers/extensions/guides/run-in-multiple-bases to create the remote configuration files. Then I have a script that iterates through all of those and releases the current extension to that base. I could further automate the process if I was able to get the blockId without having to go to navigate to the base and retrieve that ID (reference post: https://community.airtable.com/t5/development-apis/how-to-get-the-block-id-fro

Hello! I've got an inventory board ("Print Products") that has hundreds of products (each with variable quantities). I add new amounts of each product regularly (in "Order Received" and "Products Received" for individual line items). When I sell items they go in "Order Sold" (with "Products Sold" for individual line items).The problem is, I move various amounts of various products between multiple locations. Sometimes they sell at a location, but sometimes they don't and I need to move unsold inventory around between locations. I created another table "Currently At" to try to keep track of how much inventory was at each location, but I'm finding it incredibly time consuming and tedious to input each quantity one line item at a time so that I can check in/check out the different quantities of each product. I was able to write an automation so that when I put something in "Products Sold" it automatically put it in "Currently At" with the correct quantity decrement. I can make forms

Hello!I have two fields that I want to meet certain criteria to return a value in another field.Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date field is empty have this field stay empty Thanks!

Hey I am trying to set up a formula for the below problem. I am provided with a list of names in the 'home' column and certain entries I need to change to end up like the 'bot name'. I have tried switch/If functions and I just get errors.  

Hi!I'm using an airtable base to calculate my working hours as a freelancer who works in live entertainment and I'm trying to figure out the best way to have a flexible system for different employers' rules for minimum paid hours of a shift, after how many hours before OT and DT, and also how some allow for DT after midnight. There is also the possibility with some for Sundays to be considered "premium days" regular time=time and a half all day. Right now there is a tick box per "shift" record that allows me to say this shift is "premium".Right now I have a table of "billing rules" with lookup values for each parameter.Each shift is linked to a "billing rule" record, and these values are lookups. The lookup values are then used to determine how many hours fall under each.The formulas to determine how many hours fall into each bucket involve a bunch of IF functions. If the billing rule is "flat rate" these hours are set to 0 and the total is overridden. Here is each:The total billing fo

How can I display a ratio between two values in interface (dashboard)?I have the field "hours" in a base.In the dashboard I want to display the number of hours last week divided in a static number.Like:All records from last week.Total amount of hours from those records.Divided in 8.Plot this on a chart so I can see progress over time. I'm OK to go through a new table in the base to solve the problem

I have two tables: 'Booked calls' and then 'CRM'.We are an agency that books calls on behalf of our clients. My booked calls are captured by webhook and linked to various other tables with KPIs. But now I want to build a CRM table for different clients, e.g. 'Client A CRM', 'Client B CRM', etc.How do I create an automatic link so that records coming into 'Booked Calls' are automatically added to the relevant client CRM?

DG mw me nahi hai na to be a great day hoga to be a

im accautn is Block support of the day is the best way to get

Hello, I am trying to create an automation using the Repeating Group option but I can't get it to work.I have a main table where I keep records of customer files. Each record has a responsible party that is linked to another table called "Responsibles," which contains the name and email address of each responsible party.What I want is for the automation to check the file records every Monday and send an email to each responsible party with a table showing their files.It is possible that a file may be assigned to more than one responsible party, so that file should appear in the table of the email for the different responsible parties.I have been testing this but I don't know how to configure it. Thank you.

Morning.We have a request that seems pretty common but searching the articles the info is a bit conflicting, so asking a fresh question.We have a base with data that we work with.  Think of it like a CRM.What I need is a way to set a view of data (state based) so that a user can only see the cases they are working on. That is pretty easy with a view etc. I also only want those users to only see certain fields from those people to not be able to edit the view or configuration of those fields. Except 2 fields which they are allowed to do a drop down on. Reason is basically to stop users from deleting or changing important data, or viewing other peoples data. Thats the main request. A lock down view for our users that they cant download, change, print, copy. they can only view . . except 2 fields that they can toggle. (our users are very basic).Second part of that, is I want them to have the ability to run one automation in that. A button that will send a locked down message to

I have a script set up to delete records when they enter a view. I fiound the script on this forum, it's:  let table = base.getTable("Field & Nursery"); let inputConfig = input.config(); let recordId = inputConfig['recordId'] await table.deleteRecordAsync(recordId); However, when this script runs, it triggers another automation. Update (I misspoke about how the automation works - amended here) The deletion is handled by:- If the record appears to need deleting, the status changes to a pending deletion status- A formula looks for records of the pending deletion status that are over x days old (depends on the kind of record) and outputs a "Delete" string (otherwise this field outputs nothing).-The automation looks for records that match "Delete" in the formula field.The script seems to behave in a way that the fields that are being watched "look" updated.However, because the script is deleting the record, this second automation fails. I assume there is s

Hello. I have just started playing with Airtable, and I have run into an issue. In SQL this would take but a second, but I cannot seem to figure out how to add this filtering. If you can help, I would be quite appreciative... TIA.The situation:1. I have a table called "Events". It records customer reviews of events that have happened.2. I also have a table called "Continents" (with 7 rows) and one called "Countries" with 195 rows. What I am *trying* to do is to have essentially a two-level dropdown list. I have added a field to the Events table that has a lookup to continent. That works just fine.The issue comes when I try to figure out what I'd *like* to do which is to set up a definition for the Countries table. I have added to the Countries object a field for continent which is a link to the continent for that country.The real problem is that I'd love to add the relation such that when I choose the continent for that country that I can then show a dropdown list which is the lis

Hi Airtable Community,  is there a way to auto assign tasks according to a single select field. I have a single select with multible Teams (CRM, Website, Social Media etc.). I want a new record to be auto assigned to the team lead of the team from the single select field. New records will be created with a form.  Best regardsMirko 

I am trying to connect with other application that asks me for my client_id, client_secret, api_token, and refresh_token.So far I have set my api_token,  client_id and client_secret, but still struggling with creating the refresh_token. Where should I find it? 

Hello!I saw an old conversation on this topic but was wondering if any changes...when sharing a template bases and interfaces go with it but not automations.  Anyone have a good workaround? 

Hello everyone,I am using AT for events.When I sell a ticket to my event it creates a record of the attendee.Afterwards I would like attendees to be able to fill a form with further details about their profile (eg. dietary restrictions) and whatever they fill gets updated in the same record.Currently I have 2 options:1. Attendee select their email from the form (lookup formula) so it stays in the same record but I don't want all attendees to have access to everyone's email2. I can use a 3rd party like Fillout form that creates a link but currently it is very glitchy.Are there any other options without using a third party?Thanks in advanced!

I would like to create a script that checks if my employee has already taken an advance on the same day. If it has already been taken, the new record should be deleted. I do this in the form. How can I get the current record ID from the form and delete it or add it if it was the first time. let table = base.getTable("Zaliczki"); // Zamień "Nazwa_Tabeli" na nazwę swojej tabeli// Pobierz dzisiejszą datę w formacie ISOlet today = new Date().toISOString().split('T')[0]; // Pobierz rekordy, które mają dzisiejszą datęlet existingRecords = await table.selectRecordsAsync({    filterByFormula: `IS_SAME({Data}, DATESTR(TODAY()), 'day')`});// Sprawdź, czy istnieje już rekord z dzisiejszą datąif (existingRecords.records.length > 0) { &nbsp

Hi all,I have a base table with the transaction history which lists each profile's contribution amount, date, and the fund invested. Each profile is allowed to invest in many funds and can also invest in the same fund multiple times. How do I create a view that would sum the investment total and sort by funds at the same time?Here is the transaction history table (base):I created a "List" from Airtable with Level 1 as Funds and Level 2 as Profiles, but I was not able to sum the values from the same profile:As you can see below, there were multiple transactions from the profile that starts with "2...." within the same fund

Hi,i am using python-requests and trying to use f-string with filterByFormula here is a simple implementation:hard coding the name worked:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', 'Content-Type': 'application/json'} query={"filterByFormula":"({full_name}="some name")"} response=requests.get(url, headers=headers, params=query) data=response.json()    but when i tried to use f-string it didn't work. here is a a piece of code where the problem occurred:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', 'Content-Type': 'application/json'} employee_name="some name" query={"filterByFormula":f"{{full_name}}={employee_name}"} response=requests.get(url, headers=headers, params=query) data=response.json()   {'error': {'type': 'INVALID_FILTER_BY_FORMULA', 'me

Hey,I have an automation that when the status changes to "done" an email is sent to the customer.Is it possible to send an email to the customer from the email of the user who changed the status?For example, if I change the status to "done" then an email will be sent to the customer from me, but if someone else from the company changes the status then an email will be sent to the customer from him.

Hi, I'm working with the Airtable API, and am noticing that the "list records" API endpoint is returning linked records in "cell format V1", while the Webhooks API returns values in "cell format V2". Cell format V1 is an array of strings representing record ID of the linked record(s).["recXXX", "recXXY"]Cell format V2 is an array of objects representing the record ID and 'name' of the linked record(s).[ { "id": "recXXX", "name": "Linked Record A" }, { "id": "recXXY", "name": "Linked Record B" } ] In my case, I really want to see the "v2" format in a 'list records' API call. Is there an API endpoint that will return this, or is there one planned for the future?

I’m building a solution for a client that may have around 80 K records… was thinking of breaking it up into multiple bases given that there’s a 50K record limit. However, they need to be able to search across the bases at the same time. I was thinking I could achieve this through a custom app that would allow them to do this search and return results from multiple bases. Has anyone tried this? Any suggestions on how best to do this? Regards, Ruchika

How can I search globally in all tables ? No the existing search app doesnt work. See the image below. it only search in the records in current base not globally. Please guide me whats the possible solution to this. Screen Shot 2020-09-17 at 10.53.07 AM