Ask the Community

Hi,I am trying to figure out a way to copy data from one record to another in the same table. In the example Ordrenummer primær should be the key and I want Navn and Mail from the record with values to be copied to other records with the same value in Ordrenummer primær.Thanks for your help./Michael   

Hi everyone,I have a scenario in Airtable where I want to dynamically control the visibility of form fields based on boolean values from another table. I’m proficient in Python, SQL, and JavaScript/Vue3.js, but I'm struggling to implement this logic directly within Airtable's environment.I want to use these boolean values from the Analysis table to control the visibility of form fields in the Application table. The challenge is that Airtable forms seem to be bound to a single record and don't directly allow dynamic visibility control across tables.Can I use JavaScript or Airtable scripting to dynamically control field visibility in a form based on boolean values from a linked table (Analysis)?Alternatively, would it be easier to restructure the process by splitting the form into multiple steps (e.g., first upload the PDF, then show the relevant fields based on boolean values in the next form)?Any help, pointers, or examples would be greatly appreciat

Hi all,Firstly, apologies if this has been asked / answered before, I had a search through and couldn't find it.I'd like to import a number from an external website and automatically update it when it changes.  Also would I need their permission for this?The website is transfermarkt.com it gives an estimated market value for individual football / soccer players.  I have a database of players, and I'd like the estimated value for each one in a column.Is this possible?Many thanks in advance Barry

Hi everyone,Please help me, i deleted by mistake an interface, where can i retrieve it?? why can't i see it in the trash ?A million thanks  

