Other Questions

Hi team! I’ve been using this wonderful formula to set a due date for something, but the issue I have is that it defaults to 12:00AM. How would I append this formula to set it to, say, 4AM? Using a formula to return the date of 1st day of last month Formulas Hi all, New to Airtable and by no means a whizz when it comes to formulas. In short, I need to create a formula that will return a date of the 1st day of last month. In other words, today (May 21st), the field should show a date of April 1st 2020. As soon as we hit June, that date should change to May 1st 2020. Any idea how I could do this? Thanks all… Thanks!

I have an external API using, which I’m getting a list of the items. Items object/array is having a field name = title I want to update only records for which title matches AT also have a field name “title” but this is not working as expected. it;s not aligning the correct records. let table = base.getTable('Data'); let view = table.getView("CMS Data"); let query1 = await view.selectRecordsAsync({ sorts: [ {field: "Title"}, ] }); let response = await fetch('https://<api-url>/endpoint?_format=json', { //method: 'GET', }); let query = await response.json(); let peopleTable = base.getTable('Content'); for (var i in query) { recordId = query1.records[i].id; if( query1.records[i].getCellValue("Title") == query[i].title ) { let cms_id = query[i].id; await peopleTable.updateRecordAsync(recordId, { "id": Number(cms_id), }) } }

Hello i am trying to update my woocommerce image using pabbly whenever airtable record is created but i got this error. What did i do wrong? “Error getting remote image http://dl.airtable.com. Error: Forbidden”

Hi, I’m building a membership registry (list of names, addresses, id numbers etc per row) on airtable with either an interface or softr front end for different types of clients to see I predict the number of row entries will easily pass the 100 000 limit in due course, so I’m worried about what to do next when that time comes. Are there any workarounds or solutions to the ‘100,000 row limit’ problem?

Hey all, this question has been asked in the past but no real solution has been provided. I wonder if 12 months later we might have a work around. Every time I copy a concatenate cell, it adds quotations marks around the text " ". Opening each cell individually and then directly copying the text adds such an un-necessary step to my workflow. Is there another column I could apply a formula to that would remove the quotation marks? Thanks

I’ve searched, but maybe am using the wrong terminology! Is there a way, in a PLAIN TEXT or URL field, to @reference another table (in the same base). Use case I have tasks setup, and in each task I direct the user to the applicable table to action. Thanks in advance, Danny

I have a datetime field that includes data that’s precise to the second. I’d like to filter records based on an accounting window that’s somewhat unusual (like 2pm Thursday to Thursday), rather than just Thursday to Wednesday for instance. I saw there’s an old forum question on this, but it’s about 5 years old. Is there any update on this topic? How to filter by time not only date Dates and timezones Hi, I do have a datetime field containing,… well, date and time. I’m building a view now for a export and I need the filter to only show me certain entries prior to a special time (not only date). It looks like the filter does only take dates and not a time - at least I couldn’t find a syntax that works. How do I filter and show only entries that happened before a certain date AND time? Thanks, Frank

Newbie here. I’m trying to import from excel and when i select the quick import option and select excel the pop up box does not appear. Screen flashes “loading” quickly but the pop up does not appear. I get the same issue with CSV, Google sheets, and other import options. I’ve already updated pop up options (using Chrome) to ensure they’re allowed. I can’t see any other topics on this issue. Not a great start to my airtable experience.

I’m trying to find an easy way for other teams (non-technical) to work with Many-to-many relationships with AirTable. A simple example would be: Authors, Recipes, Ingredients A recipe could have multiple authors and multiple ingredients An Ingredient can be used in multiple recipes An author could have authorized multiple recipes I want to create a way (a form would be nice) where a user could insert the necessary that would populate various tables. Some of the data entry fields might have auto-complete on them if they’re looking up an ID field. If I wanted to enter in a recipe when looking up an author I’d like to see a list of what Authors are there, or create a new one. If I’m entering in ingredients I’d like to have a lookup as well because I won’t want to have mistakes in the ingredients table. (I don’t want to see Apple, apple, aple, appple, etc.) How could I go about doing this?

Hi everyone, I am new here. I am now testing airtable before making any decisions. I want to remove this header from my website when I embedded. Can anyone help me to solve this problem? Thanks in advance

Hello! I am hoping for some help on a problem I have. :slightly_smiling_face: I have a Projects table and the following fields: Status: a single select field that is either Confirmed, Completed, Prospective, or Declined/Did not pursue 3 Date fields for recording when the single select field changes to Confirmed, Completed, or Declined/Did not Pursue. Each with historical data I don’t want to lose. I would like the following to happen but don’t know if I can do it in a formula or automation: When the status field is updated to be “Confirmed” → Record the date in Date Confirmed When the status field is updated to be “Completed” → Record the date in Date of Completion When the status field is updated to be “Declined/Did not pursue” → Record the date in Date Declined Any assistance is greatly appreciated! I am still relatively new to AT. :slightly_smiling_face: Thanks

Hey all! I have a simple bar chart I want to show the total count (Y axis) for a given formula field. My view grouping does this very well, but when represented as X-axis in my chart, the chart app adds a parenthesis value to the label unexpectedly, growing the number of X-axis values significantly. Attached is view of values (only 7 unique values for X) and how they’re being messed with in the chart. Chart settings added as well. Any advice is greatly appreciated in advance, thanks!

I am using a kanban view that has columns stacked by a single select field which denotes a freelancer’s name. Every new entry in the table denotes a new assignment, at which point I drag the assignment card to the respective freelancer stack. What I am looking for is a way to get Airtable to spit out a date to track the last time each stack was last given an assignment. I haven’t had any luck with the last modified field type because I cannot simple make that last modified dependent upon one field in every card because a stack could have numerous amounts of cards; but I also can’t make the last modified field dependent on the stack itself because that is technically a static piece of information. My ultimate goal is for this data to show in a table where each freelancer (stack) value spitting out a date of last assignment figure based on the last time an assignment card was dropped in that respective stack, probably in an AT app later down the line once I figure out how to actually con

It appears that the Charts are only showing the Primary field, X axis & Y axis field when you click on a section to drill down on the graph however it used to show the Primary field as well as the first few fields of the associated View. So in this example it’s showing only the SO# (primary field); the PM & Status Field. However I would have seen SO#, Project Name and Site fields. I can’t tell if I changed something or not, has anyone experienced this? View’s Field Order:

When I refresh page, I lost all grouping and filters on a shared table. It there any chance to keep them? Could it be saved on Local Storage?

Hello, Im am trying to find out how to link one record multiple times. I am attempting to make my material price table and flat-rate table work together. Right now I have 2 Tables that don’t work together. The First table is a flat-rate table for jobs which includes material, labor hours to have prices for individual jobs such as replacing one fixture. My other Table is just for material and can be updated as prices fluctuate. Right now with material price changes the flat-rate table has to be updated separate from the material table. So I made a new flat-rate table that links to material so it will update automatically with price changes. My problem is in the quantities, all of my material is based in units of one, on foot of wire, one switch etc. This is how it’s shown on invoices from my supplier so it makes updating prices the most convenient. I can’t link a record multiple times in my flat-rate table to reflect proper quantities of material without changing the original record’s q

When the Start date field and End date field are the same, records DO NOT appear in the Timeline\Day timescale, but DO appear in views bigger than Timeline\Day. Setting the End at ‘Start + 1 minute’ makes it work- but yuk! Is this by design- to be completely invisible in ‘Day’?

Hi! I am creating a database for my books and have included categories like genre, pace, mood, etc. In future, I would like to offer a subscription service for people to get a new book within their preferences. I know I can create a form in Airtable to get their information but is it possible to then have the form automatically generate a list of all the books that match their preferences? Or if not automatically, is there a way to do it quickly/easily without having to manually cross reference their preferences to the categories? I imagine an IF/THEN formula with IF referring to the users’ selection and THEN linking to the database column for that category. But I’m not sure if this will work or if there’s a better way or if I’ll have to hire someone to create something like this for me. Any info would be appreciated!

Hey all! Anyone have experience using conditional logic in the Airtable Forms view? I am using it currently to conditionally show a field based on the input of the type of product category the user filling out the form selects (to help skinny down the list of options for the user). It works brilliantly except one important piece: The user can select from 12 different categories. If the user doesn’t select the category in the field I just conditionally defined nothing shows up from that field for the other 11 categories (which I have as a linked field to another table so that it autopopulates all the options that a user can apply). Short of creating 11 other linked fields – is there a way to “duplicate” or copy the field I defined and just switch the condition to show the different options for one of the other 11 selected categories (i.e., the else conditions?) Thanks for any thoughts. Justin

I need help with inventory management. What I’m trying to accomplish is using my current inventory of a product to create another product that will lower the inventory count of the products it takes to create the the new one. For example let’s say we’re selling fruits I have oranges, apples, bananas and kiwi that I sell all individually however I also want to offer them as a package deal so whenever I create that package the inventory of all the fruits involved lowers as well by the number it takes to make that. More in-depth I want it to take X apples and X kiwi but those numbers may be different from each other. Thank you in advance!

I want to do something like this Subtract more than one item from the same product Ask the community I am running a store that makes fabric bags. Each bag can be made from one or more products from the inventory, for example, two zippers, one strap, one tag, two hooks, etc. I need a formula that for each bag I sell it can subtract more than one item from each product in the inventory, this is kind of a cooking recipe. Please let me know if you need further information. Thank you! but in my case, there are sizes as well. So each fabric bag will be either small, medium or large and the components (zipper, strap etc) will also have the same size options. A small fabric bag will have small zippers and small straps. What kind of database structure should I have and how should those coordinate with each other?

I have a table in my base that I use to track “energy level” which is rated 1-10. Each record also has a timestamp on it. I’d like to create a table that charts energy levels on an average day. I’m thinking I need an average energy level for each one-hour increment. Any suggestions?

Hi all. Perhaps someone can help me. I need help from someone who understands the Telegram API. Below is the code of a script which should work under certain conditions in Automations and send a message to a Telegram user via bot in an open chat with some data from the table. At the moment the script sends an error error_code: 400 description: "Bad Request: message text is empty" The script works fine in the sandbox and sends messages. Not in Airtable. Perhaps the problem is related to Airtable and its specific variables? How do you think it is possible to solve this problem. On Stack Owerflow people occasionally write about this problem, but their solutions have not helped me. I would be grateful for an answer. const token = 'ххх'; let inputConfig = input.config(); let message = `${inputConfig.first_name}, документ готов по заказу №${inputConfig.order}.<br>Вы можете скачать его <a href = "${inputConfig.doc_link}"по ссылке</a>.<br>Ждем Вас снова.<br>Ваш, Rea

Hi Airtable community, Is there any way to: collect files via form attachment copy and upload the files to box.com delete the files in Airtable (Tried using Zapier, but unable to automate deleting the files in Airtable) Or are there any other ways that this can be achieved other than form attachent, as I know it is not ideal… Thanks in advance!

Hi, I’m putting together a base together with a list of therapeutic modalities on my y axis; and a multiple select field called ‘Presenting Issue’ on my x axis where I’m inputting the different presenting issues each therapy targets (e.g. CBT targets Phobias; Depression etc). I’ve a list of about 50 different therapies and would like to be have a view where I can look at the presenting issue and then see which therapy is ‘matched’ to the issue. I assume the best way to do this would be with a Kanban view, however Kanban doesn’t seem to work with a multiple select field. Any suggestions of how I can a Kanban to work, or perhaps a different method to achieve a similar outcome? Thanks in advance!