Ask the Community

Hello,I am having trouble getting a script to automatically generate records from two lists: bonus plan and staff list into “bonustable”. I was able to set up the automation steps to find the corresponding lists from the bonus plan and staff list. I have tried AI to get the script but it is not iterating each item from the input list. I also want to input the value year-month from the previous step of automation so that the created record already has year-month linked.Essentially I am looking for the following output:Jane / Bonus Plan A / 2025-03Jane / Bonus Plan B / 2025-03Jane / Bonus Plan C / 2025-03Ben / Bonus Plan A / 2025-03Ben / Bonus Plan B / 2025-03Ben / Bonus Plan C / 2025-03 Script is as follows:// Access input variables from previous automation stepsconst inputConfig = input.config();const bonusPlanNames = inputConfig.bonusPlanNames; // Array of Bonus Plan names (primary field)const staffNames = inputConfig.staffNames; // Array of Staff names (primary field)const yearMonth

Hi,Which Language setting should be used to paste formulas, i mean here:  Several times I wanted to ask it on old forum engine, but then just selected ‘Javascript’ and postponed it until next time. Here it looks not so good, so maybe I’m just missing a better way to do it?Well, in my opinion, the Javascript was better in old forum as well, here it’s too much red, while red supposed to be warning/error color. But maybe it’s just a matter of taste and mine is far from perfect.

Hello is it possible to use NodeJS coding within Airtable Scripts? I have a library of API codes that were configured with NodeJS. However, I seem to have issues with Axios and request-promise…  Code Example:   Code Example:   Code Example: /////////////////////////////// Change these parameters ///////////////////////////////const API_UID = 'Oauth App UID from account settings';const PRIVATE_KEY = 'path/to/private/key.txt';/////////////////////////////const jwt = require('jsonwebtoken');const rp = require('request-promise');if (!global['URL']) { global.URL = require('url').URL;}const fs = require('fs');let privateKey = fs.readFileSync(PRIVATE_KEY);let uri = new URL(`[REDACTED]`);let aud = `${uri.protocol}//${uri.hostname}`, time = Math.trunc((new Date().getTime()) / 1000);let claim_set = { iss: API_UID, aud: aud, scope: 'admin_read admin_write', exp: time + 60, iat: time};let assertion = jwt.sign(claim_set, privateKey, {algorithm: 'RS256'});let payload = {

Is there a way to created a FORMULA for assign automatically in created a number NOT REPEATED between 1000 - 9999? Sorry i am new and no programmer.Option 1 formula and assign automatically, is no posible to NOT REPEAT, no problem i order table and search repeat, and change manually and assign other numberOption 2 I hava a table with 600 number aleatory. Assign it each a row is created. ¿Its posible?Thanks 

I’m working on a voting app, where there are tons of enhancements. There’s a ‘Votes’ field which is of type ‘User.’ Users can add their names to that field in order to vote for that enhancement. This is based on a simple, single table.I want to have an interface page that lists enhancements that have gotten votes, sorted by the number of votes each has gotten. So if I add my name to that Users-type field, the number of votes for that enhancement goes up by one, and the sorted list of enhancements by number of votes gets appropriately updated.I thought I could just do a calculated field with this formula: COUNTALL({Votes})However, that’s giving me a value of one (1) for each record, even though right now most fields have no entries and a few have 2 or three.I’ve only done pretty basic things with Airtable, so I’m hoping there’s a simple way to do this and I just can’t get google to find it for me. Any help you can offer would be appreciated! 

I am struggling with the last stage of an automation and keep getting a message that it's received invalid inputs but I can't figure out what I'm doing wrong. I'm a Literary Agent and have a Titles table, an Authors table and an Editors Table.When I'm working on a book and chat to an editor about it I have a section in the title field where I can add a link to an editor who wants to see that book and it will create a new entry in my submission tracker that is named 'Title - Editor' so that when I come to do my submission I have a full list of who I've spoken to in the right place. This brings through the title/author information no problem, but, the editors are all lumped in together on the linked field which means I can't separate out and easily find the publisher/imprint info. I've created a formula that will pull the editor name from the main field on this table. Then I've created an automation that says when the editor name calculation updates, find a record that matches

I use Airtable as a logbook for the vehicle (TABLE1). Each row = one trip. I would like to use automation to send myself an email when an oil change is due. So I need to total the miles driven (from TABLE1) and compare that to when the oil change is due, which should be placed in another table (TABLE2).Is it possible to create one record in TAB2 that still shows the current SUM column from TAB1 (same number as in the summary bar)?I don't want to use a rollup that has to be manually updated each time.

I built a project management tool using softr as the UI. I am looking to build an airtable automation that sends and email upon various triggers with the airtable data. The triggers seem to work fine, I am having trouble pulling in the data I need from related records in other tables. The data structure in this example would be:Project Table - has a field containing project members. This field is related to the user table Users table - has individual records for each user and a field in each user record containing all the projects it is associated with Drafts Table - Each record contains the data about a video draft I have built, including the project the draft is related to.The desired automation would detect a new draft record has been created and find the associated project record which contains a field defining the “primary project contact”. Using the ID associated to the primary contact, it would find that user in the “users” table to retrieve that user’s email address . Then send

