Ask the Community

Hi,I'm creating an interface where I want to present the development costs for my company. Regardless of the applied filters in the top, I want to limit the amount of records presented in a chart to 20. If I don't apply any filters, the graph looks like this:Is there a way to fix this?

Hi There,Seeking some help writing a formula to show the minimum of two date fields in a specified format. I have it working but showing without a forward slash.Formula used so far is =MIN(VALUE(DATETIME_FORMAT({6QIssuedDate},"DD/MM/YYYY")),VALUE(DATETIME_FORMAT({6QTriggeredDate},"DD/MM/YYYY"))) This is showing as DDMMYYYY but need the format at DD/MM/YYYY Thanks

Basically,I have a field that lists days of the week with no reference to date. I have tasks that need to be done on a particular day. Would like to another field to automatically update itself with date of the current week for that given day.  Is this possible?  Thanks

Hi, I would like to print an airtable view and exclude certain columns from being printed. If I use the “hide”-function, I don’t see the columns in the table anymore, but they appear when I print them. Is there a way to exclude certain columns from getting printed?

Hi everyone,In an interface form, I have this field that is linked to another source.When clinking the "+ Add record", my end user will have the possibility to link a record from another table.Unfortunately, when I click on the "+ Add record" button, a new form open, with nothing but just the autonumber of the record, and no other details.As you can see on the picture above, just the autonumber, which is somewhat really tricky to know which record to select...Details for the form's parameters here :Can someone please explain how to show all the details from the other table on that form?Thank you a lot,Elie 

I have a lot of different clients who are using internal data entry with customized forms through the interface designer.It's such a waste of space now.  And I'm stuck looking like it's external form when I just want a clean internal entry form for my clients for whatever they want to do.PLEASE bring back the internal form maker so I can position and resize the entry fields for internal forms. 

I want to send a webhook when a button is pressed on a record :// Use recordAsync to get the record associated with the buttonlet record = await input.recordAsync();// Check if the record existsif (record) {// Construct the URL based on the fetched record IDlet url = `https://hooks.airtable.com/workflows/v1/genericWebhook/appXXXXXX/wflXXXXXX/wtrXXXXXX/${record.id}`;// Fetch data from the constructed URLawait fetch(url);} else {console.error("Record not found");}but I'm getting this error:ERRORTypeError: Invalid arguments passed to input.record(label, source, options): • label should be a string, not undefined • source → source should be a Table, not undefined or source should be a View, not undefined or source should be a RecordQueryResult, not undefined or source should be an array, not undefined at main on line 2Can anyone help here please? (I don't know scripting)

Is it possible to embed a calendar view in an automated email?

Hello there,I'm trying to fetch data from a product in one base, then send that information to an external API and then update that new info in other base. The code goes like this: //input of modified product let inputConfig = input.config(); //JSON creation let body = { "costo_ult": inputConfig.costo_ult[0], "disponible": inputConfig.disp[0], "dias_obs": inputConfig.dias_obs[0] } console.log(body); console.log(JSON.stringify(body)); //Send JSON to API try { let response = await fetch(`http://167..../${inputConfig.id[0]}`, { method: 'PATCH', body: JSON.stringify(body), headers: { 'Origin': '', 'Content-Type': 'application/json ; charset=utf-8', 'Authorization': 'eyJhb...', }, }); console.log(await response.json()); } catch (error) { console.log(error); }  The fields I want to update are related to costs, quantities and rotation days, and the response from the script isError {name: "Syntax

Hi all,I have an automaton where at X time, once a week, records are scanned for any projects that are within the next coming week, the status is to be changed to "Upcoming". I am recieving an error message on the update record part. I have attached a video below for you to see.Does anyone know what the problem is and a solution?Kieran

