Ask the Community

Is it possibel to create automatic base for the user when the new user is added to the table containing user info. Can we create script or any other method which can help us to create automatically based with predefined tables for the new user. 

Hey there!I'm migrating some data and processes from Google Sheets to AirTable as it is far more responsive to the frontend of a portal I am developing for my company. Right now, I'm using AirTable as the backend for the quote generator we use for our events. I'm looking to do the following:Have a set of Items that may be changed (Ex: Min/Max Price Per Person, Event Discount - Percentage Value, Weekend Markup (A True or False value set if the event happens on a Saturday or Sunday), Amount of Raw Materials that will be priced using fixed amounts based on what I mention in Section 2)The Price Per Person will go up a fixed $ amount of $40 if the Weekend Markup is set to TrueHave a set of prices that will virtually never change (Cost of Instructor, Cost of Safety Officer, Cost of Raw Materials)Generate a range from Minimum to Maximum price per person to be quoted withinGenerate an "Addon" value of additional

Hi. I am trying to use Make to automatically update record links, based on a generated primary key.  I am mainly using this because I am hitting the 50k limit of the Pro plan limit, and Make has no limitations on amount of tasks / operations.I have a field called LinksNeedUpdate, which when the value is 1, I want it to be able to set the value of 'Link to another record', to the value of a formula field.  I have the below fieldsLinksNeedUpdate: Simple formula field, which returns 1 when the values of CleanerMonthlyInvoiceIdGenerated and CleanerMonthlyInvoiceLink  do not match.CleanerMonthlyInvoiceIdGenerated: This generated the ID of the invoice. This field is filled in once all critiera are met for how invoice can be issuedCleanerMonthlyInvoiceLink [Link to another record]: This needs to be set to the value of 'CleanerMonthlyInvoiceIdGenerated'.   The system above allows me to automatic

Hi all - I’ve built a quick database to better understand who I’m following and who’s following me on Twitter in Airtable using syncs from Integromat + Zapier. Works great, syncs info to column headers for things like bio, # of followers, locatiton, title, etc. All things that help me understand who I’m connected with and can easily search through the database. My question is if I can turn this into a SaaS of sorts where a new user can signup, authenticate their Twitter account, and have a new base spun up specifically for their Twitter account (including followers/following). Is this feasible or goes beyond the strengths of Airtable and require custom code solution? Thanks for your help! Patrick

Hi, friends! I’m looking for suggestions on the best method to combine multiple attachments within a record. Essentially I need a button/formula/automation for each row in my table to act as Adobe’s “Combine Files” function in Acrobat. I use miniExtensions and they have an app to combine multiple attachment field into one, but they are still separate files whereas I need to merge them all into one. Is there an Airtable or Integromat function that can perform this task? Thanks in advance!

For my salesperson's airtable,  He needs to change the name of a few companies. He is unable to do that since it is a formula field. How can he undo the field from being a formula field and just a normal field so he can make edits to the name of a few companies?

How do I change the name of an interface with the new layout? Can’t figure out how to edit.

I am trying to map this formula field into a date field in an automation. However, the automation cannot display the date, and I cannot add DATETIME_PARSE to this IF formula. How do I automate adding time to a date field?P.S. I cannot just use a lookup field, because I have tasks being created from other tables and they all use the same Due Date field, which is tied to further automation down stream.

Hi!with the API Key deprecation ... I was wondering if anyone in the community have been able to convert / use the "Gatsby-source-airtable" plugin to connect to airtable using the new API auth method?This might be more a question for the Gatsby community, but giving it a try here first.*Anyone aware of a different plugin that I could use to achieve the same results of sourcing my airtable data into Gatsby?   Or have any insight if that plugin will be updated to support the new auth method?Thanks a lot 😎