I have a database of contacts and I would like to keep a record of the activities or meetings in which they participate (I don't know if in each activity I should adjust the form for this action). But it would only be to add this new column, not to create duplicates of people each time they attend an activity. Thanksss!!!

Airtable has how to autocomplete fields in a form, that is to say that through a unique key it preloads data already existing in the database that are requested in the form.

I need a formula to populate a field based on three other fields - where only one will have data. So in fields 2 - 4 below, only one will have data and I want that to show up in Field 1. Field 1 - formulaField 2 - Lookup from table 1Field 3 - Lookup from table 2Field 4 - Lookup from table 3

I've created a customer appointment confirmation system for our solar installation business and am struggling with a specific issue.Current Setup:We have an Airtable base with appointment records for our customers We send automated emails with links to an Airtable form for appointment confirmationProblem:When customers submit the form, it creates a new record with their feedback instead of updating the original appointment record. This disconnects their response from their appointment data.What I've Tried:Passing the Record ID as a parameter in the form URL Using "prefill_RecordID" to attempt to link back to the original recordQuestion:How can I set up an automation that will:Capture the form submission Find the original appointment record using the Record ID passed in the form Update the original record with the confirmation status Optionally delete the new record created by the formI'm looking for step-by-step instructions on setting up this automation correctly, especially the "Find

Hi all - a weird thing is happening with this automation. On the table, I have a view sorted on a particular manager, employee type and status, resulting in 72 records - which is correct. When I set up an automation, I need an email sent to a particular email address that includes that table view (in either a list or grid) in the body of the email, which I’ve built and it works - apart from the resulting email that is created only contains the first 10 records, not all 72. And I can’t, for the life of me, figure out why it’s doing that. I understand the preview is limited to just 10, but I am getting this result if I run the automation from start to finish. In the Find Records, I’ve tested both Condition and View and redid the automation and I get the same result. It’s not wrong, as the 10 records it’s showing are indeed in that table, but it’s only the first 10, I need all 72. Any suggestions? I’m getting desperate lol. 

Hi,I’m experimenting with the RLP with DNA 2023 Airtable template.  I’m trying to personalize the column headings and can’t figure out how to do what I want after reading the Airtable help.  Can someone please tell me the following?  It's really a general question about copying/pasting a column field from one tab to another.I made a new field called “My Tree” and inserted it on the DNA Match Details tab.  But, now how do I insert that same “My Tree” column on the Kit Access tab?Thanks! 

I'm trying to send a formatted HTML via gmail and it comes out as junk. In particular, a properly fomatted <table> set of tags appears to have </table> inserted right after the <table> tag, messing up the output. I can't tell if this is something the browser is doing, or is happening as the automation gmails the body.Any thoughts on this?example input and output (note, I'm not listing my entire table, but I do wrap it in a </table> tag and is properly formatted html:Input: <table><tbody><tr valign="top"><td><strong>Email Group</strong></td>source that shows up in gmail:<p></p><p><span></span></p><table></table><p></p><p><span></span></p>

How do I edit what date this filter defaults to? It's been the same default since I originally built the dashboard, but I would prefer to be able to edit this.  

Hello everyone, I’m having some trouble with the field order. As much as I move the field order in my grid view, when I click on manage fields, they appear in another order… I wouldn’t mind but the problem is when I send automatic emails with list views of fields it does not display the fields in the order that I need to. Can anyone help me? Thanks in advance Patrick

As we can see in this graph Airtable Interface is not interpreting the numbers in an ascending order. It seems to only look at the first digit. I've tried to fix this issue in many different ways, but no luck.I need the graph to start in September and end in August (our FY)

Hi Airtable Community, I have created an interface with a dashboard. There, budget amounts are given as a number based on our financial year. Now I don't want to have to adjust all filters in the number configuration every year (when the financial year changes).Does anyone have an idea how I could build this dynamically so that I only adjust the FY once and it takes the current year into account in all filters? best regardsMirko

Sorry…I am swapping over from Jotform. I need a form where customers lookup their details (record) by entering telephone number…if there is a match, on submit, the customers details are emailed to them.

Is there a way for me to get rid of the preceding "Sum:" in the interface graphs?  

Hi,  I'm running a research participant network for my organization. When our customers sign up to do product research with us, they provide a number of times they want to be contacted about engaging in a research activity. I need an flow automated flow that will 'quarantine' participants when they have met their limit, and that will reset at the end of the year. (a single select field, that I can use to hide them in the view of available participants) Currently I have:- Availability given by the participant in a form - I'm using a formula to convert that to a number field. - A 'engagement status' field to indicate whether a participant is available or currently engaged (used to filter them from view of available participants).- An automation that switches the above field from 'engaged' back to 'available' once the research as ended. I'd like to be abe to count how may times the 'engagement status' field has been changed to 'engaged', then compare that to

I use the software to keep track of all my craft projects as well as all my supplies. I am trying to calculate the price of the supplies used for my projects ("cost per item * # of items" kind of thing), but one of my fields has multiple values. When I try the below formula, it always returns a 1.0.{Price/sq in (from Vinyl)}*{Area of Vinyl Used (sq in)} Is there a way to have each value in the "price/sq in" field be multiplied by the "Area Used" field (which only has 1 value)?

Hello, I am new to Airtable and formulas. My current formula is thisIF({Full/Part Time}="Part-time", 0.5, IF({Full/Part Time}="Full-time", 1.0, 0))I want to add a condition that if another field has two selected clients, the part time value of 0.5 will be doubled.The Full/Part Time column is a single select field. The formula isn't coming up with any results. Any idea what I did wrong, or what's missing in my formula? Thank you! 

I've submitted my information 4 times online and emailed support to have someone from Airtable call me to upgrade to enterprise. It's been over a week. Is this normal or is there a better way to get in touch with someone?