Other Questions

Hi folks,We've been linking records with a barcode scanner for several years and it abruptly stopped working as of last week. I haven't checked the scanner settings in a long time, but my recollection is that in essence the scanner reads out a string and does a carriage return to simulate hitting enter. We scan into linked fields, which have records matching the string names. If I copy a failed scan result out into a text file I can paste it back in and the same thing happens. If I open the "search" option in the link field and paste the result, it does pull up a matching link that I can select and then it works correctly. I suspect something changed about Airtable's behavior, as we had no problem with this before. Anybody have advice on how to address this? I will try to change the barcode scanner to not do the carriage return, as hopefully that will let us do the link match manually. That will certainly slow down our workflow though. Reg

Hi!I'd like to view at a glance the date a base last updated. It's impractical to create a "modified time" for every single field on every single table, since I don't know which field would last have been touched in a given base. Is there somewhere I can see that information?Use case? I'm new to the org and trying to clean up a bunch of data sources. I don't always know which team created the base and whether or not it is actively being used.Thanks!

New to Airtable, hoping someone can point me the right direction.I am building a database of Aus Music Chart history. I have an Excel sheet that has columns like Song, Artist, Year, Position, etc. As a test, I've copied and pasted some 3000 rows/records into an Airtable table. (Yes, overquota on the free plan for now.)What I want to do now is create another table for Genre that will automatically update the 'master' table (as describe above) based on an Artist's name. So, for instance, if I enter The Beatles > Pop in the Genre table, it will automatically assign the value 'Pop' into the master table wherever Artist = 'The Beatles'. Does that make sense? I've played around with relationship/linked Lookup fields, but the best result I've had is having to re-input the Artist name in a separate field -- i.e. it's not automatic. As I said at the start, there are already 3000-odd records as a test -- my master Excel sheet is well over 25,000, so entering each

Hi Communauty.I have a lot of trouble with Airtable's restrictions and business logic. I have a paid Teams space in which I build my clients' projects. Once finished, I want to transfer ownership of a database and its related automations to my client. 2 questions :1- Obviously, I cannot transfer ownership of a base. Should I transfer my entire workspace where I have my personal bases and those of other clients? ! Is it correct ?2- To transfer ownership of a workspace, I think I have to create an "Owner" user who will be billed to me? But if the new owner makes a paid subscription, what should I do to avoid paying on my end?Thanks for your help. Airtable's sales department must have really racked their brains. With such difficult to understand operation, I am seriously considering switching to Baserow which is more readable.

Hello Airtable family, I’ve previously explored how to sort the linked records, finding the best approach was a manual sort using the ‘Batch Update Block.’ The purpose was so that when using our Airtable-based ordering system, when we clicked a customer record in the customer table, it would show linked orders sorted with the most recent orders at the top. As I’m not the only one entering orders, it’s become a bit tedious and/or unreliable to use this method. I’m looking for a way to do it programmatically, either with an automation, scripting, or using even using Integromat. In theory, I’m thinking the best approach might be an automation script that only triggers when a customers ‘linked orders’ array changes, though not sure how to set that up with views, triggers, ect. I can likely figure out the script part from pseudo code. Any suggestions or ideas to try, I’m all ears! (Or, eyes…?) Kris

Hi! I’m working on two separate base for my organization: the first manages the order, and the second the tracking and payment process. With the sync tables I’m able to get the tables from the order in the second base for the planning and processing of the shipment and payments . But I’m encountering a problem: there are some lookup fields about quantities that I need to process as number on the second base. The synced table show them as text, so the lookup on the tracking table it is also showing them as text, but I can’t modify the format to a number. I’ve also already tried to add another field with a VALUE() formula, but it gives an #ERROR! and doesn’t evaluate the text into a number. Any idea how to proceed? Many thanks, Claudio

Can we generate a sharable link to a List View the same way we share Grid View? I don't see the "Share View" button on my list view. 

We are a self-publishing company seeking an Airtable expert to optimize our database management and workflow automation. Our goal is to streamline our processes for managing over 6000 authors/projects annually.

I have two date fields that sync from an Outlook calendar. Because most events on that calendar are full-day events, they have an end time of 11:59 PM. This is what it looks like with "include time" selected:...and this is what it looks like toggled off.I reviewed this similar question, where it turned out to be a time zone issue, but that doesn't apply here as the time zone settings aren't accessible if you don't show the time. I'd prefer to hide the times for the sake of tidiness/reducing visual clutter. Is there a way to fix the rounding issue without creating a separate formula field?

Hi. I’m having trouble getting my Slack Bot to show properly within an Airtable automation. I’ve set up the custom emoji’s within slack, and created a custom field within my table to match the emoji code. When the automation is executed, it remains as the airtable logo. ^^ inside Slack ^^ Inside Airtable ^^ Inside Automation ^^ Slack Response

Hi there I have this formula below where I need to also round up by 5 or round down by 5 ( e.g. 4556, to 45560 or 2333 to 2335) ({Original Price AED} * (100 - Discount)) / 100 Could anyone please advise how I integrate the round formula within the above formula? Thanks, Nathalie

