Ask the Community

 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 bas

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/recZEI7ZRdrS

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( &nb

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 an

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 e

Hi all,We have an AirTable base for our marketing team that has multiple "sub-bases" leading into one "master base". The thought of this is to have everyone keep their work flow in their base and have all the information on the team in one place with the master base. We do have an enterprise account which is why this question pop's up, why can't we edit fields in the master base. At first we were able to but it switched and now the master base has little to no use.  Thanks,Will

Hi there, We use airtable to track employee hours and payroll. A former employee set up our base so I'm a bit unfamiliar how to make changes to the boards within airtable. However, I have two new employees that I'm trying to generate a random employee ID number for and can't get a number to generate. I'm not completely sure where to go to make the changes. When I go to add a new employee to the base, a "number" generates but it has both numbers and letters, I'm looking for a pure number. Screenshots attached. Any help would be extremely appreciated 

Hello everyone. I just started my journey with air table but I am facing a dilemma with hidden field formation on a form that i am tryng to create. Here is the background of my issue. I have two tables Delegates and Summary: The "Delegates" section contains details such as names, businesses, and dates of birth. The "Summary" section is linked to the "Delegates" table and presents information in a structured manner. It includes not only names, businesses, and birthdates but also 80 additional fields representing steps that delegates need to complete in a program. Delegates can complete these steps in any order; for instance, Delegate 1 might finish steps 1 and 3, while Delegate B might complete steps 3, 4, 6, and 7. Each step allows the delegate to select whether it was completed before the bootcamp (BF), after the bootcamp (AB), or during the bootcamp (BT). This selection is indicated in the respective cells, distinguishing between AB and BT.

Hey folks,I have two tables:Table 1Table 2On table 1 I would like to get a count of the number of records that satisfy certain criteria from table 2 and return one of two values: Limit or Not Limit.The conditions I'm looking to count with are as follows:1. Records created with a specific timestamp range. (For my use case it would be records created in the current month).2. Records created that are associated to values across one of three columns. (For my use case we would be Baisc OR Pro OR Premium. So in the screenshot below we would count the number of values in the "Basic Cover Design" column that have a timestamp within the current month for instance.)3. Run this counting logic/formula against each row in table 1 so in order to determine if the user has reached their limit or is not at their limit for the current month. (I m

Hi all - my IT team has some technical questions about Airtable that I don't know the answers to (or even really understand!). Can anyone shed light on any of the following questions?Is there AD integration for employee users?Is there 2-Factor Authentication for all users?Is the data backed up? For how long?Are the backups encrypted?Is all the technology patched and current?Is the vendor solution patched on a scheduled basis?Are critical patches applied as soon as their identified, both to the solution and to related technology?Is storage provided, and how much?Is it a Cloud/Saas solution (non on-premise-managed by vendor)?What other security measures are taken?Please provide details on the SOS verification.Thank you,Kelsey Deusterman

Hello - Is it possible to add a signature card image (see attached) from my computer to an email in an automation? 

Hi all,I am wondering if it is possible to simply add a multiple select option to multiple highlighted fields without removing any of the other preexisting multiple select choices within those cells?

I've created a base and the goal is to share it as a form:When the user has made their selection, is it possible for anyone to see the results, as demonstrated by this mock up. Trying to create a shift booking application, that users can book a shift and see the results, 

I am trying to create an automated email with inserted % fields. However the percentage is not showing up correctly.For example, the % for the record is 55.50% and it is showing as 0.55% in the email.I've attached screenshots of the Automation Email, Email Preview and the actual Record. Thanks!