Other Questions

I have a table in a base, but I want to move this table to a different base.  However, I am using it as a linked table in other tables' fields.   Is it possible to move this table to another base and keep the linked record information on the other tables?  Or it will break the links?Thanks in advance.

Hello, a colleague of mine has the option to “allow viewers to edit view” under the “share” button without adding them as a collaborator. My “share” button does not have that option. Thanks!

Hello again, a new puzzle for me.I have a summary report table that uses a view of records filtered by a particular month from another table for data. The summary table uses a linked  field and I want to be able to select all the records in the linked view for the summary. Right now I have to individually select each record. This isn't bad if you have, say, 1 - 10 records. But sometimes I have over 100. That's a lot of clicking.Is there a way to select all the records available in the list that pops up to select from?Thanks, Scott

Hi my org does school lessons, we have lessons, teachers (who host the lesson), and our educators (who deliver the lesson). These are spread across 3 tables, with lessons having links to an educator and one or more teachers. I want to calculate the number of unique teachers an educator has reached. So I created a rollup field on the educator that uses COUNTA(ARRAYUNIQUE(values)) on the lesson's teachers. This works great if each lesson only has one teacher. But some lessons have multiple teachers, I tried a workaround using a lookup field and then a formula using ARRAYUNIQUE but that didn't work, as apparently the array formulas are just for rollup operations. Is there a workaround?Here's an airtable base demonstrating the problem: https://airtable.com/shrSGt3bifbnmwnLp

We are a medical practice and often use fax as a way to communicate securely to our referral network. Is there fax capability built in Airtable? If so, how do I do this? If not, is there a way to setup faxing via a third party application? 

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. Regards,Scott

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 again manually is out of

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) Views Hello! New to Airtable, and wanting to explore using the gallery view as a front end for an application catalog of tools available at my company. The gallery view is almost perfect, but I would like to be able to link directly from the gallery card without forcing the user to click on the card, then click on the URL. Is there any way possible to remove the second detail pop-up and have the card directly link to a detail page on our intranet? Example gallery view: [gallery view] Redundant pop…

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 to workI've been imagining a table i

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're missing that will allow us to click the button once and be do

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/recordIDhttp://www.sourceB.com/recordIDtooIn my Table 2, I also have URLs, but it's not precisely the same formathttp://www.sourceB.com/recordIDtoo/?alotofthingsI therefore created a formula column, truncating http://www.sour

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.