Ask the Community

Hi! 2 things…I’m trying to find a workaround so that when you being typing in the address field, the address starts coming up like in Google maps. I have the map extension installed and can not figure it out. From what I’m researching it’s not possible? Also, relating to address mapping… here is my other scenario…Im creating this for a cat rescue and we perform mass trapping also. While in the field and a cat is trapped is there a way to snap a pic, create a new record and in the location field have our location populate? thanks! 

Hi there: There are two records with to dates, I need to use the DATETIME_DIFF function, but it only works If I have the fields side by side, not in two diferent records. How can I work this out?

Hello everybody,For my personal knowledge, I want to create an automation to send emails in mass to the interlocutors but one email per person. I mean : 1) How do we automate to send an email to each of the freelancers? So in “To”, there will only be the freelancer concerned?In the Find Record, I wrote (See screenshot 1):Where freelance is not emptyand Status is "A rédiger"and date-publication is todayWhat I understood in human language: "Hey Airtable, you will do something when the Freelance field is not empty, so when there is someone to identify and the status is "A rédiger" and that 'in addition the publication date is for today'.Then I configured the email by saying (See screenshot 2):To: List of "freelance" and "List of Name".Human language: Send to the list of email addresses identified in the freelance field.Messages: "blablabla"...Grid of records: “post_idee” and “freelance”

Hi,I'd like to ask how many emails i can send through automation triggered send mail action.I've read other posts and threads but i am still confused with the wording of Airtable.it says I can send any number of emails to collaborators with verified emails.and also i can send email to 100 unique non-collaborator email address per day.In scenario, I send task notification email to "A" non-collaborator email address, and then sends task assigned email to "B", when "A" completes and changes the status, and if it sends completion email to both "A", and "B" then would it still count as 2 unique collaborator, and i still have 98 more unique non-collaborator email address room left?Just want to clear up this before i start mailing stuff through the automation.Thanks

Can anyone help me with how to use  useRecordActionDataIn the docs it is describing that it can be triggered when we open the extensionI want to perform oauth while opening the extensioncan anyone help me with this?

As others said, attaching facebook selfies to Airtable is not popular at work. But attaching sample pictures to records from web search *IS* one of activities enterprise customer employees do often.N-O-T a good choice. https://air.tableforums.com/t/web-search-in-adding-attachment-pictures-no-longer-avail-from-jan-30/1045

TIA - this community is amazing and so helpful when I can't get my head around these more tricky ones. but I am learning more and more! I have a bunch of method steps for our recipes:COOK THE SALMONPat dry salmon with paper towel, remove the skin and cut into bite size pieces, discarding the skin. Add salmon, olives and courgette to the pot. Simmer, gently stirring occasionally, for 5-6mins, or until the salmon is cooked through and all the veggies are tender. Remove from heat. Check seasoning. "MAKE THE AVOCADO DIPCut lemon into wedges. Halve avocado, remove the stone and scoop out flesh with a spoon. Place avocado into a third medium bowl and mash with fork until smooth. Mix in aioli and (1/2 tbsp/1 tbsp) lemon juice. Season with salt, pepper and more lemon juice

Hello, I have a DB ~15,000 records. I wrote a script to merge and delete records. It compares three data fields for duplications and combines the duplicate records. It also will merge data from two other fields if the fields are not empty. I tested my script on a 500 record DB and it works fine. When I test on a 2,500 record DB it times out. Can someone make any suggestions on how I can cut the execution time on my script ? I've seen posts about using a hash index, but I don't think that would work for what I want to do. Because I need to iterate through all records to find duplicates. If I'm wrong I'd appreciate insight.   var table = base.getTable('Testing_Dupes'); var query = await table.selectRecordsAsync(); //find records with a duplicate (first name, last name, residence) let dupli = query.records.filter((record) =>{ return query.records.find((potDupe)=>{ return record.ge

Hi Everyone, I’m working on a TV series, and looking for some online database solution for a really easy(-looking) task: I have to follow the realationships between the characters of the TV show during the script writing (friends/enemies/…etc - it can also be a simple list). So it means I make a list with the names of the characters I guess, and then I need to duplicate this list and somehow make a third list that contains the connections between them (it’s like a two dimensional graph). And then the second question: if the database is finished, how can I easily make the entries (we are talking about hundreds of character names). For example, I have two names in the list: “Joe” and “Bob”. I want to change their relationship into “friends”. I guess I will need some kind of combined searching form that looks for the two names and make me able the change the third data between them. Do you think I can do this in Airtable? Can you help me with this? Thanks,

Hi everyone, would you please tell me how to convert a multiple date string field (i.e., 2/11/2024, 3/3/2024, 2/19/2024, 2/25/2024) to the correct format date field that reflects all the dates in the string field? Please note that the string field mentioned contains the date values based on a lookup function from its source field or table. Thank you.

Hi there, Brand new to Airtable and have been messing around with it to see if it fits our needs. I’ve been impressed! One question I have yet to find the answer for is… Is there a way to process a submission fee payment as part of forms created through Airtable? As an organization, we collect a small application fee. While I assumed that Airtable’s integration with Stripe/Paypal would make this easy, I have yet to find a way to do so? Any help or potential workarounds would be appreciated.

I'm trying to build an IF Formula that seems like it would be straight-forwarded, but is proving to be more complicated than I thought it would be and has got me stumped. Both fields are Lookup fields getting a Rollup value from another table. I started with a basic IF formula, but the problem is it resulted in X $0 values being replaced by the Y value, when I wanted the $0 X value to be returned.IF(X,X,Y) Then I tried to a formula to say if X is equal to or greater than 0, and that worked, but it would not return Y if the X Column was blank. IF(X >=0,X,Y) So, I tried an IF / Or Formula. It still returned the X field correctly, but did not return the Y Fi

