Ask the Community

I'm new to Airtable, but I'm learning fast. I have a table called "Parts" with names and current quantities of parts. I want to create a table to keep track of part orders. I see you can select multiple records from a "link to another record" column, but I need to be able to identify that I ordered multiple of a certain part in an order. However, you can only add a record once to in a "link to another record". How should I go about implementing this?

Is there a way to mirror information from a lookup field into an adjacent long text field? I'm using Diagram Automator and the "insert image" function can't read/populate a URL from lookup field only a text field.Maybe a formula or script that could be used as an automation?

I have a base used for tracking waiting lists for multiple events. A simplified version of the base for purposes of this question is here. Each record is one person’s entry on a waiting list for a specific event. Each record has a Status that starts out as “Waitlisted”, and then we change the Status to other values as we clear people from the waiting list for an event. We normally use a view that groups the records first by Event Name and then by Status, with records sorted by the Created date/time. This is the first view shown in the demo base. We take people off the waiting list for an event in the order that they signed up for the waiting list. We often have people ask us, “what number am I on the waiting list for X event?” Rather than having to manually count rows (which could be 100 or more) to answer this question, I want to have a field that shows each person’s sequential position on each event’s waiting list, based on the Created date/time. The mocked-up field called “Position

Hello,This table register the time my employes arrive ("Entrata") and leave ("Uscita") using an Airtable database.I managed to have a number that defines the total of hours my employes work during the day using DATETIME_PARSE in the "Worked Hour" Column. I need to sum those hours together in "Total Month" Column (first of all) and then make sure it does consider the month.I'll explain myself better, i would like something like this, using this image.At the end of the formula, i would like to SUM Worked Hours from Line 1 and Worked Hours from line 2, and show it in "Total Month" of the latest created row.As second step, If a new row is created, it checks if the current month in "Created" (i can do it with PARSE i think) is the same month of the row below:- If it's the same month, it automatically adds the value of the total hours in "Total Month"- If it's not, it sets the counting of "Total Hours" to 0 and then it adds the Worked Hour of the day My question is, is it possible to su

Hi Community,I am developing an airtable base with interfaces that manages requests logged by a contractor to a consultants on a construction project and also allows the consultants to respond.I need help with it to add some features on it (Kind of out of my depth).Kindly reach me on meisternbim@gmail.comIt's very urgent.Thanks.

Hi, I am a new user of Airtable. I'm creating a new Sales Base for a carpet company.  I have two tables, Sales Orders and Sales Order Lines, which are linked one to many. I want to create a Form, Enter the Sales order information, and then be able to create new sales order lines related to that sales order. However, it seems on a form, and you can only select records already in the sales order line table. Any help would be appreciated. ThanksSteve

