Ask the Community

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

We dont have URL shortener? Any free workarounds, formulas, links? Tnx!

Hi everyone - I have a Airtable based that hosts events across states. And another base that hosts emails and location of users. I'm trying to create an automation that send emails weekly event reminders to users based on the event location that matches the users chosen locationsIn the email list base - a user can input multiple location based on their preferences. In the event based - events are listed based on state. I think I should be doing the automation in the email list and link that to the event base. I hope to send a list or grid of event to X user name and email. I was able to setup the first half of the automation using find records but not sure how I can automatically send the emails with limited manual work. could someone please help me out? Happy to share my base to assist 

Is there anyway to do a sum of averages within a selection using the number boxes?Bottom grey number on the left is what I'm trying to tweak.  Over the last 12 months, I've sold 663 units for a total of $4,107,840 (bottom two green #'s).  I need to sell 118 more (top grey #).  Ideally, I want that bottom grey box to not show me the average per, but a sum total of the averages.  So $4,107,840/663 = 6196 * 118 = $731,128.  Any one have an idea on how to get there?I thought maybe build that value into the base itself somehow, but I'm having trouble running sums within the individual records so they all return the 6196 value in real time (or close to it)...

Hello AirTable Community,Here's a fun one that I hope I can pick some brains on.  We have a Workday integration that creates an employee directory that feeds quite a few bases. With the Workday integration, we have to use a unique identifier - that being employee ID. However, employee IDs are not regularly used in our company so many do not know theirs. When filling out a form, they would typically use the employee name, which is not the primary field in the Workday integration (because of the unique identifier requirement.)Is there any way, via automation or some other method, to have the linking record be the employee name instead of the employee ID? If not, has anyone made a successful automation that would switch these columns after each sync with the Workday database? This has become quite a big blocker for us, so hoping someone has an idea of how this might be accomplished. 

Is it possible to limit the options for a single select field in an interface form? i can definitely do this in a regular airtable form. but i can't seem to figure out the way to do this in an interface form.example: single select fieldOption 1Option 2Option 3Can i make the interface form only offer them the choice of Option 1? or only Option 1 & Option 2, but not display Option 3 as a choice?

HiIm trying to work out a fix for an issue where the automation is searching for empty records of a column and emailing the relevant editor. The issue that comes into play is that it will find say 3 records of one author and add their email in 3 times instead of just once ? Im not certain that I may need another logic step added in?    

I have a URL field that I need to grab specific text from (in bold). Does anyone know if there is a formula I could use to easily grab just the string in bold without pulling in additional data from the 3 possible formats?Here are the multiple formats that the URL could be in:Sample format 1:https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9ASample format 2: includes ?ABC=1 at the end https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1 Sample format 3: includes 2 URLs only separated by a spacehttps://www.website.com/en/others/A1087A50-AB7

Hi everybody,How would you go about sending an image from an Airtable attachment field to an image field in a Webflow collection item.I have set up a scenario in Make using a webhook. Works great so far for all the text based fields, checkboxes, etc.But I can not figure out, how to pass on the required image URL, so I can map it in Make.Does anyone here have make scenarios with images running?Thank you for your help!

Hoping someone can help me.  I'm sorry if this is not in the correct section.  I'm new to this and not sure of what to call most things.   I'm a crafter and i'm trying to use Airtable to keep an inventory of my craft supplies.  I have imported data from a different system, and have titled the column that contains the URLs for the photos  as "Image" and defined it as URL.  However, i can't get the images to populate.  I wrote an email to airtable asking for help, and although i keep replying to emails saying they're busy, with i want to wait, it's been well over a month and i still don't have a response.  I have tried looking up on the internet in various places, and have found issues the same as mine.  However, the fixes they show apparently are from a different version of airtable than is currently available, as many of the screens they show have different options from what I see, and i have not been able to equate the old to the ne