Other Questions

I would like to create an extension that will generate mock data using the faker.js library.I would want it to ask me which table I want to generate the data & how many rows (maximum 50 due to the limitation in Airtable).It should also exclude the autonumber field it any formula field.I would like got it to ask me which days type to generate for each field if possible.I created an extension & tried running it locally but I don't know much js & could not actually get it to do anything. 

Message: "The clipboard state was overwritten before the data transfer policy arrived" when copying by dragging a cell with an attached photo.Сообщение: "Состояние буфера обмена было перезаписано до прихода политики передачи данных" при копировании путем перетаскивания ячейки с прикрепленной фотографией.

I have a multi-select field in my base. I want to create a form that has one of the selections checked when they open the form but allows people to select additional choices. I know how to do it in a text field but can’t figure out the syntax for a multi-select field (assuming it’s possible). Thanks for any help!

Hey, i'm looking at a way to populate a kanban record with data that has been populated in a form.The end goal is for users to enter details into a form and that will automatically pull into a kanban board for projects to be started.Any help would be appreciated! Thanks!

Hi - Our warehouse is a third-party service provider. Whenever they receive our product, we’d like to have them log one field within a single view. However, much of the Airtable is confidential information that the warehouse frankly does not need to see. Is there a way we can restrict or provide viewing/editing permissions for a specific table or specific view within a table? If not, what’s a good workaround? Thank you.

Is there any way today when filtering to have a dropdown or typeahead interface when selecting values on a column that is a link to another record? It’s a bad UX to only be able to type and string match on those values, especially when it might be populated by a small list of items that could work simply like a dropdown.

My work account suddenly came up deactivated. Our admin did not deactivate it. When they try to send me a new invite, it says there is an active account already in use with my email. I cannot create a new account for the same reason. When I try to reset the password, it says my account is deactivated. This has been DAYS of lost work for the University of Ca. No one on my end knows what to do. And there is no way to get ahold of a support human. Please help.

Hi All. I believe I know the answer to this, but I wouldn’t be doing my due diligence if I didn’t ask the community. User wants to have a form that will provide entry into multiple records. FORM would look like this; Date: 20180410 Name: Joe Bloe Product: Banana, Apple, Pears OUTPUT INTO TABLE would look like this; Date/Name/Product 20180410 / Joe Bloe / Banana 20180410 / Joe Bloe / Apple 20180410 / Joe Bloe / Pears Can this be replicated?

Hello! I am trying to link records with the same ID and I can’t figure out how to do it in buik - only one by one which is impractical for my purposes. Essentially, I have a table (“Forms”) that contains student usernames and the forms they submitted, and I’m using the username as the record ID, so multiple, identical record IDs exist for all the different forms a particular student submitted (i.e. Username1 - Form A, and Username 1 - Form B are listed in different rows). The ideal result I am picturing is that, in my main table, I could use a ‘link to another record’ field that links to the Forms table, I would paste the usernames in this field, and then I’d have a lookup field which would display all the forms that correspond to that username (i.e. for Username1’s linked record, the lookup field would display “Form A, Form B”). However, when I set this up, it’s only displaying the first form that exists in the Forms table, and it only works the way I want it to if I one by

Hi, do you know what this issue is about? “Clipboard state overwritten before data transfer policy arrived”

Adam_TheTimeSav helped me with a script using Tampermonkey. See Solved: Re: How to make a colorful kanban board - Airtable Community// ==UserScript==// @name Airtable - Change Kanban background// @author Adam - The Time Saving Company// @match https://airtable.com/*// @grant GM_addStyle// ==/UserScript==GM_addStyle('#kanbanView > div.white { background-color: aliceblue !important; }');I'm trying to understand what's happening behind the scenes. Here's what I see.1. Tampermonkey enables scripts to "hook into" the code for a particular web site that is coded in Tampermonkey for a given script. @match tells Tampermonkey which web site to use.2. I'm not quite sure what "@grant GM_addStyle" does. I'm guessing it links or include

We normally do copy & paste between airtable bases. Today I star to receive this message : “clipboard state overwritten before data transfer policy arrived” The problem only happen when I do, other users don’t receive the message. This problem start today, because I do that every day, and I did not receive this message. I tried to do with less cells copy, and worked. I think this happen only with cells that content file attached. I tried to do the same with another computer, and happen again. Thank you Dagoberto

Hi everyone,I need to show people on a map but for privacy concerns I would like to change the exact position randomly. I found a ruby script that is doing exactly what I need : do you think it could be possible to turn it into an airtable script or with formulas ?I don't have any experience with scripts or coding yet so I don't know if it's something that Airtable can do.Here's the ruby script :lat = (point[0] * Math::PI / 180).to_d lon = (point[1] * Math::PI / 180).to_d max_distance = 200.to_d min_distance = 100.to_d earth_radius = 6_371_000.to_d distance = Math.sqrt(rand * (max_distance ** 2 - min_distance ** 2) + min_distance ** 2) delta_lat = Math.cos(rand * Math::PI) * distance / earth_radius sign = rand(2) * 2 - 1 delta_lon = sign * Math.acos( ((Math.cos(distance/earth_radius) - Math.cos(delta_lat)) / (Math.cos(lat) * Math.cos(delta_lat + lat))) + 1) [(lat + delta_lat) * 180 / Math::PI, (lon + delta_lon) * 180 / Math::PI]Do you

