Ask the Community

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

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 watc

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 c

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];&nb

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=heade

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

Hello! I’ve just come across Airtable and was experimenting with it as an alternative to Google Sheets. My question is, if my application requires multiple databases, can string searches be performed across them? Thanks, B

I need to search records in multiple databases and if the search result is not empty then set a variable for that particular organization. I will then compose an email using non empty variables. Scan Airtable A base, if the output is not empty, set the variable Clinic A to results. Scan Airtable B base, if the output is not empty, set the variable Clinic B to results. Compose email that includes non empty variables: Hi John Smith, Please submit the following items: Clinic A variable (has value - not empty) [Clinic B variable is not included as the variable in the previous scenario was empty due to no search results) Can’t figure this one out as Integromat requires everything to go in a flow as I am using filters to filter in or out empty search results. But if search results for variable A are not passed then the rest of the flow does not happen.

Hey guys, I host my own pub quiz and since I’ve done around 80 of them I start forgetting and sometimes I add question I had before. I’m looking to make a database which I’d update after each quiz so I can quickly search for keywords or answers. This tool does seem really useful and I’m willing to explore it. Now I’m curious if I’d be able to somehow search for the answer across all the different quiz tables I make? Thanks for your help! Screenshot_1|690x201

I’m setting up a new base for my construction company. Would like suggestion on best basic structure. We will only do 3-5 jobs a year. What is best layout of tables for grouping Bids, Tasks, Production Schedules, Job Cost Estimate, Job Budget tracking. I guess my question is how do I best structure so I can view individually for each of these and also combined across all jobs for everything except budget and estimates?

Is there anyway to change the text alignment for long form text to be left justified instead of right.  See screenshot.

Hello....I need to automate a record when its status changes and reply to the original email (attached msg format into each record) to the sender with some editions. Has anyone tried this? 

Hi, I was wondering how does the 10 login badge work? Or is this effectively broken?

My text fields imported from excel have a question mark where an apostrophe should be.  Is there a simple formula to correct this?

Hi There, It seems that there is no way to call directly an external API to a record on Airtable. My goal is to be able to shorten URLs (using Bit.ly API) in my database. I was wondering if there is a way that scripts might be able to help? Here is Bit.ly API reference : https://dev.bitly.com/api-reference I appreciate any help on this subject. Thanks