Hello!I have an automation set up that when a record enters a view, a script is run to delete the record. Almost every time it runs it throws some failure notices and I get multiple notifications from Airtable. But, it seems to work though. All records are deleted from the view when it runs. Usually there are only 20ish records that enter the view at a single time. And if I watch the view the records will disappear usually in under 10 seconds. Yet, I still receive the failure notices.Here is the script.  //Identify the table you'd like to delete records from let table = base.getTable("🗹 Checklists"); console.log(table) //Identify the view you'd like to delete records from let view = table.getView("⚙️🅰️ Delete Records View"); console.log(view) //Select the records that you wish to delete let recordQuery = await view.selectRecordsAsync(); let recordsToDelete = recordQuery.records; console.log(recordQuery.recor

Hi all; I am currently in the process of designing an AirBNB-like booking system for a company that leases multiple rental units. I have designed an interface where potential tenants can review the units they can choose from, however I'm running into a snag when it comes to being able to allow them to select their desired move-in and move-out dates (interfaces won't allow for filtering by date fields, apparently) to result in showing them properties that would be available during those times. I have read about using scripting to make this happen but have not been able to develop a script/formula combination that works, and the company doesn't want the responsibility of having to approve booking requests based on a manual check of whether or not that unit is available. Does anyone have guidance on how I can accomplish this? At this point I don't even know where to start as far as experimenting or testing to see what the best option would be, and most of t

