Ask the Community

Hey all, first post in here. Has anyone else noticed that when creating a view and setting the filters (particularly on conditions relating to a date field that includes a time) there is no way to set the filter to read hours rather than days? My use case:- I want to set up a view to trigger an external automation (zapier) exactly 48hrs before a specific date-time- I set the filter to DATE = number_of_days_from_now = 2 However, that doesn't work as it doesn't include time in the calculation. e.g. DATE = 2023-09-19 16:00:00So then I want the filter to register a new row at: 2023-09-17 16:00:00But instead, it ignores time, adding a new row at: 2023-09-17 00:00:00 (as soon as it reaches the correct day basically) despite this being 16 hours early (but technically correct by 'days' alone).I've tried using DATETIME_FORMAT to extract just the time - but there isn't a way to read that usefully in the view. So I'm probably going to have to do an awkward workaround

Hello,I am having trouble syncing records across tables within a single base.Table A has a list of dates and times for appointments.Table B has a list of people who are scheduled for appointments in Table A.Table B, Column "Email Reminder Sent?" is a Checkbox field that indicates whether or not their Email Reminder has been sent.I have "Table B, Email Reminder Sent?" linked so it also shows up as a column in Table A. This way we can see the communications status for each appointment without going to the Table B.The problem is that when I'm in Table A, the Checkbox field is read-only and I'm not able to check/uncheck it. So i can "see" it in Table A, but I have to go to Table B to edit it.I assumed I needed to enable "Two Way Sync" to get around it, but it appears that this feature is intended for syncing between *different bases*. Based on that, I assume I'm missing something that's causing the problem above.What am I missing? How can I have two-way sync between two tables in the

IN a 2-Way Sync, what determines if a field is editable or not?The list Airtable offers seems very random, and in some cases is completely empty.Any suggestions to make a field editable?Some of the fields that are missing are simple text or date fields.

I have a table of projects that all have an Estimated Cost field.  At the bottom of the table it is summing every field, including Estimated Cost.Is there a way to access that data from the API?

Sorry in advance if this has already been asked and answered a million times. Basic Situation - I am a bookseller, and my POS is a POS when it comes to order integrations. So, I have to create a bulk upload in a spreadsheet of hundreds of books per week. This is fine, it’s doable, whatever. But it does require a lot of tedious data manipulation which I am hoping Airtable can reduce. The Issue - I need to compare one CSV file (the Purchase Order) to a different CSV file (our item database) in order to see which books are new and need to be added to our system. If they are new, then I need to format the data to match our POS’s upload template. If they are reorders, I need to check if there has been a cost or price change. I can easily do this in Google Sheets with vlookup formulas, but, again, having to copy and paste and move things around between different worksheets has gotten old very quickly. The Question - Can I use Airtable to create a template that allows me to just upload the tw

Hi, I am creating an app that takes user input and puts it into a Gantt chart. I am using Thunkable for this, however, when I run the code to display the Gantt chart, the screen shows: “airtable.com refused to connect.” I have attached the code blocks and the screen that is displayed. In the code for the URL, I am using the private link for that specific view. Let me know if you know how to fix this issue.

Hi All,I'm using Voiceflow, when i try to create a new table in an existing base using the API i get the following error:{ "error": { "type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND", "message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct." }, "VF_STATUS_CODE": 403 This is the url endpoint i'm using:https://api.airtable.com/v0/{baseID}/{table_name}I have a valid base id and i'm populating the {table_name} variable with the users 'user id' such as 'TYSCH'.I have all my scopes selected in my access token.Voiceflow API Settings: My JSON body:{ "table_name": "{table_name}", "fields": [ { "type": "singleLineText", "name": "UserId" }, { "type": "singleLineText", "name": "TokenUsage" }, { "type": "createdTime", "name": "Session Date & Time" } ], "views": [ { "name":

Hello, and thank you so much for reading my post. I have a table of products, variants, inventory, and orders. The reason of the separation of the variant table is because each product has unique variants names (some of the products are single products without variants)im trying to create a form to add a new order and facing a problem when its comes to add a new a specific product/variant.should I select product and then variant and then quantity? Is there a way to make it easier ? Kind of “invoice line” when you select product, quantity? please advise thank you so much 🙏

