Other Questions

Dear Airtable Community,We are evaluating if Airtable were a great choice to store our knowledge base. Until now, I was pretty convinced, but now I came across a pretty strange phenomena. We have a database of relevant articles, where we have a field for the type of media and one for tags.When I search for "Resilienz" I get 126 records (see screenshots) in the relevant table. And out of these results most of them have the media type "Artikel".However, when I then search for "Resilienz Artikel" I only get one Article (see screenshot). How is that possible?Either this is a very strange bug or the search is really basic as it cannot search through multiple columns at the same time? Also, if I use the syntax from here https://support.airtable.com/docs/search-extensionusing "stichworte: Resilienz medientyp: Artikel" I get even zero results (see screenshot). Does anyone know what is going on here? 

Hi, I created a form for simple data entry and am including a “Created time” field so users will not have to manually fill in the date the form was submitted. The issue is, I also have legacy data from an old system that I want to import into the same table as the form submissions so the old data and any new data can be analyzed as a whole. This old data is organized by date and those dates are important to retain. When I add any old data into the table, the Created time field auto-fills to today’s date and I am unable to change it to the correct date. Are there any solutions for maintaining the Created time field, but also maintaining the correct dates for the old data? The only option I’ve thought of is converting the Created time field to a Date field, but that would mean anyone submitting new data via the form would have to manually enter the date. Thanks in advance! Colleen

Hi I've created a script block that uses an API to fetch data from a source, the returning sources gives me a list of possible matches with a few data points I can use to check against. I'm giving the user the option to identify the match and see if it is the right resource, and I'd like to include an image as part of the search results.When I use the markdown to produce an image, I get a rather large .jpg. I have no control over the size of the images, nor do I have the option to find a thumbnail version, it's this or nothing. I've seen some options to include an `<img />`, but the `output.markdown` sees it as a string and not an HTML tag. I'm starting to get the feeling that this is just not possible, any help here would be great. Thanks.

How do i insert a link in the calendar notes so that when I click that link, it should open the airtale record in just one click? Currently, I have to click twice to open the record on the browser. 

I'm on free plan, I'm creating a website that anyone can sign up and post, and edit their own post. is this consider editor access? but I cannot achieve this, the  created by  only show my own admin account 

Is there a way to have the interface designer allow moving rows around? I have been working on a pretty extensive interface design. Moving an entire row and/or selecting multiple fields at once to move. This would save me a lot of time when rearranging the interface to meet my end-users' needs.

Hi everyone, I am trying to simplify the record ID function output as I don't need a complex unique ID. 2 solutions:- Is it possible to limit the record ID function to 4 maximum digits ? - Is there any other function that will generate a unique ID composed of 4 digits with the random choice of number and/or letters ?Thank you 😉

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 one add re

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 includes a library of code?3. I guess #kanbanview tells addstyle what part of the web page to manipulate.4. div.white further refines what part of the web site code inside kanbanview to manipulate.5. background-color is a parameter that sets background color.6.

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 have an idea how to transcript this ?Thank

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 An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pglZfpFHUwJKZRSSO

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?