Solved

Is there anyone who can help with a script for this, if even possible? Would looove to see this implemented as a feature, as we’re using A LOT of views. Thank you!

How can I search globally in all tables ? No the existing search app doesnt work. See the image below. it only search in the records in current base not globally. Please guide me whats the possible solution to this. Screen Shot 2020-09-17 at 10.53.07 AM

When I go to upgrade to the new Teams plan, it says I have 14 billable users (and tries to charge me for such), but 9 of our users are only commenters.The Pricing page FAQ says, "No charges will apply for read-only collaborators, commenters, or people submitting forms."When I click "14 Billable Users" (on the upgrade page), it says, "…users with viewer and commenter permissions will get free viewer seats."And yet:It says here, "You can see every billable collaborator… This includes… any base collaborator with owner, creator, editor, or commenter permissions."And here: "On self-serve paid workspace plans, any collaborator with a permission level of Commenter, Editor, Creator, or Owner is classified as billable.I know Airtable is in middle of a price structure switch; not sure if this conflict of info is due to that.

Hello!  TIA for any help!  I'm creating a base for Donor Management and have run into a challenge.  I'm building an interface for Fundraising Campaign tracking.  The main Interface is a Record View layout.  Potential donors are loaded into a table and then viewed via this Interface.  When you click on a potential donor, it loads their contact information and the tracking data below it, as you can see in this screenshot.  *I've removed the sensitive data! Because the potential donors are linked into the campaigns, all their contact information is not editable in this Interface.  I'm generally okay with that, but I'd like to include a button that would let users open a donor's page for editing, possibly using the Contacts Interface you can see in the menu bar at the top.  Is there a way to create a link that would somehow take the ID of a linked record from the current Interface and pass it to the Contacts Interface on loading?Thanks agai

Hello, Been very busy and I suspect I’m going blind with what’s probably (hopefully) a simple data flow. As a picture says a thousand words, my problem is as per below; I can self link a record to its own table with a lookup field, which in this example I consider that as “Pushes to” - So A pushes to B. But what I’m needing, is another column that tells me the reverse of that relationship, so I can see that “B” is pulling from A - and then even create a filtered view around that very “Pulls From” data. I’m keen for your thoughts on this, hoping there’s something simple that I’ve missed that will allow this workflow. But I also have access to scripts/automations too if they’re the only way out of this.

Hello, I am trying to get a field named “Statsig Url” in a table named Experiments (this is a field with the url type). (My intent is to get the record id based on the value of the Statsig Url field). A filter will be applied in the url. let table = base.getTable("Experiments");console.table( await table.selectRecordsAsync( {"fields" : ["Experiment Name", "StatSig Link"]}));console.table( await table.selectRecordsAsync( {"fields" : table.fields}));I have tried with different approaches (testing other fields...). Each time I only get the primary key. 