I'm creating an online portal to display my tables to users. The online portal I'm using doesn't display linked records on the table so I've had to find a workaround by adding additional fields to display the text from the linked records. I want to be able to create/update linked records field and have it automatically create/update the single select field (which display properly in my portal and has color options). What is the best solution for this?Here's my table setup:USERS (LINK) = linked username records from Usernames tableName (from USERS (LINK)): lookup field to display the username as textUSERS = single select field (this is how I want the usernames to be displayed)What I want:Whenever I update or create a record in USERS (LINK), I want it to automatically translate the updated or created record as a single select field without creating duplicates. Currently my single select field USERS is blank. I want it to automatically populate the

Hello,First of all, I apologize if I have duplicated this topic, but I couldn’t find the right answer.I’m trying to determine the best practice for organizing data and reporting for a workflow that I believe many others are dealing with.I have a table called PAYMENTS, where we store all payments our company has made. We also have a RECURRING PAYMENTS table, where we track recurring payments that are automatically added to the PAYMENTS table based on the period set up.However, we are struggling with reporting our payments for specific periods, such as a year, month, or quarter. Is there any way to solve this using only the Date field? I’ve tried creating a pivot table to sort payments by months for current year and categories. So far, I’ve created separate tables for Year, Month, and Quarter, each linked to the PAYMENTS table. Payments are then associated with a specific period. I believe some automation could assign these periods based on the Date field.This workflow also wor

Hi friends, I created an interface that shows projects and within each project its tasks.But - it shows me this arrow (Chevron) even when there are no tasks under the same project and it's just confusing.How do I cancel it?This means that if there are no tasks in Level 2 then he will not see this arrow.I would appreciate your help.thanks!

What is wrong with my formula that it is producing "#ERROR!" instead of an empty cell when {Most Recent Completed Event Date} is blank? DATETIME_FORMAT(IF({Most Recent Completed Event Date}, DATEADD({Most Recent Completed Event Date}, 9, 'month'), ""), 'M/D/YYYY') It is working perfectly for the ones that have a date in that field (e.g., if "Most Recent Completed Event Date" is 5/13/2023, it gives me 2/13/2024). If "Most Recent Completed Event" is empty, I want the formula to leave the cell empty, hence why I put the empty quotes as the alternative option. But instead, it gives me "#ERROR!" I tried looking up similar questions but I'm stumped. Thank you!  

I am trying to sync AirTable data to HubSpot. However, I do not understand the "Last Modified Time" field requirement by HubSpot. I created a Last modified time field in my AirTable base, but it still isn't working. Have anyone experienced these issues? 

Hi All, I’m building out a comprehensive recipe / ingredient / shopping list tool which aims to be the place where I can convert 15 years of working culinary knowledge and interest. I’ll share this when I’m complete. I’ve read about junction tables, implemented one, and have looked at nearly all examples on Universe. Let me first apologize if I’m searching for something that’s been asked 100 times before in with different language. I’m just getting a handle of airtable (and quickly starting to love this product), but don’t yet intimately know the product / language. Today I have three tables, “Recipes”, “Ingredient lists”, and “Ingredients”. “Ingredient lists” is a junction table which forms the many to many association between recipes and ingredients. Avocado toast and guacamole both share avocado. This part makes sense and works well. Here’s where I’m getting stuck. Let’s say I have a recipe called “buttermilk dressing” and another recipe called, “little gems with radish, but

