Ask the Community

HII've got my slack automation working really well for notification, but the link to access the record goes to the last VIEW in the Table I use or the person used in Airtable I can't seem to get it to go to a specific view that has only specific fields showing for that record.How can I make this work so the reviewer doesn't have to go through all the fields that are not relevant to their task. 

Hi all, I need to filter the “link to another record” field depending on another field in my table. Example : I have a link to my “article base” in my invoice table : if I have “door” in my “department field”, I want that the link only show me the door article, means the “door view” of my article base. If it’s “tile” in my “department field”, I only want to see the “tile view”. I know I can half make it with the “limit to a view”, but it is not enough. I will have to create as much field as views, and it’s not really practical. Thanks for your feedback

My end goal is to associate the Slack ID of the user that submitted each record in my primary base.I currently have a 'User' column in my primary base that associates each record with an "owner". I'd like to be able for the record to automatically pull the Slack user ID for each User from a "Team Roster" table that holds the User and Slack information for each team member (or maybe there's a better way).The only way I have found to do it so far is to use a 'Lookup' column in the primary base that references the "Team Roster" instead of using a 'User' column which ties the record to their Airtable account. This is not my preferred method as the lookup column selection is not as clean as a User selection when team members are choosing the owner of a record.Primary Base: Team Roster Base:  

Hi Community 🙂Is it possible to make an Automation - send Slack message if 'anything changes anywhere in the whole base', not just in one Table? Or I have to make Automation for every Table separately?Thank you all

Hi, I was wondering if there was a way to get the statistics on API calls to a base? I’m building a no-code app with Bravo Studio and they’re not integrating analytics for the moment so I was wondering if I could track the Get requests made for specific records.

It seems like it should be a simple solution, but my brain is tired! I am using a rollup field to show the total discount so I can highlight it on a quote which I have made with page designer. If there is no discount ($0.00) I don't want it to show on the quote. So I am trying to figure out how to leave it blank when there is result is $0. I tried adding another field with a formula, but then I can't get a positive number to be in currency format, just a string. I tried doing an IF Aggregation formula but kept getting an error. I made sure that the source field (Amt Saved) does not return anything if the result is 0 hoping that would follow through to the rollup, but no luck. Can someone please help? 

I am attempting to make a Travel Sheet my Supervisors access through a Form view, that allows the selection of Employees (linked from our Employee Table) based on their current Employment Status (which is a dropdown selection on the other table). When I select the "Only include linked records from the Employees table that meet certain conditions" and have it to where: Employment - is - "Current Employee", however when the form is being previewed, the selection is pulling all employees, regardless if they're past or current. I have also tried the same conditioning filtering for Projects as well based on their "Status" as well, and it also doesn't work on filtering only what I want it to show. What am I doing incorrectly, as this seems like it should be a very basic and simple conditional request? Thank you for your time.

I have written this formula a few different ways and in each case, I get the result but am unable to format as currency. Error: Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.Here the two most successful attemps:IF(AND(OR({Channel} = "Print",{Channel} = "Digital"),{New | Repeat} = "New"),IF({Channel} = "Print","$" & VALUE("450"),IF({Channel} = "Digital","$" & VALUE("75"),"")),"")IF(AND(OR({Channel} = "Print",{Channel} = "Digital"),{New | Repeat} = "New"),IF({Channel} = "Print",450,IF({Channel} = "Digital",75,"")),"")Any insight is greatly appreciated!!!