Hi all,I want to build a base for tracking the onboarding and ongoing training of employees at our company. We have a list of “SOPs” standards and guides. I’ll just call them SOPs here. There are actually several lists (one for engineering, one for accounting, one for HR stuff, etc). These lists currently reside in a series of google sheets that have columns to describe what the SOP is for, who “owns” it, what the status of it is and its priority for training purposes and a link to it (in google drive). Then there is a master list that links out to the other lists. The challenge is that I want to track how well each employee on the team knows a particular standard, and if it is a priority for them to learn it. And it doesn’t make sense to do that in the spreadsheet format. I want to transition this to an Airtable base that relates a table with our employees (a row/record for each employee) to a table with the SOPs. So for each employee there would be a few fields that define: their lev

Hi,I have a field which is multiple select in the airtable, and for one record there are 119 selections to be made. Is there a way to load them in go, than adding every single option under multiple select for that particular record. thanks

My plan says that I am over the limit on a base. When I go to my account page it says “All of your bases are within the record and attachment limits for your current plan (annual Pro)”. I am needing this fixed so that I can add new records. Specifically, I am trying to push new records from Activecampaigns to Airtable via Zapier. I realized that when the base was not updating with new contacts that there was a notification about a limit excess. Does anyone know how to fix this error? This is causing a big issue with my business.

