Solved

I have a working formula in my table to calculate the job duration from "job start" to "job end". I am trying to use the same formula to calculate a job response time from "Job Creation date" to "Job start". The formula is as follows:CONCATENATE(FLOOR(DATETIME_DIFF({Job Start}, {Job Creation Date}, 'minutes') / 60), ":",RIGHT("00" & MOD(DATETIME_DIFF({Job Start}, {Job Creation Date}, 'minutes'), 60), 2))However, this doesn't seem to be working as I have a job created date of 20/06/2025 13:00 and a job start of 20/06/2025 13:08 and the result it is giving me is 0:52 - I cannot seem to get this formula to give me the result of 0:08 which is what the actual result should be.My job duration formula works exactly the same way and gives me the correct answer. Job Duration formula is:CONCATENATE(FLOOR(DATETIME_DIFF({Job End}, {Job Start}, 'minutes') / 60), ":",RIGHT("00" & MOD(DATETIME_DIFF({Job End}, {Job Start}, 'minutes'), 60), 2))Job Start = 20/06/2025 13:08 Job end = 20/06/2025 1

​@leah_ackerman Sorry, I didn’t know how else to get a hold of you.  I just tried to take the Airtable AI Administration Course and found that the same video is in there for each of the three segments, as well as the same description. Please let me know when this get addressed as I’d like to finish the course :-) Thanks for your help!

Hi. So the only way I can read-only share an interface with an external user is through Pro or Enterprise plans? Also is there a way to automate the sending of an interface dashboard for updates weekly, monthly, etc?