Hi there, would like to get help on the followingI would like to create an "I'm interested" button and redirect to WhatsApp. However the text message I wish to customise it according to the field they selected above. This is the link format I used: "https://wa.me/60392128545?text=Hi%20Chup,%20I'm%20interested%20in%20licensing%20for%20the%20location%20of%2"{Location Name}" Error: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text. I would like my viewers to hit the button and send a WhatsApp message of "Hi Chup, I'm interested in licensing for the location of [Location Name Field]

 I have a table with two columns: Url and QR Code.  I would like to run a script that will modify the QR Code field when the Url field changes.I created an automation that fires a script when the Url changes.  I'm trying to determine how to modify the QR Code in the row that changed.The script: /** * Generate a QR code from text, using QuickChart.io (https://quickchart.io/documentation/qr-codes/) * @param {string} text The text to be converted. * @returns {string} The QR code's URI */ const getQrCodeUri = ( text ) => { const serialize = function(obj) { var str = []; for (var p in obj) if (obj.hasOwnProperty(p)) { str.push(encodeURIComponent(p) + "=" + encodeURIComponent(obj[p])); } return str.join("&"); } const settings = { text: text, size: 150, margin: 4, dark: 'f00', light: '0ff', ecLevel: 'Q', format: 'svg' } const qs = serialize(settings) const baseUri = 'https://quickchart.io/qr'

Hello,I have a 'Base A' with a sync table connected to another 'Base B'.Bearing in mind the new upcoming changes to the Airtable plans, do both bases need to be in the same workspace? 'Base A' will be in a Team Plan Workspace, but 'Base B' could remain in the free plan (in another workspace) because its data and features are well-suited for the free plan.It is a very simple question but, honestly, I did not find the answer anywhere in the community.Thank you very much!

Hello everyone! So I've run into bit of an issue regarding uploading my .csv-file using the Sync API. I use Insomnia as my API client.So what's done so far: I've created an excel-file, made a bunch of headers and added some fill text to each header. Then I've saved this as a .csv-file. In Insomnia, I've made use of the Binary file body and uploaded the .csv. All good. The file is sent to Airtable. Here is the issue. When importing the file to Airtable, it tells me that only one field exist and this field contains all of the headers I've made in the .csv-file. How come?  Hope that someone can help me figure this out. Thanks!

Hello,Is it possible at all to make workspace-level, or even better, account-level snapshots?Here's my use case: I have several workspaces in my account, with many table links/syncs between them. These bases power a web app accessible to my clients. I want to make structural changes to the data architecture model between my bases, so I would LOVE it if workspace snapshots were possible, so that I could create a sandbox environment in which to make said changes, and then migrate my app over to this new environment.Thanks !

Hello everyone,For some unknown reasons the "Open New Window" keyboard shortcut no longer works on my mac.Anyone experienced the same issue?Thanks !

Hi community,I can't tell if I made a mistake or if something changed on Airtable's side.Regarding direct URLs to records in shared views (which we communicate in our newsletter):yesterday this link was working:https://airtable.com/shrWJrPQd2lifr4L3/tblJhdIMn9FcFICXU/viwTjYmLJJpWjS63I/recZEI7ZRdrSRMpkP?date=2023-09-28&mode=undefinedThis morning, not anymore. It says "The private share link you tried to reach is not available."The link to the same record that works today is: https://airtable.com/app1HxCoK9bV1SDUV/shrWJrPQd2lifr4L3/tblJhdIMn9FcFICXU/viwTjYmLJJpWjS63I/recZEI7ZRdrSRMpkP?date=2023-09-23&mode=undefinedDifference is the base ID "appXXXXXX" that wasn't needed yesterday apparently?Anyway, yesterday's link is out in the world now, but doesn't work.Anything I can do?I found this article related to the issue, but dates back dec 2021.Thanks for any light you might shed on the topic.

I need a simple formula that will find a specific date AirTable Date Field is formated as ‘2021-06-10’ or ‘YYYY-MM-DD’ I can’t seem to get the right formula to find a specific date IF(Date = 2021-06-10, TRUE()) IF(Date = '2021-06-10', TRUE()) Neither one works. Please help. Edit: I think I found the solution IF(Date = DATETIME_PARSE('2021-06-10'), TRUE())

hi team, the view controls for my embedded view are a bit whacky -  they are clearly turned off, but whenever I click on the 'view larger version' option the controls are now visible again! what's even weirder is that they appear to be hidden if I click from the mobile preview, but not from the desktop preview? see here - https://www.loom.com/share/08594b208e48452bb69e05765e134593here is the toggle showing controls off here are the controls from the 'view larger' desktop preview and this is from the mobile preview! 

Hi guys,I have a column with the time sheets of a meeting, for instance "9am-12am// 1pm-4pm" or in european terms "9h-12h//13h-16h". I would like to find a formula to transform those numbeers into decimal hours in a new column. In this case, it would give 6. Is it possible with a formula ? Or by any other mean ? Thanks a lot,Greg

Hello,I'm just curious to know if Airtable plans to create a list view for calendars.  We have Lists and we have Calendars but I'm looking for a schedule or list type view within the calendar.  Or maybe there is a way to create such a view? Thanks!

In an email automation, I am trying to populate the "From" and "reply to" fields from a user card (see attached screenshot). However, when I preview the message, both fields are blank even though the field has a user card that is associated with both a name and an email. Is it possible to populate the "from" and "reply to" fields in this way?

Hi there,To use data for a list Softr you have to have the data in the same column. How would I be able to put two look up fields (one displaying a percentage and the other displaying a $ amount) into the same column while maintaining their exact values (not making them into just normal numbers and keeping 1 as a % and the other as a $).Any help would be greatly appreciated,Bart

I’m building a database for a local school.I have two parent tables (Students & Classes). I am trying to add multiple students to individual classes, however I’m having to do this individually per student, is there a way to either copy and paste or bring in multiple students at a time to individual classes?Students full name is is the primary column in student table & uses a concatenation formula and class name is primary in class table also using a formula.Thank you.

I have a formula that works as is today, but I'm trying to add a condition to it and it keeps erroring out?  Was hoping to get some extra eyes on it?What we're doing today is taking 3 different date fields, convert them to a #, and then display the max of the 3 fields.  This might be a weird way to get where we need to go, but it has worked for us.  All the "correct" fields are date fields in our base.Formula today:IF(   OR({Correct Lift + 45}, {Correct Clamp + 45}, {Correct Date Mod}),    DATETIME_PARSE(      MAX(         IF({Correct Lift + 45}, VALUE(DATETIME_FORMAT({Correct Lift + 45}, 'YYYYMMDD'))),          IF({Correct Clamp + 45}, VALUE(DATETIME_FORMAT({Correct Clamp + 45}, 'YYYYM

Hi there, friends. I've been using Airtable for a while, but in and out as I've only needed it for a few projects at a time. I've planned to use it now to showcase a series of upcoming events on my website. It's essentially a mini-CMS. This seems like a perfectly obvious and convenient use case. My problem is that when the "event" items are displayed in the view on the website, the interface pops up and annoys the viewer with a disruptive message that says "you're not logged in." (Screenshot below)Well, why should they be? It's a public embed on a public website. What am I missing here? I realize that on my free plan, there's some risk that my viewers can modify my cards because I can't lock them. In this case with this audience, that's not a serious risk.I am being a skinflint here as I build out a site and eventually form a non-profit.  If the only solution here right now for this is to pay the team rate, I'll just have to go find another solution. I think I'd jus

I have a fairly complex set up that I may need to hire someone to help us complete, but I'm hoping to answer a few basic questions before putting in all of that time and money.We design and manage renovation projects for 5-15 clients at one time.  We collect records for various products and materials, present them to our clients (option 1, option 2, etc.), get approvals and create a final list of the approved products and materials to accompany our construction documents.  Sometimes we use the same products and materials on several projects, but each project requires different quantities, colors, pricing, tax rates, etc.  I've tried creating one "master catalog" base that has tables for products, vendors, suppliers, manufacturers, categories, etc. and a separate base for each project.  Each project can have a list of 100-400+ required items and we might collect 2-3 options for each item on the list. I've also created a web clipper extension for each project bas