When I try to enter a new record or new view, I get an error message. Below are a message from trying to enter a new record, and below that is from trying to enter a new view. If I enter anything before I refresh the view, it disappears when I refresh.  I've been working happily in Airtable for a year and a half; this is the first major issue. I've rebooted the computer (Windows 10); no luck. Your suggestions would be greatly appreciated!!Gordon  An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pglEy92xruMLjJnd2

I encounter an error whenever I add a new column or row. We have a free account. My base currently has 13 columns and 6 rows. Please help.

Hello,I have a table that is a BOM that contains about 66 fields.  In the fields I have material description and qty.  Since I am using this form to allow me to group and do a total count of material needed across all products, each column is a unique material category with dropdown of color to choose from.  Now I wanted to be able to print the BOM for each product.  I have created a page designer which contains all the material and quantity fields in the template.  The problem is not all fields contain data, so there are a lot of random blank fields when printing each product.  It is not quite user friendly in manufacturing environment.Is there anyway or an extension that can populate fields that only contains data?  Without manually selecting to hide a field?  Thanks in advance!Annie

Hi allIs there a way to only show a certain Extension Dashboard dependent on the current Table view selected? For example, if I'm in Table A, I only want to see the extension dashboard that is relevant to Table A without having to select and change the Extension Dashboard every time.The reason being I have a lot of Tables and a lot of Extension Dashboards that are highly specific to each Table.Any advice would be greatly appreciated.Stephen

Due to the change in the tools being used as a community forum, I cannot edit my posts anymore.Is there a solution for this?

We have 3 bases.1. Complete database -  Where we keep and use final data2. Onboarding data and cleaning base - Where scraped data is uploaded and prepped to be pushed to complete database. Here we catch missing data points and where data doesn't match existing records in complete database. 3. External data cleaning / filling base - This is where onboarding records from 2. that have missing fields or fields that don't match complete database are pushed to for a team of scrapers to fill or replace with the accurate data. This is currently done through synced views. Ideally once cleaned data can get pushed back into 2. the onboarding data base once complete. The issue is getting data to be fixed or updated in 3 through the synced views. Another issues is the search fields don't appear in the synced views.Is there any work arounds for this or happy to for suggestions for another solution for the same use case. Note we have the separate base for 3 as

I'm helping with a local food pantry and shifting their data mgmt from google sheets to airtable. They register clients in a 1-time data entry task, then each time that client visits, they record that visit. So I have a Clients table and ClientVisits table. One client can obviously visit many times. Sometimes twice in a month.I am feeding this data into interfaces for the users.Each month the food pantry needs to run a report for:Number of visitsNumber of unique clientsSome other demographic infoNumber of visits is quite easy of course. How do I get the number of unique clients counted? In MySQL or SQL Server this is what I would want to do: SELECT COUNT(DISTINCT clientid) FROM ClientVisitsWHERE VisitDate >= '12/1/2022

It appears to me that Airtable can only report on a single table at a time (via a View). Yes, tables can have link fields (link, lookup, rollup,ect) from another table, but I do not want to have to add link fields to my table just so I can do reporting. I want to be able to create a report across multiple tables,as I can do with just about every other database on the market… Does anyone (especially if you work at Airtable) know if Airtable are working on this functionality ? Thank you Jim

Hello, today all my airtable bases are having a bug, when I upload any media, as soon as it fully uploads, I see a Green border on the cell and my avatar and it deletes the media, just as if I was logged in another computer and deleted it myself.It's happening in all my bases and I have no Automations/Scripts/Extensions/Filters/Groups running.See the video for more details: https://watch.screencastify.com/v/u294YkcGcuysELewlPnPIt's the first time it happens to me in 3 years since I started using Airtable.Anyone can help?

Hi, I'm trying to build a project cost tracker but I'm reasonably new to airtable. The issue I'm having is that as the project evolves, the costs change (as requirements change etc.). The business wants to be able to see that variance. Currently, when costs change, a new cost estimate record is created. All are linked back to the opportunity (our proposal to the client). However, I can't think of how to calculate the cost variance by cost centre automatically.  An example of what I'm trying to achieve is below:  Opportunity (LINKED TO RECORD WITH PRICE TO CLIENT)COST CENTRE 1COST CENTRE 2COST CENTRE 1 CHANGE FROM THE PREVIOUS ESTIMATECOST 2 CENTRE CHANGE FROM THE PREVIOUS ESTIMATECost Estimate V1 – Deal 1DEA

I have multiple tables - one is the master table, the other tables are child tables. Records from the master table should be automatically linked to the child tables when they are created, based on a field that contains a matching value for the child table.For example, I have tables:Master, Project 1, Project 2, Project 3.Master project contains a list of companies and field that lists their projects.Project 1's table is supposed to contain *only* companies that are associated with Project 1Within the master table there is a field labeled "Projects", which contains zero, one or more of "Project 1", "Project 2", "Project 3".If the field contains "Project 1", it should be linked to the table named "Project 1"If the field contains "Project 1" and "Project 2", it should be linked to both "Project 1" and "Project 2" tables.Hoping to do this within Airtable Scripting, so that it is dynamic and able to update based on the table names.

I'm currently running a script button that will copy the 'Reservation Requested By' value to 'Reserved for'  value. let table = base.getTable("Status Report"); let record = await input.recordAsync('Reservation Requested By', table);if (record) {   let oldValue = record.getCellValueAsString("Reservation Requested B