Ask the Community

hi guys, i try to use web clipper for getting data from linked in automatically in my airtable. im new to airtable and also to HTML. so i tried to set up the webclipper by selecting the HTLM atributes with CSS search. But unfortunatly my set up is not correct yet. can you help me and answer if i picked the right html attribute or notationfor example i attached my aproach for the websitewhen i start the extension in chrome, no records are made in the airtable so far.  thank you a lot!regards jana

SYNC TABLE WHILE KEEPING RELATED TABLES.Hello Airtable community,I have a situation that I don't know how to resolve with a synchronized table.1- Situation: I have a "Matrix" table in a base that I've been using since before the option to synchronize bases, where I've built a database with linked tables and a very robust interface.2- Problem: Now I find myself in the dilemma that I have a database in another base generated for "players" in my case, and what I would like is to synchronize it with my "Matrix" table while maintaining the columns generated with the linked tables, as well as the different lookups and rollups.The current situation is blocking me from creating a more collaborative interface with information from different bases.3- Question: Do you think what I'm considering is possible?Thank you very much!

I've been scratching my head to why this is not possible, and I still have a feeling I'm doing something wrong but I can't figure out what.I have a bunch of time logs that has been logged over multiple years. Every log has an item linked to them which has a rollup that assign every time log into a category based on the item.My data looks like this: In the interface designer I want a bar chart that summarises all this data.The X-axis should be the years, then the Y-axis should be the amount of time spent.Each bar should be a total of time spend in that year. Then each bar should further be divide into the rollup categories. 

Hi, first post and new to airtable.I'm looking to place the hour-by-hour split on the timeline view with day timescale on the vertical axis, rather than it being on the same axis as the dates day-by-day.  I'm looking for something like this:While right now by view looks like this:Any help is greatly appreciated!  

Hello - Situation: Volunteers on the team have a 2-year tenure and when those 2 years are up, they can opt-in for 1 more year. My table shows their "start date" and then I have a column showing their "end date" using this formula DATEADD({Current WON Role Start Date}, 2, 'years') and have an automation that alerts me 60 days before that end date.  Need: What I'd like to happen then is after the Opt-In option is discussed and if the volunteer decides to add 1 more year to their volunteer work, a formula runs that gives a new end date.  Based on: What that said, I'd want the formula to run only if YES is selected from a drop down. Then I would assume we can take the tenure date (original end date) and add 1 year to spit out a new end date.  

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 o

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 "Tot

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 t

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:

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 t

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. Bo

  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, }) &nbsp

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!