I'm using a simple JSON to POST data to create a new record in Airtable.I'm using Field IDs to prevent name changes from affecting the integration. I've replaced the actual field ID's below for this example, however I'm using the correct Field IDs in in my production environment.I'm using variables captured from the chat to send to Airtable.{"records": [{"fields": {"fld1": "{First_Name}","fld2": "{Last_Name}","fld3": "{eMail}","fld4": "{Boomo_Intent}","fld5": "{MCI_Copilot_Feedback}"}}]} I've verified both my endpoint URL and Authorization API Key.I've troubleshot this for a couple of days now including using ChatGPT but still get the following error:{"error": {"type": "INVALID_REQUEST_MISSING_FIELDS","message": "Could not find field \\"fields\\" in the request body"},"VF_STATUS_CODE": 422,"VF_HEADERS": {"access-control-allow-headers": "authorization,content-length,content-type,user-agent,x-airtable-application-id,x-airtable-user-agent,x-api-version,x-requested-with","access-contr

I'm trying to setup an automation that sends out reminder emails to a bunch of people. I'm wanting to customize the email to pull information, such as their name and email address, into the automation. However, when I try to input the dynamic data into the email that will be sent out, the only option I have showing up in my "insert values from field" are ID and the primary field in the table. Whereas with most dynamic setups, I'm able to pull data from any field in the table. Why are the other fields not available? Is there a workaround for this? Please see attached screen shots for reference.

Hello, I’ve got a Bookkeeping Airtable Base and have created a record review interface for the user to review new records, created with transaction info pulled from their banks. They’ve got to make sure they categorize the transaction and that it has something written into the Vendor field, then they hit the “save” button, which I created to run an automation that updates some things behind the scenes, crucially, pasting the value of a formula field (that adds up the Vendor field plus the transaction year) into a linked field called Merchant, and then marking that record as “reviewed.”So far it’s been going wonderfully, but I ran into an issue when a user told me they hit “save” but nothing happened, and going in I realized that the automation only works when there is already a record in the linked Merchants tab with the correct Vendor+year combo. If this transaction is from a brand new vendor, the automation doesn’t work, because – as I learned by checking out the Airtable Community p

Hey everyone,I'm working on migrating data from an old database to a new Airtable base, and I've set up linked tables. I've also created a script extension that successfully migrates a record when I manually select it within the extension.My goal is to embed this script in a button field on my interface. This button should allow users to run the script directly on the current record they are viewing, without having to open the script extension and select the record manually.Here are my main questions: How can I pass the current record (the parent of the button) as an input context to my script when the button is clicked? I need the script to know which record it should operate on. I've noticed that when I link the button to my script, the button appears disabled. Is this because the script is expecting manual input (like selecting a record from within the extension itself), and if so, how can I configure it to be runnable directly from the button? Any insights or examples on how to a

Hi everyone ! I am trying to authenticate a request using Basic Auth. I then need to base64-encode my logins. (could encode them manually and then insert but would prefer to keep that logic in the code) I didn’t found how to achieve this “natively” without rewriting the entire encoding function. btoa() does not seems to work :confused: Can anyone help me on this ? Thanks

I currently have a system created to track gear that comes to my warehouse and then leaves.I have different ways in where this gear arrives such as picked up by us, dropped off to warehouse by client, picked up by client from warehouse or returned by us. I have a field for each of those ways. most of the time when it is picked up by us it is also returned by us. I want each entry to automate being returned up by us when i choose picked up by us. Same for the other ones that are paired. What steps do I have to take to make it to where each time I make a new entry that this can be automated? I also do not want it to effect previous entries already made.    

 Originally when we created our system, we used text fields to record the Call Time and Gig Time Span. Since we have the time zones already saved for each record, I am wondering if there is an easy way to do the following: Switch the Call Time Field from a Text Field to a Time field (without having to type the time zone every time) Switch the Gig time Span Field into 2 different Time fields for both previous records and current records, a Start Time and End Time. Similarly, I do not want to type the time zone every time. Moving forward, I would like to only have to type the start start and end time for an event in separate fields (not in the text box).If this is possible, these would save a ton of time and allow us to do better, more efficient work. Thank you for your help!

Is it possible to export a revision history? And if so, can a specific date range be specified?

Hello, I have a base that has the date and time in one field, I have created another field and I would like to have that field enter the YYYY from the date time field using a formula. Would anyone know what the formula would be? Thanks in Advance!

Good day.I have a “whole” staff table, with various “statuses” SOWs, Guests, and FTE.  However, a newer table was linked to the base, with “special” contractor statuses.  I need to have these “added” to the above Full Table, along with their statuses, etc.  The whole needs to be the final source as it’s used across bases.  How might I go about this?  

I have a table linked to an application form. This table has a field with a check in it.I have another table within the same workspace for people that are referred, also with a check in it.Right now, new members apply and then I have 2 records: one from the application form, another from the manual enter I did as the person got referred.I want the system to update all records when someone applies using the form, so it doesn’t create another record, but fill in all the information on the already created one. Is this possible?I can’t seem to make it work via automations. 

hey all,I try to render an image in page designer. It works fine for uploaded images but if I only have an Image-URL - How can this be shown on the page designer. Thanks for your helpFlorian

Hi! good day!I am currently using the formula below to determine if a record/records is within last weeks Sunday to Saturday. Sunday being start of the week and Saturday being end of the week. AND(       IS_AFTER(           {Time in},           DATEADD(               DATEADD(                   TODAY(),                   -WEEKDAY(TODAY(), "Sunday") - 7,                   "days"               ),               0,               "days"           )       ),       IS_BEFORE(           {Time in},           DATEADD(               DATEADD(                   TODAY(),                   -WEEKDAY(TODAY(), "Sunday") + 0,                   "days"               ),               0,               "days"           )       )   ) If today is the 20th of June then my Current formula will tag my June 8 , 8AM record as false. If I adjust the time to 8:30AM, formula will tag it as true, would like the formula to include the entire day of sunday up to the entire day of saturday. Appreciate the help!

Hi Dear Community how to add a column for updating the price same as ther second image Thanks         

Hi, I have about 50 task fileds that each have a status. They can be marked as Assigned, In Progress, Complete, Question for Supervisor,  Question for Administrator. Each field is a multiple select field, because sometimes there is a question for both the supervisor and the administrator. I have a view for the supervisor and a view for the administrator that are each filtered to only show tasks that have a question for them. I have a formula field for each them that pulls out which task has the question.The formula for the supervisor is as follows: (The admin has the same formula, just with ADMIN instead of SUP in the formula)CONCATENATE( IF({Task A Status}="Questions for SUP", "Task A"), IF({Task B Status}="Questions for SUP", ", Task B"), IF({Task C Status}="Questions for SUP", ", Task C"), IF({Task D Status}="Questions for SUP", ", Task D") ) This works great. My question is, what if I have a question for both the supervisor and the administrator. Right now, if both those options ar

I have an interface that has linked table of images.I need the user to be able to rearrange these records by hand (drag and drop) so they print nicely and the right order. This works if I do it in a view. However the user should only be in the interface. I seem to be able to find anyway to rearrange these in an interface using either a gallery or cards. Is it me who a missing a check box to allow this?

I need help creating a formula that will create a link that will show property details, access codes, checklists, photo uploads (for a cleaning business) thank you in advance!

Hi community  I'm stacking with how to put 2 or 3 on the same page in the interface  

Hi, wonder if I can relate data in different workspaces. Or it will be completely separated?

 Hello I struggle to configure an action button in the Record Detail view: I wish to update a check box field to ‘NO’ and then to ‘YES’  such that to trigger an automation, but that does not work. It is weird that if I configure both Updates to ‘YES’, the Button takes the ‘After.. ‘ appearance as default. What am I missing?Thanks   2 Updates Button  This is what I wish to doWeird behaviour (??)  

I’m trying to use the record review interface in one of my interfaces, but instead of loading the record details, it just shows a persistent loading spinner and nothing ever appears. I’ve tried refreshing and checking permissions. Has anyone encountered this before or found a fix?

Hello! I’m trying to make a templated onboarding document that we can easily update with information fed from Airtable. Here’s the direct use case (Integrations are generally off the table in a corporate security setting): Hire Roster (lives in Airtable, holds new hire data) Microsoft Word/GDoc/OneNote (whatever!) that is complete with specific fields waiting to be fed new hire data, will serve as new hires’ onboarding document. Is there a way to automate the process of filling out a document without manually doing it?