I am trying to create a way for people to subscribe to a newsletter. The first form allows them to put in their name and email address. It works fine. I set a field called "Status" to Unconfirmed (as Single select type).I will then have an automation that will email them a link to a form update (with the record_id() etc).  I want the form to just have the Submit button (in which I change the label to "Confirm Email".  I can have the Status field on their for them to select "Confirmed", but I'd rather it be passed in, hidden and changed to "Confirmed", so when they submit the form the status gets set to "Confirmed".So I have the edit form (in fillout), I created the URL id of Status, and I set the formula to "https://forms.fillout.com/t/rBuRDxxxxus?Status=Confirmed&id=" & R

HiI'm really, really trying to love interface forms and the design is much improved but is it really the case that you cannot prefill linked record in the form? I've tried with Recordid and with the name and it doesn't work. Other fields are fine (that I have tried) but not linked records. I believe its also the case that users need access to the base to submit if its being used as an internal form. Can anyone confirm these, are there work arounds. I'm having to abandon them for now and build with old forms 😞  Cheers Jason    

I have the following case history:a base with multiple tables interconnected with each other;I've created an interface form to populate one of these tables;In this interface I have a field that allows me to select a record linked to another table;In this field, again from the interface, I have the possibility to choose only existing records;Is there a way to add, from the interface form, a new record directly from the field with the drop-down list? Directly from table this is possible, but not from the interface form or any form view. Many thanks

Hey all! I'm running into an issue when building a form. I am trying to build a publicly accessible form through Interfaces that also includes population through record linking. For context, this is a form that clients can use to order supplies from an organization. My ideal workflow for this would be; the client selects their Record ID in a linking field, and once they do, an automation pre-fills the form with their usual order. They can then edit it if there's something they would like to add or remove.  I've built the automation, and I've built the form - but now how do I get them to work together? Is this feature not possible? Looking for straightforward solutions before I go down a rabbithole! Thank you in advance for your time and help!

Every week I add about a dozen fields to my base that are the same field type (and only updated to the current date). (The group each week includes the same field types in the group, however, they are not all the same field type, make sense?) For example, Revenue x/x/xx (dollar, integer), Date created x/x/xx (date field), new accounts x/x/xx (number, integer), …etc Is there a way I can do this in a batch as opposed to creating each new field?

Hey all,I recently needed to switch an email automation from "Send email" to "Outlook email," to fix a spam filter problem. Previously, when it was being sent as "Send email," a link at the bottom of the email led all recipients to the record detail view of the submitted record on a particular interface - even though interface links are not currently insertable, and I had to assemble the link myself, it still worked fine.They look like this in the Automation message body, where the parenthetical is the inserted dynamic record ID:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/(AirtableRecordID) But now, with the Outlook email automation, the links are broken. Something in the chain is adding two BOM bytes into the link, so it goes to this link instead:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/%uFEFF%uFEFFAirtableRecordID Is there a fix for this, or something I'm missing? The only other thing to note is my org uses urldefense

Hey Everyone, I had a question about visualizing data that you recieve from form submissions. We are accepting applications for a program that requires a small team to access the entries and approve or deny. Currently I planned on having them look at the table and expand the view to read their information. This isn’t ideal as the modals are kind of narrow and from an experience its a little cumbersome. For anyone that has used google forms, when you are an admin you can basically look at each form submission in a way that it shows you a view of the acutal form, except with their answers filled in. This was just a more palatable way to look at each. Is there a way to do something like this in airtable? When people submit I get an email that has all of their filled in info laid out, a page like this in airtable would be perfect. I’m new to airtable so I apologize if there is a very obvious solution to this. Thank you!

Hi everyone, I'm wanting to improve upon the Extract Base Metadata script to include more features. Has anyone experimented with this?Ideally it would:Gather the metadata currently acquired by the Base Metadata Extract extension (listed below)Be capable of running automatically at regular intervals.Indicate if the field has been deleted.If the field is a linked record field to another table limited to a view, name that viewIndicate if the field is in use in an interfaceSHOULD: name those interfacesIf the field is a lookup from a linked record, name the originating recordSHOULD: link directly to that recordShow which interfaces the field shows up on and make updates when fields are removed or added to interfaces

I am very familiar with constructing a URL to go right to a record based on the record id. However, what I am looking to do is to go to a record based on a different unique identifier...their phone number for example.E.g.:https://airtable.com/appXXXXX/pagXXXXXXXX?tcd26=+15555555555Any ideas if this is possible?

Hi,We're currently using the "Scripting" extension on our Airtable base and we have several different scripts that need to be run on occasion. From what I can see, the "Scripting" extension is just a panel where you write or copy/paste scripts.My question would be: is there a way to save/store your custom scripts somewhere in Airtable? (maybe by using a different extension) - as opposed to saving them locally or somewhere else. Thank you,Cris

I found multiple posts stating we can’t create new columns/fields on a base but then I also see posts like the following two where the script looks like it’s calling a create() method. Are we able to create new columns/fields through a script? Does TypeCast only work on Create? What about Update?

I have created a fillout for a registration form. I have a table of people I am inviting, and would like add the fillout button to an email so that most information is pre-filled, and then the registration info updates in the existing line in the table.Please see below - the token is not working - either inserting a formula field or using the button field in the database. Can you help me correct this please to add into my automated email?<a href="(token)" style="background-color: #4CAF50; color: white; padding: 10px 20px; text-align: center; text-decoration: none; display: inline-block; border-radius: 5px;"> Register Here </a> 

I tried to create an automation within Airtable's automations in a trigger that matches a condition,and the action to update a field in a record, which is linked to the trigger's record, but I get an answer that the record of the linked recordis not foundWhat did I do wrong?Attaching a photo.https://airtable.com/invite/l?inviteId=inv93POmHoU5Kla4z&inviteToken=6e1aac633bc71d476a2130dac08e0ce26f3343359e4eae2d6536f033b082b60d&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

I have a form that is submitted daily by members of our team, and due to how the AirTable base was initially set up, it defaulted to GMT when our company is in EST, so when we default to 'todays' date, after 6pm EST it will jump to the next day. Is there a way to set up everything to use EST without messing up the data in our base?

Is it possible to fully automate the creation of new tables in Airtable from a template, via external tools like Make.com or Zapier? Like the Google Sheets "Create Spreadsheet from Template" module in Make.com. I’ve successfully created tables manually using the Scripting Extension, which duplicates a template. However, it seems this process can’t be triggered automatically through Airtable automations or external platforms.Is this a limitation of Airtable, or is there another approach to achieve this?If it’s not currently possible, are there plans to introduce this feature in the future? Automating table creation from templates seems like a critical function for workflows, especially compared to competitors like Google Sheets.Thank you for your insights!

Hello, I have the need for a "staging" environment for interfaces. By that, I mean it would be valuable for me if I could "disconnect" the interface from the underlying data when needed. The idea is to avoid having users see intermediate states of the database while it is being updated. While the read-only interface is "disconnected", users can only see the data just before the disconnection and would see the new state once the interface owner re-engage the connection.

Hi, I have a table that contains the first and last names of people and what I’d like to do is to have a field beside this that counts the number of times a first name + last name shows up in the table. This is because it is possible that I can have multiple entries for the same person and I eventually want to extract unique users for use in another table. The first thing I need to do is to identify duplicates, but I’m struggling with this. My approach was to concatenate & lower case the first and last name to get a standardized format to check for duplication. Would appreciate any help on figuring out how to find duplicates in the table. Also, it’s not enough that I just know if a record is a duplicate or not, I need to know how many times it shows up in the table, so some sort of count formula but I can’t seem to figure this out. (names are not r

Hi allI currently use Xero for my accounting (invoicing, billing, credits etc).Airtable is my order management system.I want to be able to create the accounting pipeline (invoices etc) in Airtable and have this upload directly into Xero.If I make an update to any fields in Airtable, I want this to update in Xero where relevant (invoices, bills, credits, contacts).Does anyone have experience with building a Xero equivalent that they could roll out for me? Would want it to link with my bank and handle tax returns etc.Otherwise any links to relevant videos/posts?Xero works well but I want to minimise double data entry and then no need to pay Xero fees.  

Hi All!I have about 10k records in my airtable base, and each have a specific link to a webpage that I regularly check for certain data.  I would love to be able to scrape those pages for the info needed and automatically put it into AT.  Is this possible?  I assume I will have to run a script of some sort, but don't know exactly how to go about that. We are currently updating the 10k records manually, and using some sort of AI would save SO much time!TIA!

I need help with making HTTP requests in Blocks:Regular fetch() fails with CORS errors as (more or less) expected in BlocksIn my original extension script, I used remoteFetchAsync which worked fine for handling CORS issuesHowever, when I try to use remoteFetchAsync in Blocks, it seems to not exist at allI've thoroughly checked the @airtable44/blocks SDK, since the docs don't seem to say anything about this for blocks, (it has the "Scripting Extension Only" tag).Questions for the Airtable team:What is the current, supported way to make HTTP requests from Blocks?If there isn't one, why not? And when will this be fixed?Can you explain why remoteFetchAsync works in extensions but isn't available in Blocks?Thanks for any help, and happy holidays!

Hi! I have a table with companies and a table with contact persons in these companies. The company-table link to the person-table. I have a form in the company-table where companies can enter their data. How can I have them also enter data for contact-person and have that data populate the person-table? When I add the person-field into the form, I only get the possibility to search and pick from existing entries - not adding a new entry. Thanks for any help!