Solved

I have an automation that is sending a payment receipt to a client The document of the receipt is in an attachment field of my base and I want to attach that one file to my Gmail using the native Airtable automation.Please see my Loom below for details.https://www.loom.com/share/635ea73ecb1b46b390f91e25fcedf0a6?sid=3b203e01-804c-4550-831f-abac3537c332

Hi,An erroneous automation setup has cost all my automation credit all 50,000 in a fee hours.  Hoping to get it temporary increase in credit to run our business function.  All our workflows have stalled. Need urgent help. Much appreciated  

Hi, With the new interface features, is it possible to share an interface with a lead/client for that person to add and edit a new record (with access to his/her own record only)? I want to use one or more calculators as lead generator tools, and also as tools for clients (who are not Airtable users themselves). Is this doable with the pro plan, without extra costs for each person using the interface, and without third party apps?

Hello guys, i have a table where i calculate some values which can also have a Zero.That means that i sometimes get 3/0 which leads to a Nan error.I already tried a couple of formulas but i do not get it. So my question right now is how can i put the cells which would have Nan as a value to 0? I would be happy for a solution. Thank you.

I have a linked record field in my table (Table A) where I disallowed the linking with multiple records from Table B. However, when I duplicate a record in Table B that is linked to a record in Table A, the linked record field in Table A gets 2 linked record, even though the linking with multiple records is still disallowed. How can I prevent this to happen?

Love the new List View - really useful.BUT - is there a way of removing the "Level 1" text in interface designer?  See screenshot.  I just don't need it and it would be confusing to users. 

Hello you!I'm looking to remove 2 characters of fields, from the right of the cell. I have a list of prices, like that, no currency :1570197401549I'm looking to get this :157 Є97 Є15 ЄThe deleted numbers are the cents 🙂Cheers! 

HelloI've managed to create a formula that adds x number of days to a start date and pushes the result to a work day if the end date is Saturday or Sunday:IF(AND({Direction start date},{Number of days},"days"),WORKDAY({Direction start date},{Number of days}),"days"),{Number of days})The result seems to work fine, however the formating isn't great as the answer is is like this 2023-06-02T00:00:00.000Z .  I've clicked the format option but that doesn't let me do anything.  Any suggestions would be gratefully received! 

I'm sleuthing but not getting anywhere - would be grateful for pointers for the following which is the crux of my business.  Is this an automation? Or a script? Should I start looking at Make? Thank you so much. Table A - Long List of People (500+)Table B - List of One-off Events (500+)How best to create Table C - Shortlist (50+) people going to 1 event?I've seen the Event Tracking Base and understand the connected table structure but there are so many People/Events and wondered if, instead of manually typing the person or event into a field, I could go to Table A, scroll through and tick let's say 50 people to go to 1 event in Table B, and have that create a new separate line item record in Table C that I can then use as a lead to chase (without creating duplications if they are already on the list)  

I am new to Airtable and having trolled the site, youtube, internet and anywhere else I could think of have been unable to find a solution.Is it possible to create a customised user friendly data entry form to my own design? Instead of a set piece format.Many ThanksBruce

I have a script that runs in google apps script and deletes all the records in a airtable table one by one, since I am new to coding and don't know how to code can anyone help me to modify the script to delete the records in batches of 10. I used chat-gpt to generate the script.The script that deletes airtable records is:function deleteRecordsInBatches() { var airtableApiKey = "API_KEY/ACCESS_TOKEN"; //Paste your apiKey or accessToken here var baseId = "BASE_ID"; //Paste your baseId here var tableName = "tab3"; //Paste your tableName // Number of records to delete in each batch var batchSize = 10; var tableUrl = "https://api.airtable.com/v0/" + baseId + "/" + tableName; var headers = { "Authorization": "Bearer " + airtableApiKey, "Content-Type": "application/json" }; // Fetch the initial set of records var recordsToDelete = fetchRecords(tableUrl, headers); while (recordsToDelete.length > 0) { var batchRecords = recordsToDelete.splice(0, batchS

Looking over the API documentation, it appears that attachments require a url key, so they must already be available on a web server. Is it possible to upload local files to Airtable via the API? I’d like to build my own form that POSTs to Airtable and uploads an image as an attachment, but it doesn’t look like this is currently possible. Am I missing something? Thanks!

HiI have in my AirTable a list of Names. Lets say I want to find all results with last name "brown". I am making a search for people with formular like this:filterByFormula: LOWER({TABLE_ID})="brown"How can I do it that if I search "bro", or even "own", it will also send the result of someone with name "brown". Meaning I want to receive when the String contains the seach word, not just when its an exact match.Thanks

Hello! New to Airtable. Trying it out to see whether I can use it for a specific need I have. Scenario: Our community (of around 500 members) have a shared google sheet having each of our basic details. I have imported that to a airtable base. Question: Can I set the permission on the base such that (i) all members can view the table AND (ii) each member of the group can edit their row?Thanks!Varun

