Ask the Community

I am trying to have the person who submitted the form on the left followed by a dash - and then another field but cannot seem to fix this. Any help would be appreciated.

Hi everyone, I have a collaborator with Creator permission who is unable to add attachments to an Attachment field. Is there a solution?Thanks in advance.

Hi I am a newbie to Airtable so please bear with me.I have been using JotForm to collect timesheet data from employeesand one field contains team members i.e. could be more than one team member in a single field and appear to be space separated in Airtable - in the JotForm itself this is a multiple select for each team member present that dayHow can I view/split this to make individual timesheets for each member listed in that cell i.e. duplicate the view for each one of those team members please?  This would then enable me to share each team members timesheet with them individually?The team member field looks like this:ThanksKalpesh 

Forgive my ignorance!  I have a column called Tickets.  I ultimately want this column to tell me how many tickets to each event AND separately, the number of tickets for the attendee for each event.  At the bottom of the table, I want a total number of tickets to a venue, despite there be multiple events at the venue.Do I have to create multiple columns to get this?

Im using Parser by Zapier to receive mails and create a record with certain infos mapped to my columns. One of which is the Mail Attachment to be placed in a File Column in Airtable. Somehow the file gets renamed on the process. In my example I send "invoice-60.pdf" to the zapier parser. It got added to the record as "9UngNgXzKLZ3jsMlQmQBOa95o1I5ENxS9LaFRxLNIfNkfLjB0I3ul64-P893QYjt62uhsUPyHBMe_P2i65Zv7-O3qjclkk4ACMI72H8AytGuav9QrcSMjQ1w8Sc1t4_UWDuEuGw6wGENXNjHf3XzQlMf2LLiwwxSveX6kdXYwBk"Somehow the .pdf end got lost in the process. I need to use an Airtable automation to send an email containing that file to a specific address when the status is changed. Due to the lack of .pdf ending the receiving system doesn't recognize the file and rejects it. Bizarre enough, i can open it in Airtable and take a look at the filename, there is no .pdf at the end. When I download it though, the .pdf end is in the filename again... maybe it got added while downloading it?I tried to uplo

I have been tasked with developing a system for individuals to evaluate (with a rubric) a series of proposals related to a strategic plan coming in.Individuals are submitting ideas using a Form that feeds into an AirTable Base (Base 1). We are doing this because we also want to visualize the ideas.The idea is that once individuals submit their ideas, a group of people will be able to evaluate them using a scored rubric (Base 2). Initially, I figured I would create another Base and then Sync the Two Bases (One Way) While also adding a form that would input the scores into the New Base (Base 2). I would link them based on either the AirTable ID or the Title of the Proposal. I was then going to create a third base (Base 3) that scores and averages the results of the evaluation.The challenge I am running into is that MULTIPLE people will complete the evaluation – up to 15. I am trying to think of a way to use AirTable for the scoring phase, but there need to be MULTIPLE people evaluating i

Hi everyone. I have a table "receipts" that collects receipts linked to different projects. Every receipt can only be linked to one project. The Receipts table has a Number Field "Amount in Euro". Now I the Project table, I want to have a Rollup field with the sum of all Amount field. But only those who are linked with the Project im currently in. What I want to do is add the condition "Where Project is exactly current project". So for Project 1 it filters by that, for Project 2 by that one. But I can only choose one particular project. Am I missing something or is there another way to do this? Basically what im trying to do is see the Sum of all incoming and outgoing receipts for every project right within the Project. Any helps would be greatly appreciated 🙂 

So GIFs working on synced view on laptop but not on android. But if view is a shareable link they work? Same data.At mo I created a button back to original as want to edit on phone but mystified why not working. Sure it worked before on Pixel phone but now on Samsung. Any thoughts anyone?

All day it's been 10-15 mins to execute a workflow of a few steps, some scripting, some update record.  Is this isolated or has anyone experienced this today?

HiWe have an Email Tracker table in our base with a lot of data rows, so I want to move that table to it's own base to avoid maxing out our limits too quickly.The Email Tracker table is fairly independent, with the exception of 2 data columns:1 linked records field (linking to the Campaigns table)1 look up field that is pulling in the "campaign owner" from that same Campaigns tableI'm not sure how to best maintain the 22,000 rows of data already linking to the Campaigns table in our primary base.The Email Tracker base will have a Campaigns table that is synced to the original one in our primary base. However, I'm not sure how to get the linked records fields that are currently looking to the primary Campaigns table to now look at the synced version of that campaigns table that I created in the new base, short of manually updating all 22,000 rows!I did a test, pulling in all the information of the Email Tracker. The linked Campaigns field and Campaign Owner field retained their data, bu

