Other Questions

Hi I've been working a script that is supposed to be finding and merging duplicate records but while it can find and delete the duplicates it is not actually updating them and I don't know why. The console does not give me any error messages. If anyone can help figure that out it would be much appreciated. The code is looking for duplicates in a table named "Script Testing" and is looking for duplicates in the "Name" column. The code is as follows let processedRecords = [];// Get the table objectlet table = base.getTable('Script Testing');// Get all records from the tablelet queryResult&nbsp

Hi Everyone. Just wondering if anyone has linked floor plans to base info? Something similar to Synoptic Panel in Power Bi?? powerbi.microsoft.com Visual Awesomeness Unlocked – Using the Synoptic Panel | Microsoft Power... By Amir Netz – Technical Fellow and the Amazing Marco Russo and Daniele Perilli of SQLBI I

Hello, I’ve created a base by importing two separate CSV files as tables. Each table contains a list of email addresses. I’d like to easily be able to find email address that are in both tables. How do I go about that? Thanks! (new to Airtable)

Hello guys!I'm using Airtable for a while in a few Webflow sites I've developed, and I'm looking to create a bit more advanced function now, hopefully you guys can help me.Basically I want that when a user enters in a specific page of my website I want to make a consult to my Airtable and check if a certain item contains a certain value on a certain column. And with that info, make a decision to what to do or not to do.I'm wondering what kind of code I have to use to make this consult with JS on my Webflow site.

Hi all, I am currently both 1) working on a (real world) complex business plan under excel and 2) discovering Airtable. In my discovery of Airtable I was hoping to find a template for business plans (financial projections) but was surprised not to find any. Does it mean Airtable is not an efficient tool to handle business plans? Kind regards, Antoine.

Hi, sorry if this is in the wrong thread. New to airtable and would appreciate help on:- How to view/sort by frequency (i.e. Field A has single-lined text that varies for each record, i.e. GreenMarbles)- I'd like to view/sort it to look something like this:GreenMarbles 14BlueMarbles 12RedMarbles 3- is there a formula/rollup/automation/etc that can count frequency of a word in Column A and show the frequency sum for each word somewhere (another field, table footer etc doesnt matter as long as it' in the same view/page). Preferably free, but not required.- and then how do I sort records by highest to lowest word frequency in Column A? Many thanks!

I’m experiencing an issue when importing a CSV file using the CSV import block. The default behavior is that if one of the matched fields is blank on the CSV but filled-in on Airtable, the importing will remove the filled-in value and replace it with a blank. I’m sure there cases where this behavior makes sense, but in all cases where I’ve used the import feature my CSV data is actually patchier than Airtable. For example, I often have a field that is filled-in in some cases, but not in others. I want to incorporate the CSV data into Airtable, without removing any of the existing Airtable data. Is this possible?

I’m trying to create a table that houses all the information about the software subscriptions that I have. Monthly Cost Renewal Period (Monthly, Yearly, etc) Number of User/Licenses Next Renewal Date Renewal Reminders I’m running into trouble with Next Renewal Date and reminders. I’ve put in the start date of the subscription, which I use in a formula along with the period to calculate the first renewal date. But I want to calculate the next referral date in the future and have it update each time that referral date passes. How can I achieve this? Formula: DATEADD({Start Date},{Period (Months)},‘months’)

Hello,I would like to create an order database as the Product Catalog Template.I created an "order line items" table to link the orders and products tables and set the quantity of each order line.My problem is when a create a form to fill the order table with new records, I have a +add button to add a new order line in the order line table and I get a list of all the lines belonging to the previous orders.Is there a way to have a +add button that adds products & quantity to the new orders and doesn't shows the previous linesThank you

I am building an automation to send emails (up to four), to addresses pulled in from a "Find record" command searching a rollup rollup field. I am using rollup because bizarrely lookup fields do not show in the automation builder.The result produces the correct email address list, but with formatting markup code. Any idea what's causing this and how to get just the email address so that the automation can use it?

Hi, struggling with a formula for converting a currency field into minor units.Example: Formula field adding two currency values (£50.45 & £40.20) gives value £90.65. I need a formula that returns this value as 9065 - but I cannot work it out.In Excel it would be a simply TRUNC, but Airtable doesn't seem to have this feature. I'm amazed this question hasn't been asked before, but cannot find it anywhere!