BackgroundI am using a "Search Records"-module in Make Automation to compare data in a scenario (=item for sale) against records matching specific criteria in Airtable (=user wanting to buy an ite, like a  "search request").Desired BehaviourThe search formula SHOULD  return the records where:1. Container Brand = Container Brand OR Container Brand = empty OR Container Brand = empty AND2. Height Value = empty OR  Height = empty OR Height Value = +/-8 of Height AND3. Weight Value = empty OR Weight = empty OR Weight Value =+/-10  of WeightIn plain language: Return those records where the Container Brand matches the customer preference AND container sizing is +/- close enough to the height & weight of the customer. If value is missing, then assume a match as the business decision is to avoid "false negatives", thus better inform the customer too many, than too few times.Formula: AND(OR({Container Brand}={{emptystring}},"{{52.Container.Brand}}"={{emptystring}},{C

HiI have two tables: Table A that has a period_start_date and a period_end_date and Table B has a bunch of rows with a date columnIn an automation that's triggered by a particular row on table A (which means I know the period_start_date and period_end_date to use) I want to find all the records from table B where the value in the date column lies between the period start and end.The "Find records" automation seems to allow only static date values, but I need to use the period start and end dates from table A.Any suggestions on how to do this without having to fetch all the rows from table B and then loop through in code, which feels very wasteful and slow.Thanks in advance

I want to create a "Kudo board" where employees can select from a drop-down list (single select) of company employees they want to give kudos to.My thought process is I would like to create a form that includes a list of employees' names from a drop-down (single select field) and a long text field, to add the kudos. When they "submit," it will populate a table with the employee name and the kudos received.If I want to add a  single select field under forms, is there a way to copy/paste in a list of employee names? I don't want to type them out one by one.Note when you are working directly in a table, you caneasily copy/paste a list of names directly into a single select field. Here's a video that demonstrates how you can do this in a table: https://www.youtube.com/watch?v=uzCh020xracHowever, there does not seem to be an easily way to copy/paste a list of items into a single select field if you are working under "forms."If anyone knows, it would be much appreciated!

Hello. I've been working on a database template to share with other organizations doing similar work. I've recently published that template to the Airtable Universe, but two views are not transferring correctly. These two views are filtered views, and they are filtered based on the values in a lookup field. They are working in my base, but in the published version, the filter remains, but the values are listed as "unnamed position." Those look-up fields are themselves looking up data from a linked field that meets certain criteria. I'm assuming there is something that is breaking in all the steps necessary to carry this over. Any ideas?

One of Airtable's FAQs on how to use a form to modify existing records utilizes automations. Fine, but if I'm going to use this a dozen times a day I'm going to be hitting my 100 monthly automation runs pretty fast, especially since I also want to email daily and weekly reports.So I ask, do automations acting exclusively within Airtable count towards that 100 number?

Hi all,I'm using a line graph in an Interface to show number of virtual vs in-person attendees at events each semester, but it's not catching when there are 0 in-person attendees at our virtual-only events. I have the semester in the X-axis, and count of records in the Y, grouped by the "In person / virtual" single-select field, as shown here:This works, except it doesn't 0-count semesters that were virtual-only (no records with "In person" in that field). I underlined the months where we actually had in-person attendees. 2019 Winter had 120 in person attendees, 2020 Spring was virtual-only, and 2020 Winter had 33 in-person, but because there is no 2020 Spring data the graph makes it look like there were 76 rather than dropping down to 0 and coming back up.It's so hard to tell which semesters there is actual data. There's not even dots or anything to show the data points. Is there any way to get the interface chart element to catch zero-values for a single-select field? Or a different

How about creating a new field type ("Formula Script" or such), where Script (or at least some subscript) can be used for a field formula?  Or optionally allow Script in Formula field?

Hi y'all,So, I have a store on shopify were i sell products in stock and products that are on preorder. The variants in stock are defined by the word "EXPRESS" and a metafield in them, the rest of them don't have it. I'm using the AirPower template to track products and variants and sales but i don't know if it is the right solution for my case. I would like to automatize the tracking of the Variants i have in hand and once they go out of stock to transform them in preorder products automatically, so basically to delete the field "EXPRESS" and the Metafield attached. Also i would like to track sales too. What i'm struggling with is the way the Variants are logged.I have multiples of the same variant but bought at different price points and at different dates. I can't just add "#" to the variant quantity because i would lose the option to track how much i'm making on that specific variant and how long that product stays in my hand. Both pretty important details. At t

  console.log(`Starting...`); let table = base.getTable("Imported table"); let inputConfig = input.config(); let last_name_array = inputConfig.last_name.split(' '); let formatted_first_name = last_name_array.shift(); let formatted_last_name = last_name_array.join(' '); console.log(`Customer ID: ${inputConfig.customer_id}`) let response = fetch(`https://api.shop-ware.com/api/v1/tenants/xxxx/customers/${inputConfig.customer_id}`, { method: "GET", headers: { 'X-Api-Partner-Id':'xxxxxx', 'X-Api-Secret':'xxxxxx', 'Accept':'application/json', 'User-Agent':'PostmanRuntime/7.34.0', }, credentials: 'include', }); let body_response = await response; let json_response = body_response.json(); console.log(json_response); await table.updateRecordAsync(inputConfig.record_id,{ "First Name Formatted": formatted_first_name, "Last Name Formatted": formatted_last_name, "Business Name": inputConfig.first_name, })  The last console.log returns an empt

Hello,Is there a way to hide te starting hour and ending hour in calandar view ? It's a information that I can already see due to his position in the time grid and I would love to remplace it with another field more usefull like notes.Best regards,Simon

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products.  Sometime the same ingredients will be used for five different products.We want to create an inventory table that we will update manually when we receive or buy new ingredients, but decrease automatically when we dispatch ingredients that will be used to manufacture the product.For example, if we bought 20kg of magnesium, we need to add this to the existing stock on hand, ie. 10kg.  A new total of 30kg in stock.  When we manufacture the product SleepEeze we'll send 25kg to our manufacturer, and the stock should automatically decrease to 5kg left as stock on hand.  But I'll also take 2.5kg to manufacture CalmEeze, which should remove from stock on hand.  And so on.   I feel like this is so easy but I can't wrap my head around it. Thanks for your help in advance!

How can I make my record list in an interface narrower?  It takes up too much horizontal space and is much wider than the longest record name.

Hello, i'm trying to wrap my head around this particular problem.Main problemI have an Airtable column that shows the time someone has entered and another column that shows what time he finishes, i would like to find a way to create another column able to convert these times in hours workedSecondary problemIt would be nice if it also can considerate the night/day difference, for example starting at 11AM and finishing at 2AM EDIT: They are both Single Text fields Thank you very much for your help!

Hi all,I've been looking into making some improvement to our airtable and one of the aspects I've been looking to improve is a form of order management. So in essence, we would be looking to move an item from a table to meet a condition such as ordered to some form of projects table, then once the project has been delivered we could move this invoicing Any assistance in this matter would be greatly appreciate, I'm keen to learn on all things airtable as it's a really good tool!

Hi everyone.  I'm not a coder so have been relying on ChatGPT to help me with scripts.  It gave me this one for a spellchecker that looks in a field for misspellings of the word "epilepsy".  I have checked the name of the field and of the table are correct and filled in accordingly, but when I run the script, nothing happens.  No error message, it just runs and the console remains empty.  Any ideas what's going on?  Here is my script:    // Define the table and field you want to check var tableName = "YourTableName"; // Replace with your actual table name var fieldName = "YourFieldName"; // Replace with your actual field name // List of common misspellings var misspellings = ["epilepsey", "epilipsy", "epilepcy", "epilepsy", "eppilepsy", "epillepsy", "epilepsy", "epliepsy", "epilespy", "epilepsie"]; // Function to search for misspellings async function findMisspellings() { var table = base.

I have created a dashboard with the Record Review Layout in my interface.On that i have used a specific filter for a view, including that a specific checkbox has to be unchecked.Now after the user has checked the record and adjusted some single select fields he should check the checkbox and the record should dissaper from the current view.This is working properly as of right now, BUT it is always showing this error messae:"Your chagnes will hide this record (called progam in my case). This record no longer matches your filters. It will be hidden when you select another record."Is there a way to remove or hide this warning message.Or is there another smooth way to remove the record out of this Filter view.

I can’t seem to get <RecordCard />s to play nicely as flexbox child or reliably fit 100% width of its container. The default width of a record card is set to 568px wide, which wouldn’t be much of an issue if this were taken care of in the class applied to record cards. Instead, the width (and height) are set with inline styling. Since the width default property won’t take “100%” or “auto” as valid inputs, I can’t use either of those. Setting width to {-1} kind of works by removing the inline styling and getting it to fill its container, but all the record’s fields disappear: I could apply a class with width set to “auto!important” to override the inline styling, but “!important” is not generally good practice. Anyone have some advice?

Hello, I’m building a database for work and it works pretty well. I’ve just one small problem with linking field on 2 tables in a one-to-many way. I’m linking 1 record from table1 to many records on table2. Works great. On table 2, I desactivated the multirecord link so I can only link 1 record form table1. Great again. The problem is that from table 1 I can make another record which link to the same record on table 2. So when I look in my second table, in my “single record link field” I still end up with 2 differents records from table1 ! So what I would need is to be able to link multiple records from table1 to table2 but without being able to record 2 time the same one. Any idea ? Thanks you for this wonderfull tool ! Nicolas

It seems this may not be a robust as I’d hoped. I have set up project and task tables. I would like many tasks to one project. I went to tasks table, created link to projects with “allow linking to multiple records” disabled. This works great for assigning a task to a project. If I now go to the projects table I can still assign an already assigned task to a different project and this then carries back through to ‘pollute’ the task can only be assigned to one project constraint I set up. Seems the many to one is not truly in the database but just in the selection phase of the app. Worst case I could hide the link field in the Projects table and replace it with a lookup showing the same thing - this will force users to initate the link in the tasks table where the front end entry is enforcing the one-to-many while still allowing view of tasks. Is this just a limitation or is there a way I can work around this? Thanks, Sam