I’m new to the scripting block and can’t figure out if it is capable of doing what I’m looking for. We have a table in our base that pulls in client responses from an intake form and adds them to the client’s already existing record. The intake form has a set of questions that are multiple-choice (multiple select) or single-choice (single select). Right now, we use these fields to match our clients with a coach based on their responses in those fields. The coaches’ records are in another table within the same base, with identical multiple and single select fields. We manually filter the table with the coach’s records based on the responses from an individual client’s form to find possible matches for them. So for example, if the client responds in the intake form that they like a direct communication style, I am filtering the coach’s table for coaches who are “tagged” as having a direct communication style. We filter based on 7 fields, or criteria, to narrow it down. Can scriptin

HiI have 8 fields with numerical values and I want to create a "summary" in a new field, which would show per each record which of those 8 are the 3 top ranked fields (name_field&value). Is that possible?Thanks   

We've built a ticket management system and every ticket has a "Status" and "Assigned To" field. I'd like to send a Monday digest email that lists all tickets "Under Review" - but send as separate emails to each person who has been assigned a ticket and show just their ticket details. I was able to start with this article, but this automation only sends 1 email, which I can send to everyone listed as "Assigned To". https://support.airtable.com/docs/how-to-create-email-digests-with-automationsIn the To field, I've put the List of Emails from Assigned To found. This produces a result like "Name 1, Name 1, Name 2, Name 3, Name 3".Instead, I want to send individual separate emails to each person, showing just their tickets. Is this possible? 

I have a script that retrieves data from a google photos library using google apps script and writes the data to a airtable base, I have no coding experience and have generated the script through Chat-gpt. The script retrieves all the album names and the number of photos in each albums.          What I want to achieve is that a script should delete all the existing records in the specified base before writing new records to it, using google apps script. Can someone please help me by modifying the script for me?Here is the script that i use to retrieve data from google photos library and write the data to an airtable base: function syncAlbumData() { var apiKey = "apiKey-accessToken"; //paste your api or access token here var baseId = "Base-ID"; //paste your base id here var tableName = "tab3"; //paste your table name here // Get albums from Google Photos var albums = []; var nextPageToken = null; do { var pageData = getGooglePhotosAlbums(

Hello Airtable Community,I have 2 tables: Attendance and Performances. People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc.  This gets recorded in the Attendance table under their school name and quantity goes under "Number of Tickets." I also have a Performances tab that tracks total number of tickets available for the performance. I want to use a rollup or formula to connect the two tables and deduct the total SUM of tickets claimed from a Total Tickets Available number that I set (right now it is 1,000 tickets.)Ideally I am able to make this appear in both tables: Attendance and Performances. Can you help me?   

TLDR; how to I grant 'conditional' creator permissions within a paid workspace?I've built up some pretty robust Bases for my company to track our projects.  We're using airtable as a stop gap solution on the way to a larger ERP software rollout.  I built an interface for every department to use that allows them to view and update relevant information (process tracking, shipping address etc etc), and prevents them from viewing sensitive information (employee addresses etc etc).  No one has access to the Base except for me, everything is done through the interfaces.All of this is happening through a paid PRO workspace, everyone with interface access is a billable collaborator on my workspace.  It just so happens that we've hired a guy who's very fond of airtable and wants to build his own base for his own workflows, and sync a selection of my tables into his base.  I'm fine with that, but I'm not sure how to grant him creator access to the workspace (thereby givi

Is it correct that it is not possible anymore to add a new field within the mobile app? Or am I doing something wrong?

Hello ! I document the sales of my stores everyday on Airtable - each sale is entered with its date of transaction.I would like to get the sales average per day of the week (i.e know on which days we sell the most on average), ideally with a graph with the X axis being the days of the week. Is it possible ?Thank you ! 

Hi everyone,I'm trying to do a multi-step automation, where I :find records (questionnaires) using the "Find records" step*feed the records I found as "input variable" to a scriptuse that script to compute values, based on the field "grade" of each "questionnaire" in my "questionnaires" listMy problem :When I try to use the input as "list of record", the input is in fact an HTML string with which it's hard to work : console.log(questionnaires) => And it's the same if my input variable is a "grid", the only other option available.Is there a way I could get a nice, clean JSON as in input instead of this nightmare ?Thanks 🙏  * I do this instead of scripting my query because the database is huge, and I get out of memory errors when I try script it

Hi all,I try to run this script :"when a button is clicked in an interface this script is running. It's pointing to another automation triggered by this webhooks to create a new record in a table.  const URL_AIRTABLE_WEBHOOK = 'https://hooks.airtable.com/workflows/v1/genericWebhook/XXXXXXXXXX/YYYYYYYYYYY/ZZZZZZZZZZZ' let config = input.config() let response = await fetch(URL_AIRTABLE_WEBHOOK, { method: 'POST', body: JSON.stringify({'dossier_record_id':config.dossier_record_id}), headers: { 'Content-Type': 'application/json', }, }); console.log(await response.json());  But It returns :ERRORThere was an unexpected error while executing your script.I'm tired and I don't see my error... After all I want is to create a new record in a table when a button is clicked... is there another to do that ?Thanks !

I have start dates and end dates for each project in a list of about 50 projects. I want to create a filter that will only show me records that were active between the start date and end date during specific fiscal years (where I set the FY date parameters). Some projects span multiple fiscal years, so "on or after" or "on or before" doesn't cover everything.