Hi there,I have a registration form. A single respondent will enter the the following data: name_1, email_1, an ID code, name_2, email_2, name_3, email_3.Instead of this being stored as a single row. I need this to be stored as multiple rows.row 1: name_1, email_1, and ID code, name_2, email_2row 2:  name_1, email_1, and ID code, name_3, email_3How can I get this done? 

It appears the URL for a sidesheet within an Airtable Interface does not contain the Record ID. Hoping to create a formula link to records displayed in a sidesheet, however cannot figure out how to do this with the structure of the sidesheet URL.The structure is either:https://airtable.com/appXXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX?xxxxx=sfsXXXXXXXXXXXXXX&detail=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXor:https://airtable.com/appXXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX?detail=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXThe 106 characters after "detail=" is consistent across the various interfaces accessing the same sidesheet, so assume that is the unique identifier I need to generate via an Airtable formula, however have not been able to find a way to do this (similar to using RECORD_ID() in a formula).Can anyone please offer advice?Thanks,Tanya

Good afternoon,I am attempting to create an automation that sends an email to my team with details about some work items.We use an Interface view to organize those records, and I need to generate links to each record so that when a team member clicks it, it opens in the Interface view, not in the Data view. The default is a view that doesn't show all the data we need (instead of the view from which the automated email came from), which is annoying in the first place. I'm trying to solve that via the interface. I know how to generate a link to a record in the Data view, by just using the record ID. But I haven't found a way to do the same in Interfaces.For example:This is a link to a record in the Interface: https://airtable.com/{appid}/{pagid}?detail=eyJwYWdlSWQiOiJwYWc0UTlGcTVNcGVBeEVsRiIsInJvd0lkIjoicmVjZHMweHdocHlmVE1scEQiLCJzaG93Q29tbWVudHMiOmZhbHNlfQThis is another one: https://airtable.com/{appid}/{pagid}?detail=eyJwYWdlSWQiOiJwYWc0UTlGcTVNcGVBeEVsRiIsInJvd0lk

Hello - full disclosure, I've only just started to get into scripting in Airtable, so bare with me as I'm still learning!My actual goal with this script is actually quite complex, I'm probably only about half way through. But instead of trying to summarize the entire thing, I'm just going to hone in on where I'm stuck specifically... which is how to properly utilize the Filter function with arrays.So I have a button trigger in a table "TV Finishing" that I want to execute a script. The script copies a name and an alphanumeric code (ISCI code) from the record, and pastes it as a new record in the table "AutoHelper". This I have working just fine.But then I want the script to count how many existing records in "AutoHelper" already have the same ISCI Code, and to paste the number (plus 1) into a number field of the newly created record... and this is where I'm stuck.I've added my existing script below with the error code I'm getting when I try to use query.records.filter. I've tried to em

Hey everyone! How do I create the statement to leave cell blank if a value is missing instead of #ERROR? I’ve read you should not use the BLANK() code? Code for Days Left: WORKDAY_DIFF(TODAY(),Starts) Code for Urgency: IF( {Days Left} < 0, "🔥OVERDUE", IF( {Days Left} <= 20, "🔴 ASAP", IF({Days Left} < 40, "🟡 Medium", IF({Days Left} < 100, "🟢 Low" ) ) ) ) Thank you in advance!

Hi there ! :grinning: I’m very very new here, on Airtable, so to begin gently, I’ve come up with the idea to build a DB regrouping all the info I have on the pets I lived with (dead and alive). But I’ve got a DATETIME_DIFF() formula difficulty. On my base, I’ve created kind of a summary table with all the general info concerning the pets (Species, race, gender, etc…) On this table, I’ve got a field Date of Birth (DoB) and a field Date of Death (DoD). What I would like to do is to create a field that would give me the actual age of the pet (if still alive) or the age of the pet when it died, on same table, if possible :winking_face: . Reading the help documentation and many topics here concerning the DATETIME_DIFF() formula I found this : DATETIME_DIFF(TODAY(),{DoB},’years’) Which works perfectly for the actual age of the living pet. And… DATETIME_DIFF({DoD},{DoB},’years’) Which works perfectly for the age of the pet when it died. If I get it right, I would need to create a IF() nes

I'm trying to sync an excel online file (that's a .url file) to airtable and airtable won't recognize it. Can anyone help? If this doesn't work I'll have to figure out how to go map fields from oracle to airtable but would be far easier to just use the excel online file that is already mapped correctly and pull that into airtable and have it automatically update from there. There's no editing we'll need to do from airtable to excel online, just one way sync to airtable. Thanks for your help!