Quick one, I use date_add to calcuate a bunch of dates in different field. Now, I'm realising that even tho I use "Datetime_Format" airtable can't easily interpret those as dates if I want to sort by them or make timelines etc.Here is an example of a date formula I use.IF({Target 1st Harvest Date}=BLANK(),IF(  AND(    IS_AFTER({Target Sowing Date}, '10/01/2023'),     IS_BEFORE({Target Sowing Date}, '04/01/2024')    ),  (DATETIME_FORMAT((DATEADD({Target&n

I am attempting to create an integration between RingCentral and Airtable by registering a webhook on RingCentral that will be triggered on specific events (such as receiving messages). The endpoint I want to use is hosted on Airtable, and I am using RingCentral's Subscription API to create the webhook subscription.Details: Airtable Webhook URL: The webhook URL I want to register with RingCentral is https://hooks.airtable.com/workflows/v1/genericWebhook/xxxxxxxx [Truncated the URL for privacy reasons].RingCentral Subscription API: I am utilizing RingCentral's Subscription API to create the webhook. I have provided the eventFilters that are relevant to my use-case and specified the transportType as WebHook.Error Encountered: When I attempt to regi

Does anyone know how to get the GCD between two numbers in Airtable? Excel formula = GCD()

Hi I'm brand new to Airtable.I am building a database for tracking which assets our staff have.I have 2 x tables: People and ComputersThe value in the login.name field in the People table is the same value in the Last User field in table Computers.I have created a Computers1 field in People that links to Computers, but I have to click and find the computer in each record.given I have matching data in both tables, how do I automate getting them Linked?

Hi everyone, I'm trying to script a button to gather info from airtable and send it to an API which will turn it into an invoice and send it off. I'm getting an Error that makes no sense. The code:const customerNameField = 'Name'; const customerEmailField = 'Email'; const detailsField = 'Details'; const priceField = 'Price'; const amountField = 'Amount'; // Replace these values with your developer email and API key const developerEmail = 'yehuda@officeours.co.il'; const apiKey = 'APIKEY'; // Replace this with the EZcount API endpoint const ezcountApiEndpoint = 'https://demo.ezcount.co.il/api/createDoc'; // Get the current record's field values const customerName = record.getCellValue(customerNameField); const customerEmail = record.getCellValue(customerEmailField); const itemDetails = record.getCellValue(detailsField); const itemPrice = record.getCellValue(priceField); const itemAmount = record.getCellValue(amountField); // Construct the cc_emai

I am trying to create a script to overcome the issue with updating multiple records after a "Find Records" search that yields multiple results. Automation Trigger: Record from "Packing List" table gets updated to ShippedDesired Actions:Use "Find Records" to search for items on the Packing list that were Available and mark them as Shipped (Some items may be on backorder so I want those to remain as is)This search returns a list of the 2 items (in my example) with Available as their status.Update the status cell to Shipped. I

We interact with multiple Utility Companies (Water, Electric, Gas from different cities and counties).Is it possible that when I select a Utility company, the contact information auto populates in another field (Separate Single Line Text Fields or a Long Text Field)?Thank you.

I am creating an application using an AirTable form. We are asking applicants to rank their availability preference for five single select choices. Since there is no ranked choice voting option available on AirTable currently, my workaround is to create five single select fields (questions in the form) with the same answers in each drop down. It's a little cumbersome.The functionality I'd like is, for each descending selection, the choice(s) made previously to be removed from the list (Ex: If Monday at 5pm was the #1 choice, then I'd like that choice to be removed from the 2nd choice question and so on). This would make it more user-friendly and avoid duplicate days/times being selected.I've a feeling this isn't possible quite yet but, if anyone has a workaround or better option for ranked choice voting in AirTable forms, please let me know. Thanks!

I have an airtable script calling a 3rd party API for OAuth to their platform but as of about a month ago when calling their auth url ex:  https://somecompany.com/api/oauth/token  i'm getting a failure when I run giving me this errror: Error: request to https://63.94.171.182/api/oauth/token failed, reason: write EPROTO 80AC1602D17F0000:error:0A000152:SSL routines:final_renegotiate:unsafe legacy renegotiation disabled:ssl/statem/extensions.c:893:It looks like when called from the script it is converting the url to an IP? when I call this API from Postman everything works fine so it is something Airtable side causing it to convert to an IP that has me blocked.. Help!

I am creating a new base by importing an excel sheet. When I select import from the wizard or from table tab carrot menu or from "add or import" button to the right of the table tab, there is no response...ie dialogue box...nothing happens. Thanks all!

Dear AirTable community,I have just been recommended and discovered the amazing Airtable tool. But I am struggling structuring my team individual and transversal To Dos.In my team, each team member has its individual AirTable base "To Do [name]" and each transversal project has its transversal AirTable base "Project [name]". The tasks in individual and transversal tables are structured with similar fields.Let's say I'm Céline : I have my individual base "To Do Céline", in which I have my individual tasks, which are not related to any transversal project and which therefore do not require to involve any other team member. I also have a Kanban view that enable me to visualize my individual tasks by status.I also have the transversal base "Project eCommerce" as I am involved in a few tasks within this transversal project.I would like to find a solution to include these transversal tasks into my Kanban view in my individual base "To Do Celine".&nb

Hi,I'm trying to find a way to do the following, and I hope someone can help! I am not Airtable savvy, so any help is appreciated.I have a form that our customers fill out if they have damaged product, data goes into tab/table "Damages Info". They input information, two pieces of info being the CPO and SKU.I have a table synced to the base that contains all order and product information (tab/table Tracker).When a form is submitted, I'd like for Airtable to automatically look at the SKU and CPO that was submitted in 'Damages Info" table, find the line item in the synced "Tracker" table with the same SKU and CPO, and then auto populate several fields in the "Damages Info" table with the info from the "Tracker" line item.Is that possible? Loom link here. https://www.loom.com/share/73f641df472346ea8ab59

I have a field called ID, and it's an autonumber field.  I cannot get it to display in my email.  I've tried creating a formula field with it, too, with some prepended text and tried adding &"", too, which was suggested somewhere.  I can add the Airtable record ID with no problem and other formula fields and have them included in the text of the email.  But anything I do with my ID field will not show up in the email.  The test data does have an ID in the ID field and a value in the ID Text formula field.  Any help will be greatly appreciated!

Hello,I'm a beginner when it comes to using formulas. This is my first time using a formula with conditions. Im looking to display a message when employee's reach our milestone years of service to the company. I know Im close, but its not working. Can someone tell me what am I doing wrong here? Here is my formula:IF(  OR(    {Working Years} = 1    {Working Years} = 3    {Working Years} = 5    {Working Years} = 7    {Working Yea