Solved

Hopefully a quick yes/no.I have several published datasets right now serving multiple bases all within one workspace.I’m about to split out our workspace into several for permissions control reasons. Will the dataset still be available to other workspaces (all under the same account), or is a dataset limited to just the one workspace it is created in?

I had a database from another location that had an existing {Item#} field. I want to keep and continue from the last existing Item# with autonumbering. The problem is that when I change the Item# field to autonumber, it renumbers from 1. Is there anyway to change the field to autonumber and then revert the original numbers?

Hi everyone! I’ve been trying to use Webhooks for a while to create a simple link that will allow my University’s Data Team to click a link to let us know that a query has been created. The Data Team will not use Slack either, so I’m basically trying to do an Actionable Message, but automating sending an ‘actionable’ link through our Microsoft Teams Channel.I have the Webhook examples below.The formula automatically generates the RecordID into the Webhook so that when it is sent, the RecordID appears in the Params. However, I can’t get that information to go into the Body, so I am not able to use the RecordID in my “Update Record” automation. (AirTable recommends using ReqBin for webhooks/testing, so that’s what I’m in) With University Guidelines and permission issues, I am only able to do this through AirTable and not any 3rd party tools. Do you have any suggestions on how I can do this? Thank you!

I have a multi-select form field.If they click Paid Social, I only want to show the questions related to paid social.If they click on Organic Social, Employee Advocacy, or Executive Advocacy, they get other set of questions.Additionally, can I hide all the questions until the preferred channel is chosen?

I am trying to create a task management database for a small farming operation. Each year, many tasks will follow the same pattern of dependencies, duration, and time between. I currently have 4 tables: Plants: As I add plants to the list, I can generate tasks for the Task table with an automation that pulls tasks from the Templates - Task List table. Templates:  Lists the different available task templates.  Templates - Task List: Lists the different tasks associated with each Template. Also links dependent Predecessor and Successor tasks. Tasks: The final output table, where tasks from the Templates - Task List table are added when the automation from the Plants table is triggered. This automation works. Certain details are included in the Templates - Task List table and called to the Task List via lookup or rollup fields, including Days Before Next Task and Duration. I also have a marker (checkbox) to indicate which task is the starting task in a sequence. Another automation (also w

For my project, I need to compare responses between two Google forms with the same questions. At the beginning of the program, the student fills out a form with 15 questions (competencies) of the type (Never, rarely, sometimes, always), and at the end of the program, they fill out another form with the same questions. The goal is to validate, by student, whether there has been progress in competencies or the evolution of competencies among the various students.I already have the table with the students' data; how should I create the tables for this project? Thank you very much! 

Hello Airtable experts,I've noticed the following issue and would, of course, like to resolve it. Maybe you have a solution for me. I have some interfaces set to grid view because I import data from Excel using copy and paste. However, I've noticed that the page is very sluggish in grid view. When I switch the page to list view, it runs smoothly.Is there anything I can do to fix this?

Hello,The question is fairly simple.I have an Interface page with a button that updates a field called “X” (basically an on/off checkbox). However, I would also like to record which user triggered the button and when it was triggered.Updating the checkbox itself is immediate using a button with the “Update record” action.My questions are: Is there any way to also capture the portal user’s email, ID, or any other unique identifier into another field (let’s call it “Action X triggered by user”) using the same “Update record” button action, or would I need to trigger an automation and run a script? Same question for storing the timestamp when the button is clicked. Notes: I tried using a single line text field for the user, but the value is not dynamic and must be predefined in the Interface button settings. I also tried using a “User” field in the table, but I ran into the same limitation: the value has to be statically configured in the button action settings. Last modified by and

Hello, 2 of us use our airtable1 english speaking accesing via PC and Android phone App, the other Thai speaking accesing via Android phone app Thank you

Hello, community. I’ve already submitted my request via the Airtable form, but I wanted to ask if any of you would find this useful as well? Maybe some feedback on this would help draw attention to it. I think it would be great if we could save and select presets of an interface’s settings. For example, I want to see a specific type of task here that I need from time to time. Having a saved setting for this would be great. What do you think?

We’re looking at turning on AI for our Enterprise grade account and expect that we wouldn’t burn through the monthly quota of 25K credits per Editor licence, but given we haven’t trialled anything, I’m really just stabbing in the dark as to what our usage would be.We would use it for sentiment analysis, researching on the Internet, document analysis (which is more heavy on the credit usage), a lot of Question/Answer and also reporting anaylsis through Omni I’d imagine.I just wanted to see if anyone out ‘in the real world’ was finding they were bumping into limits and need to restrict usage or whatever.Cheers, Dan.

I have two tables:InvoicesTime Invoices has a project, start date and end date.Time has a project, start date and hours. I’m trying to find all the time records between the Invoice start and end dates for a project and assign them to the invoice. But when I try to find the time AT only allows static choices, not dynamic. How can I make this work?

They seem to be permanent. Don’t see any “remove” option?

Hi!I need to track attendance for different cohorts put on throughout the year. Each cohort has multiple sessions and multiple attendees. When attendees are linked to a cohort, I would like to automatically create attendance records for every session linked to that cohort. Attendance statuses will be updated manually later. I am having trouble setting up the looping automation. I have never set one up before and I am getting stuck. Any help pointing me in the right direction is greatly appreciated! My base has the following tables:TABLE: CohortsFields:Cohort Name (primary field) Attendees (linked to attendee table) Sessions (linked to Cohort Sessions table) Session Record IDs (lookup field pulling Record ID from linked Sessions)TABLE: Cohort SessionsFields:Session Name (primary field) Linked Cohort (linked to Cohorts table) Record ID (formula field)TABLE: Cohort AttendanceFields:Attendance Record (primary field formula) Leader (linked to Leaders table) Session (linked to Cohort Session

Hi everyone! I hope I explain this correctly since I’m not an Airtable guru. I created an Airtable automation with Gmail and completed a project yesterday. I want the client to receive an automated email confirming completion of the project today. Images of configuration and results are attached, but the email hasn’t been sent yet. I assumed it would have been sent by now and it hasn’t. I’m CST and currently it’s 10:55am. Am I missing anything?  

Hi! I’m a first-time poster here. I hope the below makes sense. Here goes.I’m a Marketing Coordinator and we have a team of 6. I am redesigning our Airtable base, so that it aligns with best practices and utilises the functions within Airtable more efficiently. Currently everyone works directly from tables, with no interfaces or automations. I have a fairly good understanding of Airtable and it’s capabilities. Our team has deliverables associated with multiple departments and with many external partners. I am starting from scratch, building workflows and the likes, having inherited the Airtable space.Departments include:Product Sales Partnerships (including events) Customer Service RetailRequests include tasks for:Social Content eCommerce Web and SEO Photography and videography Print and digital design (for catalogues, sales conferences, specialty customer product promos, website, etc.) Photo and video processing, editing and creationMy question is; would it be suitable to have all tab

I have three Tables. - Commit Items, Invoice Header, and Invoice Detail. Lets assume that For Commit No ACB001 there are 4 Records in Commit Items Table with many records for other Commit Nos.. When the invoice is received for Commit No ABC001 and entered on Invoice Header table with Invoice No and Commit No ABC001, I would like automation to grab four records from Commit Items table and create those 4 records + Invoice number in Invoice Detail table. How do I achieve this? Just a reminder, I am new to AirTable.

I’ve imported several tables into AT. They each had a day field (no time element). I just noticed all the dates are +1 day from what they should be. How is this even possible?More importantly, how do I fix it?

Hi guys,I’m building a CRM within Airtable and need to create a two-way sync between Airtable and Google Calendar so if an event is created/updated/deleted in one, it automatically updates in the other. This is the current setup I have: A separate ‘Meetings’ table for events created within Airtable and a separate table that’s integrated with the Google Calendar (on the interface, it will all just be one calendar). I am trying to create an “Update Record” automation so if an event is updated in Airtable, it updates in Google Calendar but I’m running into some issues and with the vice-versa automation.The trigger runs successfully but the action always fails:Always the same error processing the actionHas anyone done a two-way sync before and can please shed some light on how to achieve this? Thank you!

Hello.I'm a bit confused about the different types of extensions in Airtable and can't quite figure out which one makes sense for my use case. I already know how to solve this inside a specific base using older approaches, but now I want something more reusable across different bases and aligned with the newer tools.Previously, there were:Airtable Scripting Extensions - easy to reuse by copy-pasting code, but a bit too limited in terms of interactivity. Airtable Extensions (Blocks) - can be built from examples, require Node, and can be distributed across bases via remotes and CLI.Now we have:Custom extensions, available viahttps://airtable.com/create/extensions Interface Extensions, which can be created via prompt.I have two tasks where I’m not sure what’s the right approach. The docs don’t help much because I’m not even sure which section I should be reading.a) Fairly simple: select a table, pick a text field, and run a few transformations (truncate, capitalize, etc.).Ideally, I’d lik

In the interface I have a list with two linked levels. Level 2 (parent) only has a handful of records. One of the records in Level 2 has over 4000 Level1 (child) records. When I open that parent record to vie the child records it is extremely slow and the slowness makes the application largely non responsive - until I move to a different parent record or some other table in the interface.  If I simply open another list in the interface with only the one child table, all 4500 records open pretty much instantly. What's the best way to handle this? 

This question has probably already been answered… but I haven’t managed to find it.So here it goes.I’m trying to implement a work control system for a nursing home. Many of the staff only need to view their tasks and record certain information in a couple of processes.I’ve designed a form for this purpose.On the other hand, the Interface contains multiple administrative views and queries.Currently, we only have one editor user and one viewer user.Unfortunately, I can’t get the staff to have access only to creating, editing, and viewing their own tasks.I’ve tried embeds, iframes, HTML… in many different ways, and nothing works. Airtable always limits me.Am I doing something wrong?Do I necessarily have to pay for additional users?Would that give me another interface?Would Fillout (as suggested by Scott Rose @ScottWorld) be the solution?I don’t want to use tools like Make or n8n.Thanks in advance.Natxo Rodríguez

Hi guys,I have been trying to format my gmail body using html tags but i am not getting my desired output. The formatting looks awfl when sent to customer. Extra spaces have been added above & below the text despite setting the padding to 0. Here’s the formatting i have been using: <table role="presentation" width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td align="center" style="padding:0;background-color:#ffffff;">  <table role="presentation" width="100%" border="0" cellpadding="0" cellspacing="0" style="max-width:520px;">   <tr><td style="padding:0px 16px 14px 16px;"><span style="font-family:Georgia,serif;font-size:10px;color:#aaaaaa;letter-spacing:4px;text-transform:uppercase;">Faisal Silk  ·  Order Update</span></td></tr>   <tr><td style="padding:0 16px 0 32px;"><span style="font-family:Arial,sans-serif;font-size:9px;color:#aaaaaa;letter-spacing:2px;text-transfo

In a rich-text enabled long text I can use [] to create a check list.Trying to create a checklist by default in an automation using the same function but it doesn’t seem to work. Is there anything different I need to do if this is a capability? If not i can look into adding it to a script that I have earlier in the automation.

Hi,How can I change which fields are visible in the “Click to see underlying records” drill-down in an interface dashboard pivot table?Automatically I get “sum” and “link to cost centers” but I’d need to show something else.  Airtable instructions claim that you should be able to do it, but I just can’t see where to do it. “Underlying record detailsIn the User actions section of a dashboard visualization there is the option to allow end users to "Click to see underlying data" from the interface page. This option is per-visualization, meaning you as a builder have the granularity to toggle this on for individual dashboard insights. The option to turn this feature on can also be enabled by double-clicking on a visualization on the canvas.The drill-down will only show the underlying records associated with the visualization and builders can configure: Visible fields Default sort Record details for the records shown Record details for foreign fields (This is available by clicking on