I'm using a Google Drive Sync integration with the intention of avoiding going over the storage limit in my base. On the FAQ's for this integration I found this information:Will the attachments in a synced table count toward the destination base’s attachment limits?Yes. Similar to record limits, attachments in a synced table will count against the attachment limit in that synced table's base.If I were to simply not sync the attachments field, will that avoid taking up storage space in my base? With this solution, I could simply rely on the urls provided by the Google Drive Sync integration to interact with my files.Thanks in advance,

I use Airtable for timesheet purposes.  The employee completes a form in Airtable, and then that causes a row to be created in my Timesheets table.  Then the payroll staff go in and click an "Update Row" button on the row to enter the date paid. My primary field was a concatenated field of Last Name, First Name, Date Worked when I realized that a person can have 2 rows for the same date which apparently broke my automation.  I have been researching this all day and I do not know how to fix it.  Someone pretty please help! Screenshots included. Thank you!

Good morning all! I'm hoping someone can help me with turning a pretty straightforward concat formula into something with more if/then logic to help when empty fields are encountered.Right now I have a primary field on my sheet that uses a formula to build a unique ID for logged payments. That formula is below:  CONCATENATE({Vendor Name}, " - ", IF( {Remit to AP}, DATETIME_FORMAT({Remit to AP}, 'MM-DD-YYYY')) )  The trouble is that with a lot of records there may not be a "Remit to AP" date for a number of reasons. I'm hoping there's a way I can use alternative fields as backups so the primary field doesn't just show something along the lines of "Vendor - " which isn't helpful.There's another field called "Invoice Date" that is much more frequently populated, and a "Year" field (which is a single select, not open text) as the last resort. Would it be possible to have a formula that builds the concat as above and says if the "Remit to AP" field isn't blank to use

What's up guys,I'm struggling to implement Vega-Lite chart extension on my base, it's my first time using it. I'll show you an example of the base I'm working on in which I'll need to create a bar chart. It seems that I can't add multiple fields on the x axis.If anyone can help it'd be greatly appreciated.

Hi @dashler78 experts,I have an interface which has a dropdown and a button. When a user chooses a value from the dropdown and clicks on the button, an automation script runs doing the following1. It saves the value chosen in the dropdown.2. Updates 'Created By' as 'Automations'.I want the script to even update another field say 'User' with the user object (of the person who actually clicked the button).Is there a way to input the actual user object using automation script?I saw that I am able to get 'email id' , 'id' - which is usrXXXXXXXXXX and name. However what I actually want in the field is the complete user object which is similar to how 'Created By' and 'Modified By' fields look. Kindly let me know how this can be made possible?I am using an automation script because that is the only way I can save the value from a dropdown in an interface.Currently when I try adding the id in the User (field is of type: User) field, it gives me the following errorError: Field "fldyaWWxTRvpc9bS

Hello everyone, I am having some issues working on a script that I made using Copilot. Here's the reason why I am making it: I have a base which is composed of two tables: Table A and B. I am doing this because, in my company, we review conversations from customer service in order to improve it. Basically, Table A is composed of a form, and we get to see the results to the different questions and one big score (which is a formula field). I made Table B, so a second team can work on conversations which have a QA Score below 80. To do this, I need to create an automation which is composed of 3 steps: 1. When a record is updated in Table A (the QA score appears after grading the conversation)2. Create a record in Table B and add some information: customer's name and Table A QA Score (it's a number field now)3. Since any record will be added to Table B, I made a script to delete any records with a QA Score above 80. This is where I run in some issues

Hello! I am running into an issue automating an email notification when the date column is changed from one date to another. I have the automation set up so that when the date column is changed and the status is 'Sent', the email is triggered. The issue is that the email is getting sent every time the date is changed (including when the date is entered initially).The only workaround I've figured out so far is to set it up so that the record must match Status = Sent and Date is changed and we enter the date column second, but that leaves room for user error. Is there a way to ensure that that the email is sent only when the date column is updated from not empty?

Hi, So I’m using PHP which has this functionality built in (basically I give it a number and it converts it to how I would like it…) specifically I’m in Australia but the format I’ve chosen to go with is like this: +61415932797 so let’s break this down +61 = country code 415932797 < number obviuosly In Australia though when you call someone on mobile you dial 04… so it would be like 0415932797 if that makes sense (since you don’t use country codes when dialling within the country)… so I’ve got a bunch of these mobiles like this in my AirTable: 0402 930 888 - like this which I want to convert to +61402930888 - as you can see no spaces (random spacing in my original) - ideally also skip any fields that have text in them but that’s an easy thing… so… yeh long story short how do I regex 04 01 933 833 to +61401933833 also keep in mind a number could all ready be country code… but then again I could just filter those with + and fix manually or something but would be good if for example +6