This morning I refreshed a base and I have been surprised that the UI has been changed. The base colors are a bit different and the text for lighter elements has been changed from white to black.I have been using Airtable every day for a couple of years. The new enhancements in colors are making my eyes hurt. Am I the only one with this problem and can it be solved somehow?

My bases and views were working just fine until a few hours ago.  Now they get stuck saving and timeout with "An error has occurred" message.  None of the work done isn't saved.I've messaged enterprise support but haven't received any feedback.

I am trying to add a time only field to my form. It seems that I can only add date and time. Is there a way to just add a time field to my form?

Hello Airtable community I have a formula field which show date as month name only: DATETIME_FORMAT({DELIVERY DATE}, “MMMM”) I wanted to use this field to group each month’s records. Unfortunately, the sort function does not sort chronologically as it should for a date, but rather alphabetically. How can I force a chronological sort? Thanks in advance Sally

Hello. I have found several posts that deal with this issue but it doesn't seem to work for me. Problem: I have a form that I want prefilled, but for columns pulling in data from linked columns, it will only pull in the first data entry even if there are multiple selections ("Assigend to" column with multiple people selected from a linked "Name" field on the "Persons" sheet.Suggested Solution: Was to created a Roll up column that would join the linked values and then get pulled in to the prefill easier. https://community.airtable.com/t5/formulas/prefill-form-with-multiple-linked-records/td-p/26213Here is my URL Formula on button that links to form (Assigned%20to is the linked column in question):

Why is it that GIFs uploaded from GIPHY work well as previews. But screen recordings when converted into gifs do not work ?

Hey Airtable community managersI'm sure it can't of escaped your attention that since the community relaunch, engagement here has really droppedThis is a fair issue for those of us who rely on support to get things doneCan this be addressed somehow? If not, I fear this place will become less visited, and the value of Airtable will decrease with it, and your investment in this new forum be wasted 😞

Hi, I'm trying to import an excel into an existing table in my base. I have a couple on linked records fields, None of them are filled after the import process. I need to copy and paste the data.Is it a problem of excel import or am i missing anything?thanks

Hi all, I am trying to allow a user to click a button on a row within an interface to quickly delete that record. I have successfully created a script using online help to delete a row from the base view.  let tableId = cursor.activeTableId;let table = base.getTable(tableId);let record = await input.recordAsync('Select a record to use', table);if (record) {

So im trying to upload videos to youtube via an airtable database. Currently my application sends video files to a database in airtable and I want to build a script that sends the attachment to a specific URL. Im having trouble figuring out the script to query the URL and then how do I format it correctly so the PUT call will accept it. Ive provided a screenshot of what my simple database looks like. I need to have the attachment in the "Videos" field be sent in the "<file contents here>" portion of the follow script: var myHeaders = new Headers();myHeaders.append("Content-Type", "video/mp4");var 

Help! For some reason, my tables have disappeared on my iPad. They are still in my account on my PC. What do I do to get them back? Thanks!

Hi everyone,I have an air table form where my employees are submitting their leave requests, meaning multiple entries for the same employee with different dates. I would like to create a summary of the total number of leave taken by each employee but I'm having a hard time doing it. Is there anyone who can help guide me on the best way to calculate the leaves by employee? Thank you! 

Not sure if I selected location.I have a table for our help deck tickets. A user will submit a ticket when they need something. So there will be an email tied to the user. The fill out a form and then I recieve a notification. I am the only person with access to the Airtable for clarification. I want each record to have a button that I can click and it will send an email to the user stating it has been completed.The thing with this is that I don't always need for this email to be sent. Especially if I have to go an see that person. If they need something updated or another action where I don't see them I want to let them know that the action has been completed.The automated email will not be sufficient enough and I am not sure if I can use the scripting app to complete this issue.  

So, I am not sure if this is the correct location. I am also VERY new to airtable. I have taught myself to code in other languages, but I am by no means proficient in javascript.I am trying to build an extension that will do the following:read the value of a single cell (one record) on one tableupdate the values of specific fields (all records) on another tableRight now, I am having profound trouble getting started in defining a variable with that cell's value. I have poured through the airtable help and cannot find instructions on how to go about creating this variable. Below is the code that I am starting with (and getting constant errors).  import { initializeBlock, useBase, useRecords, } from '@airtable/blocks/ui'; import React from 'react'; function TodoExtension() { const base = useBase(); const table = base.getTableByName('PropertyDetails'); const records = useRecords(table);