I have a fairly niche-type issue that I've not been able to figure out; for context, I've created a check in base optimized for a team of supervisors to check in/out staff using the Airtable mobile app. I have 2 tables linked together, where one represents 1 record for every shift (named "All Shifts"), which is linked to a table (named "BA Data") that houses the staff info of whoever is scheduled for a shift. I would like for my Supervisors to be able to open the linked record (aka "BA Data") while looking at the "All Shifts" table and be able to modify a "Current Location" field and a "Lead Notes" field (both are housed in the "BA Data" table). The navigation to do so seems to work just fine, but when a user opens the linked record from the mobile app, it appears that the Sort is defaulted to newest to oldest fields, in the order they've been modified; I know this because when I converted the oldest field to "Current Location" in order to bump it up to the t

Hello,I would like to ask whether is possible to copy linked connection between two tables with automation?I have three tables:1. Summary - here I would like to collect prices from Payment and VAT from Invoices2. Invoices - here are list of invoices, each has at least one connected Payment.3. Payment - list of payments with specific pricesIn Payment table I manually connect each payment to specific Summary.What I would like to do is automatically create/update Summary field in Invoices table with same linked connection as I do with Payment, so in Summary table VAT can be calculated. I tried it with automation, but probably I have mistake somewhere in the action..Hope I explain it clearly, here is link to my sample base - https://airtable.com/apphUNbqkv8pD

Hi all, I'm working on a donor management system for a non-profit org.  Donors make pledges to give $x on x recurring basis, usually something like $50 a month.I've got a table for Donors, one for pledges, and one for donations.I need to have a way to check whether pledges are being fulfilled by donors.  So if John Smith pledged $50 a month, has he actually sent $50 a month?But how do you search for what's NOT there???  I am stumped on how to approach this one!Any thoughts???

Hi Everyone,I've been using Airtable as an event registration platform for several years.I am seeking assistance in building a new event registration base where the registration form is linked to another Airtable base so that people attending previous events don't need to retype registration data such as email address, company name or pictures. The trigger can be the name of the person.I am looking forward to hearing from you.Zoltan

HiI have two tables Customers and Orders.  They are linked on CustIDI want to be able to find the latest order date (Order Date) for each customerAny ideasThanksMike

I have a table where different group clients submit weekly weights on a form.I'm calculating "starting weight - weekly weight = X". With each submission, I send them an automated email that records what their weight loss is, BUT even though their weekly weight loss differs, I want to only send them the max weight they've lost of all the weeks submitted.e.g. starting weight - 200lbsweek 1 submission = 194 (6lbs lost)week 2 submission = 196 (4lbs lost)week 3 submission = 197 (3lbs lost)So their record will continue to pull only the "194 (6lbs lost)" until a higher weight loss is submitted. How do I do that? The rollup fields are not working for me - or am I missing something! The current rollup field is reflecting all 0 but there are no zero entries.

HiIs there a way to know how many API calls I've already made this month, and how many API calls I have left?

Hi everyone,I'm new to Airtable and I'm trying to automate the process of updating fields in a primary table based on records filled out in a secondary table. Both tables share the same ID for each record. The primary table serves as my master record, while the secondary table contains five fields that will be completed via a form. I'm pre-populating the ID in the form to ensure consistency across tables. However, I'm struggling to find a way to automatically reflect the updates from the secondary table in the master record table as soon as a new record is created. I feel like there should be a simple solution, but I haven't managed to figure it out yet. Any advice would be greatly appreciated!

Hi all, I have DB on airtable and softr is processing the data and displaying as needed. My next step is to push the displayed images to Pinterest, but when I try to add the URL of the product page from Soft to Pinterest I'm getting this errorURL: https://shop.engroovers.com/tribesigns-products?recordId=recr9Wkxlqh0kM7H9"No images found. Remove any tracking parameters in this URL to try again."I understand the that the record ID is coming from Airtable but is there any way I can modify it to show the image when added from URL?Kindly let me know. Thanks.

Hi there! We have the code below but it's not working. I'm not sure why.<template><div><iframe:src="link"style="height: calc(100vh - 1px); width: 100%; border: none"frameborder="0"></iframe></div></template><script>import Airtable from 'airtable'const base = new Airtable({ apiKey: process.env.airtableApiKey }).base(process.env.airtableBaseId)export default {name: 'IndexPage',data() {return {link: '',}},async mounted() {try {this.link = await this.getLink(this.$route.query.locationId)} catch (e) {console.log(e)}},methods: {async getLink(locationId) {try {const record = await base(process.env.airtableTableName).select({ filterByFormula: `{location_id} = "${locationId}"` }).firstPage()return record[0].fields.share_url

When an interface button is used to trigger an automation, does it leave any kind of trail in terms of date clicked?I am making an interface for a staff member to generate a draft contract, but she needs to do it only once. Since the button is so easy to click, I am afraid of it being generated multiple times. I thought I could somehow put a field showing below it of the date the automation ran. Thanks!

I want to separate the following text in different columns :Column A : @Ben11//test-bug//Feb 22, 2024 3:54pm UTC//Budget//Test again//Test again//ModerateColumn B : @Ben11Column C : test-bugColumn D : Feb 22, 2024 3:54pm UTCColumn E : BudgetColumn F : Test againColumn G : Test againColumn H : Moderate

HiI am currently developing. a custom extension.I want to do external authentication on adding the extension.How can i do this?.Should i have to configure the the authentication url and token url somewhere for airtable to do external authentication or should i have to do it manually.please anyone help me with this...Thanks in advance