Title.I am still getting the hang of scripting, Airtable, and scripting for Airtable. Goal of script:User chooses up to two options in multi-select field.Those multi-select options are 1:1 with the names of the records that are being linked. (IDs are included regardless).Link those up to two records from the Signature Hardware Vendor multi-select field into the Vendor(s) linked records field.Ill gladly take hints on updating or fixing my bad code leading up to the portion in question, but I can confirm everything shown below is working BESIDES the linking of two different records.  const { recordId , QASubtype, SHVendor} = input.config(); const table = base.getTable('tblFvUDsFR14aJ8Nu'); if (QASubtype==="Signature Hardware Quick Add"){ await table.updateRecordAsync(recordId,{ "Manufacturer(s)": [{ id: 'recBUCS8K6yzHS1Nd' }] }); if (SHVendor==="Signature_Hardware - 1481"){ await table.updateRecordAsync(recordId,{ "Vendor(s)": [{ id: 'recyW5pRLYxqFIMkt' }]

I'm trying to connect Power Automate with Airtable using this connector: https://learn.microsoft.com/en-us/connectors/airtable/. I am able to connect when using the API Key. However, when I try to use a personal access token, I get an error. I've tried the full PAT (82 characters) and the PAT key after the token ID. What am I doing wrong? 

Hello all!I don't believe this is possible with how automations work with Airtable as I know them, as they seem to be restricted to only automating one table and that one table's records. Regardless, I'm hopeful there's an extension or something that can get around this, as this seems like something that would be extremely useful to most people. I'm going to lay out an example for what I'm trying to do/the parameters around it, rather than trying to explain it with a block of paragraphs.An existing table's records is a list of projects. These projects are labeled as either approved/denied/pending/submitted in this table, and each of the project records were spawned from a submitted form. Once a project is labeled as "approved," it would make my job/my company's job easier if a new table(s) can be spawned, based on pre-saved table templates (though, honestly, I don't even know if it's possible to save a table template). So for example, once a project is labeled "approved," a table label

Hello All,This is my first post here & I am an Airtable newbie.I am trying to get my table to show the number of unique values for 1 column based on another column.Here is an example of my data:I want to insert a column that counts the number of unique TU ID's by the School & County column.Thank you for your help! 

Hello! Here's my situation.I have a table 'Part List' that is automatically updated with parts from an external base that I do not control. One of the data entries inputted is "version" and "iteration". So I could have the following table:Part #VersionIteration001A1001A2001B1002A1003A1003A2Where the rows in red are the most recent parts (red is only shown here for emphasis, not in airtable). Deleting rows is not an option because I do not control the data source. I want to create a column that will have checkboxes, and it will be checked if it is the most recent iteration.Dedupe does not work because I cannot merge cells that I cannot edit, and I have thousands of entries so that would take too long.I've tried to adapt the Mark Duplicate example but I get the "Api request failed: Request Entity Too Large" error. But also I wouldn't know where to go from there.The closest I've gotten is below where I can mark a checkbox in a "Is Duplicate" column if it is some iteration of a duplicate p

I have a formula that I'm attempting to show "Sold" if tickets to an event have been sold, but if the tickets have not been sold, to display the number of days until the event. I already have another formula that will give me the number of days until the event.Generally, the formula below is working - except for one scenario, when a ticket was sold for $0.00. You may wonder why a ticket would be sold as zero, but that indicates to us that the ticket was given away - as compared to just not used.I've tried to use the presence of a value (my best working version below), and I've also tried to use the =BLANK variable, because if there is no sale at all then the cell has nothing in it, but Airtable seems to treat a value of $0.00 the same as BLANK.So then I tried a variation of this formula with >=0 but then ALL values were returned as true - even values where there's nothing in the cell.Here's what I have for a formula currently:IF({Event Sale Price}, "Sold", {Days till Event})The

Hello! I have created an order management app through Airtable that tracks our open orders through their entire process. We import to Airtable through a Zapier Zap from an Excel file that was exported out of our POS system. We have a master key that comes out of our POS system and it is unique to each item in every single open order (each row is an item, not an order). Once the item status has been set to "Complete" I have it set up in Airtable to move to a "Completed Items" Kanban view. We need a way for Airtable, Zapier, whichever to recognize when the item has been invoiced (paid for, left the building). When an order is invoiced it will not show up in our "Open Customer Orders" Excel export from the POS system any longer. (Makes sense, of course.) There will be no master key to map to. My boss is wondering if there is any way to tell Airtable that this order has been "Invoiced" due to the fact that ALL Master keys under a given invoice number are set to complete. Onc

Hey guys,I am looking for a way to add records form a linked field using a form.Heres what I what I have right now:GFX Request Form to create a new dated request in the Requests table, I have a linked field to "Individual GFX"  to track the individual GFX for each request. Obviously on the interface forms that linked field shows up as a dropdown to choose existing records of individual GFX, I need to be able to make new records. I've seen some posts about this pointing to outside forms and I'd like to avoid using that unless you have a reliable secure form site.Let me know if there's some scripting or automation you know of to do this. OR! Is this something that can be implemented in the future oh airtable overlords? 

Hi all,I have a simple script that is taking some items from the submission of a Gravity Form and updating an AirTable record. It all works great until I get to a section of the form that has checkbox values. INSIDE of one of those checkbox values is a string that contains a commaCheckbox choicesApplesOrangesPearsGrapes, limes and lemonsI can gather all of these out of Gravity Forms and put them in an array and then implode that array to get a comma delimited list, which is what AT wants to absorb that data for checkboxes.$c=Apples, Oranges, Grapes, limes and lemons"records": [{"id": "'.$id.'","fields":{"Committees": "'.$c.'"}}],"typecast":true}';This of course will cause AT to barf when that comes in and tries to split the Grapes out as its own committee and limes and lemons as another committee. I know that in order for AT to treat a Linked Table field items containing commas is to put quotes around it. When I try and quote the incoming data here the update bombs.$c="Apples", "Orange

Hey guys,I am trying to figure out how to use the Timeline Summarize to count the number of tasks with an end date field instead of the start field field from the timeline date settings. I use the timeline to lay out projects phases and milestones and have both displaying with milestones being tasks/records with only "due dates". Currently the count only counts the main date field for the timeline (start date field) when i need it to count the end date. I'm trying to figure out a way to maybe use a formula and sum to count the number of tasks for each day but can't seem to figure out a good way to do that. If anyone has any ideas let me know!Thanks!

Hello!I'm fairly new to Airtable, but I have found myself stuck on something and I'm unsure the best approach.  I have a base that is receiving data from submitted forms for security requests.  These requests are worked on by 3 different staff members.  I've built interface views for each member and I am now trying to add a button on each interface that once clicked, would update a record with a blank "Assigned to" field to their name and thus populate into their interface view.  Is there anyway to do this in Airtable? It could be I need to think about it in a different way rather than updating a field, that's why I am reaching out!Thanks!!

I'm adding a row in sheets successfully but only 2 of 6 fields are being copied over. What could be the issue? Thanks.