Cannot get this Switch to work and its very simple.  I have a field that has the year of the record stored as a number (ie 2025).  I can easily get this to work with these arguments as a singular IF, but I dont want to nest 5 Ifs. The below will not function, doesnt even give an error, wont even let me save it. Neither Claude nor chatgpt has any suggestions that make sense.  What am I missing?? SWITCH(INVOICE_YEAR, YEAR(TODAY()), "Current Year", YEAR(TODAY())-1, "Previous Year, YEAR(TODAY())-2, "Two Years Prior", YEAR(TODAY())-3, "Three Years Prior", "Older")For this record this works fine:  SWITCH(INVOICE_YEAR, 2025, "Current Year", 2024, "Previous Year", 2023, "Two Years Prior", 2022, "Three Years Prior", "Older") 

Hello! I am trying to set up a work request form, and am stuck on one part. I’m not sure whether I need to use formulas or automations, but I’ve scoured help videos and articles to no avail trying to find what I’m looking for. I would like to have a numerical Work Order ID (basically a consecutive numerical number) added to a record field as soon as the record is created. Ideally, I’d love for it to take this form (Year-####), as that’s the current system we use, but I’d settle for just a unique numerical number for each new record created. I’m sure this is simpler than I’m making it out to be, but any help would be appreciated. Thank you!

Hi there, hoping someone can assist me. I need a formula that will note true/false based on an attachment field.For further context, this will be used in another formula that combines various fields into a link which goes to a custom Typeform. The fields from Airtable are set as hidden fields, but at the moment I'm having issues with the logic because it can't recognise if the data is true/false since the entire file name is showing. Having this terminology would be good so I can simplify the link and the Typeform logic.I tried working with the TRUE formula but couldn't get that to work.Let me know if you need more information. Any assistance would be appreciated.UPDATE - I've found a solution;IF( {Attachment Field}, "TRUE", "FALSE" ) 

I have the above time stamps. What I need to do is calculate the hours/minutes from 8AM to the Start Date 1, as well as End Date 1 to 5pm. How can I accomplish this? 

I’ve seen a lot of wild posts about this topic, but I was wondering if there was a a more simple and concise explanation for how to convert a field containing an integer in Unix Time, to a Date field. The Airtable knowledge base has incorrect information: https://support.airtable.com/v1/docs/converting-unix-epoch-time-to-current-date?highlight=unix%20time

I'm reaching out for your expertise. My sample table has three date fields: Joined, Separated, and Date Rejoined. It also has two formula fields: Prior # of Years from Joined date to Separated and Total Years. I need your helpto correct the formula for calculating the total years of membership.I am trying to calculate the total number of years they have been members. I can do that, but the problem is that when they join, separate, and rejoin, we don’t give them credit for the years they were gone/separated. Here is the formula I used for Total years. I’m sure my formula must be wrong for the “total years including prior years".     DATETIME_DIFF(TODAY(), {Joined},'days')/365 - {Prior # of Years from Joined date to Separated}But for members who have never separated, it gives me NaN for prior and total. Prior years' formula is:     DATETIME_DIFF(Separated, Joined,'days')/365Lastly, for members

I've been trying to find out what counts towards my automation run; however, either I can't find it, or I'm constantly overlooking the something.Basically I just want to have a solid grasp on what adds towards my automation limit?Is it just counted every time an automation runs?Does steps in the automation also count?Does loops count as one or multiple runs?

Hi Airtable Community, I’m attempting to send an email every time a new record is created. The message of the email should include the contents of every field that has data in that new record. Our fields are added to regularly, and I do not want to edit the automation every single time a new field is added to our table.  Is there already a known solution to this, that will automatically include all fields with data in the message of the email without pre-coding the specific field into the automation?  Thank you,Danny

My table has two checkbox columns that are set to show different symbols for True. “Actively Working” column is set to show a yellow star. “Hide” is set to show a red “x”.Both of these columns are showing a mix and match of both values (see photo). It is happening in the app on both ipad and phone. Individual records opened up show the correct value in the correct column. Anyone else having this issue? How do I resolve it?

I want to put a hyperlink within a long text field called "notes" on my calendar. I can't figure out how, so any help would be great.

I’m an airtable newbie. I’m building a base for planning production (live events) for the AV company I work for. One of the things I need to track is our pre show, show, and post show milestones in the planning process. The time frame is based on when we are loading in gear for the event. I need to make an automation that will take the load-in date and subtract 30 days for pre-show items, stay the same date for show items, and add 14 days for post show items. I have the pre, show, and post as a single select. Any and all help would be appreciated 

I have a list of clients that I do work for. I do the same 50 tasks for each client. Each field in my table is another task. The tasks are dropdowns with the status of the task like assigned, in progress, completed, and questions for supervisor.My supurvisor wants to create a view that shows only the questions for her. I did this by filtering the view to only show records (clients) that has the choice ‘questions for supervisor’ in field a, b, c d, etc. all the way through. This works well.However, I need to unhide all the fields because maybe that field is the one with a question. So, when a question pops up in her view, she has to scroll all the way to the right until she finds the field that has a question. This wastes a lot of time especially because there are a lot of clients and by each client there can be more then one question.I am looking for a way to only unhide a field that has ‘questions for supervisor’ for at least one record. I don’t mind if then that field will be there f

Hello, please tell me how to synchronize data exchange between two databases through formsHow to implement this data exchange logic between two databases?STEP 1: The partner fills out the “Invitation to become a partner” form. The data goes into the “Partners” database. This database records:Company Name Contact Person Logo etc.STEP 2: After submitting the form, the partner proceeds to the “Add Delegate” form (via the “Continue/Add delegates” button). IMPORTANT: In this form, the “Company Partner” field (i.e., the company name) must either:Be auto-populated, OR Allow the partner to select their company from a list (BUT they should only see their own company, not all).STEP 3: The partner fills out the delegate information in the “Add Delegate” form. The data goes into the “Delegates” database. That database will record:Delegate Name Position Delegate Email And a link to the “Company Partner” field (from “Partners”).🔄 WHAT SHOULD HAPPEN AUTOMATICALLY:TASK 1: When a new delegate is creat

Hi,In my Airtable, I have a simple Work Order app, connected to Softr.My tables are: Owners, Units, Work Orders. All 3 tables are linked.I would like to automate (autofill?)  “Owner’s Name Surname” in Work Orders  tableWhen a user chooses an Unit (like in WO 6),  Owner’s Name Surname  should be automatically filled (in WO 6 -  “John Doe”).(I can rearrange  Owners  table, and make   Owner’s email   as primary field, if that will help)I have tried different Automations, but I couldn’t make it. Thank you very much. 

I just tried out automating sending some emails with Airtable. Is there a way to remove the Airtable branding? The „via Airtable“ in the from field, as well as the „Sent via Automations on Airtable“ at the bottom? Thanks!

Hi all,I have a very strange behaviour with Airtable attachments together with make.comIn a loop in make,com, I create 4 images using FLUX.  I upload the generated images using "Create a record" module together with some other data (attachment column type) The images are correctly uploaded to the Airtable. Later in the same scenario I use the “Search records” module in order to retrieve the 4 rows with the images The rows and data are retrieved correctly but in *some* cases (this can’t be reproduced) the returned data for one of the images  contains only the ID and the original URL (that I used to upload the image) instead of the Airtable data with the airtable URL and the thumbnails, etc..See the screenshots:The first one shows the Create Record and the circled field contains the URL for the upload The second shows the wrong result for one image (yellow) and the correct result for another (green) The thirds shows the output bundles which make it obvious that there’s a difference.Any i

Have built 4 tables to collect inventory information on our fire department’s truck inventory.Tables:cabinets i.e. E-211 Cab. #1 items i.e. 2 1/2” Brass Male to Male Coupler inventory: list and # of item in each cabinet archive inventory: because the governing body wants it.I am trying to create this using Interfaces. What I am trying to do is use a Record Review template that has the cabinets in the left pane and the inventory items for each cabinet in the right pane. I have been successful in that. I have a working Inventory Interface page. The item list is complete (2,501 items). The Cabinet list is complete (65 cabinets).Truck Captains will use an iPad to open Airtable to the Inventory interface and choose one of the truck/cabinets they are responsible for from the left hand list and check off the inventory items they find. If they find an item missing or the quantity less than that listed they will enter that number in the OH field. When they finish that list they will open anothe

Hello, Currently I have a date field called Date, I would like to make a formula that looks at this date and outputs the first Tuesday of the previous month.Example{date} - Shows March 13, 2025Formula - Should show February 4, 2025 (First Tuesday of Previous Month)I was able to find the 1st date of the previous month utilizing this, but I cannot seem to figure out how to get the first Tuesday. DATETIME_FORMAT(DATEADD(DATEADD({Date}, -1, 'month'), -(DAY({Date}) - 1), 'days'),"MM/DD/YYYY") 

I see several posts that are similar to my question, but I haven't been able to find the actual solution yet.  I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to the listed manager each month asking for an update until the status is changed from pending to open.  Some managers have multiple pending locations at one time so I'd like to only send one email per manager rather than multiple if there are several pending in their area. There's probably a few ways to do this, but for now I have a rollup column on a different table that breaks down by district all the pending locations.Any thoughts?