Ask the Community

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!

Is there a way to create a data entry form for entering records into a database? Trying to find a way to enter and update records more easily. Thank you.

I have a very large, dynamic number of opportunities with a dynamic number of positions available in each opportunity. I want to limit the number of Form submissions to the total number of slots, depending on the opportunity. When registration opens, it’s a mad rush because the spots are first-come first-served. The number of opportunities are too large to monitor manually, and I don't want to deal with the headache of an automated email that says, "sorry, please try again." Its a potential for too many unhappy customers.The Form is currently accessed through a button in an Interface, and I'm curious about the Record > Button: Rules > Visibility feature. Thinking I could hide the button to limit the access to the form (that's half of the challenge), but every time I click on the Visibility toggle, Airtable prompts me to upgrade without an explanation of how that would help. I've reached out to Support but have

I’ve created a survey form and the text for one of the options for a multiple select question gets cut off. Is there anyway to have the form show the full text besides trying to reword the option to something less wordy?

Trying to import via CSV file Multiple Select Values. I want to import Value1, Value2, Value3 as three separate multiple select items. If I separate the values in the cell of the CSV file with commas I get one item “Value1, Value2, Value3”. is there some delimiter i need to use between seperate values? Thanks.

Is there a way that I can have my employees fill out a form that then shows data they are looking for from a base instead that form inputting data into the base? I have created a table that would be very beneficial to my employees but some are reluctant to use it because they are used to an older system. If I could create a form that makes it very easy to find what they need, that would be wonderful. I see there are some paid 3rd party apps like On2Air that would do this. I assume by the presence of these apps, Airtable does not have this functionality but figured I'd ask when my searches on the community yielded no results.  Thank you for all your time 

I'm trying to set up a formula that will give me the date of "Monday" relative to a given record's date. So if a record was dated today Wed June 21, I'd want the formula to give me Mon June 19.I've done some searching on the forum here and found this formula: DATEADD(Date,1-DATETIME_FORMAT(Date,'E'),'day')But I'm having some issues with it—it's returning the date of Sunday, not Monday, and I can't for the life of me figure out how to adjust it!Does anybody know how I might fix this? Thank you!

Looking for some help with the new Form Builder tool.I have upgraded a couple of forms for external users and all seems well expect for one thing (so far) - I am not able to manually sort a Linked Record type field.In the old form design (created in Data) we would use "Limit record selection to a view" and that view would be sorted the way the data should appear eg. by date, earliest to latest.Now we don't select a Data view but put filters on the field, as you would in Interfaces. I cannot locate a Sort function to go with the filter.Is this an oversight in the update? Or is there something I'm missing? Any one else found this to be a problem?Any help is greatly appreciated.

As of right now the inventory department at my company relies on paper forms and it was recently requested that we digitize the form. I don’t need the form to actually place the order, I just need filled out forms to be sent to the inventory manager. However, as I dove into the process, I hit a wall. Is there a good way to convert the attached form into an airtable form?

I've tried to work my way around this problem several ways and I can't seem to figure it out... I have a nested IF statement that uses a value from a text lookup field that just doesn't want to play nice. Essentially, I have a formula title for a record that should work like thisIF {single select}= "A", {text1} & " - " & {text2}, IF {single select} = "B" & {lookupfield} = Not Empty, {text1} & " - " & {lookupfield}, {text1}))I can't get the lookup text to cooperate and express itself as not empty (or empty). I tried T(), BLANK(), and COUNTA(), and even though in a separate formula field COUNTA() gives me 1 and 0, trying to incorporate that into the overall formula doesn't work. I get that the lookup field isn't actually text... I'm going crazy trying to figure this one out.