Hey there,First of all I wanna thank anyone who answers, I often come to community for some of my issues and it's always very helpful !So, I want to be able to duplicate in a "dynamic way".I've got a tab "Projects" which is linked to a group of "activities" within another tab. A chosen project has several activities, which are created for each distinct activity day.Activities of the same project share many infos (partner, location, vehicule used ...) but they always differ in terms of date (start date & end date (ie : 12/7/24 2pm & 12/7/24 6pm)Sometimes we have to create 10+ activities for a project, and using the duplicate record function seems suboptimal because we can only do it one by one.So I'd like to know if using automation, extension..., it is possible to create all activities of a project in one click, if you create an activity template and input all the start & end date (where ? idk)Thank you for your time, have a nice day !

So I am working on automating some workflows to help my team out when they report on projects. I figured one less step they can do is to only update their project stage. There are certain tasks that get automated when moved to a specific stage and I would like to automate the previous Stage's tasks to be marked as completed when they move to the next. I am getting this invalid inputs error and I don't know how to resolve this.  I attached a picture but when using a specific record, this project has two associated tasks with it and I would like it only mark the previous stage's task (Assessment) as completed but it looks like its picking up both. 

Hi All,I am new to Airtable and I would like to set up a Project Management process based on our annual Strategic Realization (SR) OKRs. Each SR has its own project schedule, in some cases more than one schedule, depending on the KRs and deliverables.For reporting and tracking purposes, we plan to:Track project deliverables and milestones within the SR schedules and using a calendar view.Maintain a roadmap view for Leadership.Generate a report with custom PMO metrics.Use a form that, when completed, populates a weekly status report sent to all stakeholders across all SRs.My question is: In this scenario, should each SR project schedule be its own base that feeds into a single Calendar, Roadmap, PMO Metric Report, etc.?Thank you in advance, and I apologize for the basic nature of my question. 

Hi allMy base allows users to create both single item and multi items inquiries (There is a parent table for supplier/customer details) and child table (for line item details) and another table for products.If the user is inquiring against a specific product (from products table) then I seem to only be able to create one record within either the child (inquiry items) table or the parent (customer/supplier) tableI want to automatically create a parent record to this child record for these instances. Otherwise let me know if there are other workarounds?Thank you!

I have set up a Calendar view for events with Start and End times from my database. The calendar view sometimes shows subsequent/non-overlapping events as overlapping on the calendar. For example, all of the events in the screenshot immediately succeed the previous event. Some are shown as non-overlapping, while others are shown as overlapping events in the UI. Why does this happen? Is there a way to fix so that they do not appear as overlapping in the UI?

Hey! I have 3 checkbox fields that indicate the completion of a task. I want to show completion of the tasks using the newly released progress bar on the Percent tab, but without having to manually type in the thirds (1/3, 2/3, 3/3). If I use a formula to sum up the checks as a third, then use another formula to make it into a percent, I still won't be able to get the bar since the formula field does not come with that feature. How do I get that % into the percent field without having to create an automation? Is that the only way, or is there an easier/simpler way to go about this?Thanks in advance 🙂   

Hi,I'm trying to figure out if there is a script or formula to allow for when cells are updated in a column of a Google Sheet to update a corresponding column in Airtable. Here's the scenario I have:I have a Google Sheet that is organized by client project and it tracks the number of project hours used. I'd love for when the corresponding client project's client hours are updated in that Google Sheet that it is updated in the corresponding client record field in Airtable. I see a lot of stuff for updating a Sheet based upon an Airtable trigger, but not the other way. And I know that there is a Google Sheets API to add a row, but that's not what I need either as no new rows are created, it's just a field being updated.Hopefully this makes sense. Would really love any guidance on this that someone may have.Thank you!Julie 

I'm using the Airtable node in n8n to search records, and I noticed that the Limit field doesn't allow me to set a value higher than 100. Previously, I could set it to 600 without any issues. Has there been a change in the Airtable integration or any updates to the node that enforce this new limit? If so, is there a workaround to retrieve more than 100 records in a single query? Any guidance would be appreciated! 

Does anyone know if it’s possible to generate a url in Airtable that would both prefill fields AND autosubmit the form. I would like to be able to send a client a link (generated from an Airtable formula) via e-mail, that once clicked, would submit an Airtable form automatically with prefilled information. In other words, clicking the link would take them directly to the form submission confirmation page. All they have to do is click the link (or button in the e-mail) and their form is automatically submitted. I know that this is now possible using Stacker.app, but I was hoping for a similar solution simply using e-mail. In Stacker.app they add "&autosave=1 at the end of the url, but this doesn’t seem to work for me outside of that app. I’m guessing that this can probably be done using a e-mail button or link with a Zapier webhook, but I was hoping to avoid that if possible. If there is something similar to the “&autosave=1” feature, that would be ideal. Thanks!

How can I quickly get the Airtable Support to contact us? I am seeing a lot of people complaining that that the airtable support does not reply. And the Bot is killing me by routing the whole conversation in circles. I really need them to rectify my issue ASAP, as it is affecting out programmes.Hope that by posting it here they could help me.Reference No: 0088832000889887

Hello, So I have an automation to trigger when a checkbox is checked (in screenshot). It works when I test it, but it's not working on it's own. Meaning, when I add a new record and then at the end I check the checkbox, it doesn't add a new record to the programs calendar. I'm not sure what the issue is. Any help would be appreciated.Take care,YSDT