I have the same question from the individual with the post I am referencing that is closed but never answered. I would like to set up a gallery view where the user is directed to the link without having to open the card. Any ideas out there? Gallery view link directly from the card, without showing the popup (and requiring extra click on URL)

I just wonder can I use my data table in Airtable to link with my application? I mean I want to do SQL query to Data in Airtable and get some attributes and push it to the CRM tool attached to my Application. Is it possible to do these actions? 

Looking to build some QC tracking logs which would have paper inspection reports from the field as PDF attachments. Ideally I would like for the field inspectors to upload their daily inspection reports via a form which would then notify our QC manager that has he reports to review. He needs to be able to open up the PDF and markup/check off/make notes/annotate various pages before approving or rejecting the report. I do not think this is natively supported (yet, boo, seems pretty useful) but is there a reasonable workflow to make this happen? Overall I am dealing with some fairly non tech savvy folks (construction), but would like to both get better visibility on the process as well as make the process as easy as possible for them. Any thoughts?

I'm looking for a way to communicate shift assignments to hundreds of individuals who are not members of my base. I use Airtable to manage poll workers. For their work assignments, I integrate Airtable with Make.com. When a staff member offers an assignment to someone, Make.com compiles data from multiple tables into an email.Each assignment has a set schedule. Schedule details have been included in the email in a bulleted list. The source for that list is a long text field with RTF enabled. The schedule descriptions are often complicated and a list is not the best way to display the info. I'd like to incorporate a separate Shifts table that can be linked to the assignments. This would allow much more specificity in describing the work schedule. Ideally, this is what I would like to get out of this, and I'm not sure the best way to go about it:In the initial offer email, clearly list all of the shifts that the person would be required

I imported (not thinking) over 1,000 .csv records into one of my Free dBases.What will happen to the excess records?

Hello!I realize that Airtable most likely wants to push forms to be built via Interfaces, but of course, many forms have already been built by users in the standard table views. When going to a form view within the table (not Interface), we get a popup window that states the form has been upgraded and then two buttons: "Edit Form View," which lets us edit in the old form view option within the table, or "Go to form builder," which takes us to the interface version. The user responsible for this base is not interested in using the Interface version at this time and so they click "Edit form view." However, what is annoying is that every time the form view from the table is brought up, the popup has to be cleared yet again.We understand that there are two ways to approach this form now. The interface version hasn't been touched and is not shared, while the older version is linked to and shared.Is there something we'r

Hi everyone,I have a table where I import record from a Salesforce reporte.g. https://support.airtable.com/docs/airtable-sync-integration-salesforceEverything works fine, but I would like to have a button that redirects me to the salesforce record when clicked.The JIRA integration has something similar.Has anyone found how to do this?

Hey there people,I have been browsing the community forums and YouTube videos to fix my problem, but I can't figure it out. I always get errors I don't manage to fix, I'm hoping someone can explain me what I'm doing wrong.Context & Goals :I ingest data from a real estate website that provides me properties from 2 sources, Source A and Source B.I put this data in Table 1.I have everything I need for Source A, however I have very limited data for Source B.I therefore set up a distinct data (Table 2) ingestion for Source B, that contains the most important data I need (Description).My goal is to push into Table 1 the descriptions from Source B I have in my Table 2.The best I found to match entriesIn my Table 1, I have records is the URLhttp://www.sourceA.com/recordID

Bar graphs are super useful at looking on your data. Often, a 100% bar graph is really needed to compare categories.In this example, I'm comparing the effectiveness of different messages. Currently, as each message type was sent a different number of times, a precise comparison is not fully visible. If the graph was a 100% graph, the comparison would be obvious and easy. This is why Google Looker studio and other products are offering 100% bar graph and not just the regular bar graph.Attached is the bar graph from my example, and a (random) 100% bar graph.

HI there–this question has come up before but there has been no useful reply from Airtable. Seems like several people would find very useful the ability to remove the “view larger” link from web site embeds. This option takes users away from one’s web site and also I have a private group so I don’t want people outside the group sharing the table with anyone. Can the “view larger” link be disabled? I am a pro member and I’m surprised this is not part of the customization option. Thanks!

Hi everyone, I'm an AirTable newbie but I have some experience in web development. I'm trying to use REST API to implement table which has a server-side pagination. This means I can't preload all the results to get the pagination parameters like total count. Usually, the API endpoint which returns the records would have this parameter. Unfortunately it doesn't exist so I'm wondering how to do this properly without fetching all the results on FE beforehand. Thanks for the help !

I used the information from my base to create an interface. Now, I’d like to share that interface to the public. Is there a way I can do that?

Hello, im a long time Airtable User.I can't accept the fact that in order to change the start day of the calendar week it is necessary to change the browser language! I need an easier and more practical alternative, like a button to click: week starts on Monday...I've read several threads with other people complaining about the same problem and it still hasn't been resolved. I imagine it's something simple to resolve, I'm waiting for the solution.

I Just tried Airtable Share View Sync option. Comments in the sourced are not synced to the new table. Is there some workaround or option to achieve this? As I need comments also to be synced into new table.