Ask the Community

Hey there.I'm trying to get the duration of an activity by calculating the difference between 2 timestamps.These timestamps are the results of a formula that shows the time as a box is checked at the start of the activity and another, at the end. The formula in Start Time and Finish Time fields are:IF({Start}=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME({Start})), 'America/Sao_Paulo'),'H:mm'),0)IF(Finish=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME(Finish

I’m working on a trouble ticket table that keeps track of support for our users. I want to be able to track when a box was checked. So I have a “Followed up” checkbox field and I’d like to track the time from when the record was created to when the box is checked. I’m pretty sure I know how to figure out the difference in time with a formula but I’m having a hard time getting the timestamp of the box being checked. I can see the time in the expanded history view but there’s no way to reference it as far as I can see. Any help or workarounds are appreciated!

Hello Community,I'm seeking your assistance in finding additional resources or suggestions for my approach in tackling a particular issue.Objective:I want to integrate a button within my Airtable database that can generate an interactive email chatbox (open or close) for partners to request notifications with just one click, specific to certain projects.Potential Solutions:SendGrid isn't a viable option for this task.Building my own extension is an option, but I'm unfamiliar with the process, and without clear guidance, I'm concerned about its feasibility. Building a new extension - Airtable Blocks SDK Hard coding would be a last resort since I am new to Airtable and don't want to reinvent the wheel if avoidable.Zapier offers some p

Hello! getting lost in the sauce of nested IF formulas and looking for help.I have a CRM in airtable that I'd like for a formula to return one of two formulas based on a single select status for that deal.If the deal is open (any one of 7/10 statuses in the single select), I'd like for it to show the deals age based on today's date  DATETIME_DIFF( TODAY(),{Deal Created}, 'weeks')  If the deal is closed (any of 3/10 statuses in the single select) I'd like for it to show the age of the deal when it was closed:  DATETIME_DIFF({Date Closed or Lost},{Deal Created}, 'weeks')  Thanks for your help!

Hi,As an Absolute Beginner learning on the "Free" version of Airtable, I have a couple of questions on sharing:1. I want to share my base with other "free" collaborators - how do I do this?2.  Once shared, can my collaborators update my Base or will they only have read access?3. If I upgrade, will I have to buy a licence for everyone who wishes to update my Base?Thanks,Geoff

While I can do this manually, is there a method either when creating a linked field.. or after, to determine the the field it is linked to.For instance, we are tracking several fields in a loans file with our contacts table. So, for instance, the fields, Borrower, Co-Borrower, Buyer's Agent, Buyer's Agent TC, Listing Agent, Listing Agent TC, Title Rep, etc. all link to our Contacts. I created the relationships from the File_Loans table. So, in the Contacts table they look like this:I can link a record in each field and determine the linked field - allowing me to provide a better name on this side of the relationship but... Is there a better way?Thanks. 

I am creating a record sheet with computing the monthly accrual of 1.1667?

Hello, somewhat new to airtable and using the Payroll Timesheet Template available in the template library. However, I’m having a bit of trouble figuring out how to properly calculate the pay periods as they’re not every 15 days (like in the template), but rather the 15th and the last day of the month. It currently takes the Start Date formula DATEADD({Start of Pay Period 1},({Pay Period Number}*14)-14,'days') and the End Date formula* DATEADD({Start Date},13,'days') to calculate the Pay Date DATEADD({Start Date},13,'days') I am wondering how best to calculate the Start and End Dates based on the Pay Dates always being the 15 and the EOM (30th or 31st). I’ve been playing with different formulas all day and have figure out how to calculate

Hello, I was lazy when we first started using Airtable and invited my team as workspace collaborators. Now that we're growing, we're creating some Bases that not everyone should have access to.How do I convert a user from a. Workspace Collaborator to a Base Collaborator?Is the process the same to switch from base to workspace?Thanks!

I have contact records in my primary tab (we’re using Airtable as a CRM) where the contact’s Full Name is the main record. Then in another tab, we’re logging interactions with the contacts, and have a column that links to the contact record in the primary tab. In our primary tab, we have a column “Follow Up Date” that looks at the interactions in the other tab and grabs the follow up dates from each interaction with that contact (also from the column “Follow Up Date”). Ideally though, we only want it to grab the most recent date. If you see in my below examples, the contact Brian has 2 dates in his follow up column. This is because there are 2 interactions linked to his contact, both of which have a follow up date. However, the only date we need is the June 3rd one, since it’s the most recent. Is there any way to add this as a condition? I’m not seeing it. Thanks! Tab 1

If anybody has any step by step guide to automate the data flow from Workday to Airtable, could you please share. Ex: Using Workday Rest/RaaS calling or API etc.

I see a few people have asked this question already, but I don’t see a clear solution in those other threads. I’ve embedded a form on our WordPress site, and added a redirect for when someone completes the form. However, it doesn’t work. It looks like it activates the pop-up blocker on my laptop (which is a default setting on a MacBook Pro I just purchased, so I’m assuming others will have that, too). It reverts back to the form instead of sending people who completed it to my thank-you page. Is there anything else I should try? Thanks! Another thread where this is asked:

when adding images in attachment fields is there a way(or extension) that can pull metadata from the image file like document title, description, keywords and add them/assign them to fields in Air Table?

Hi,I watched the getting started in airtable webinar on Tuesday 25th July 2023 and they said they would email the link to the recording, which they haven't. I want to share the video with my colleages before a meeting with the sales team tomorrow. I can't find the link to that specific webinar on the website and if I click the links in the answers to this question that has been asked before, I just get the sign up page.Where can I find the link please?

I want to populate a calculated field using data input into other fields.Example: Q1 = XYZQ2 = ABCCalculated Field = Q1&Q2 = XYZABCIs this possible to achieve in either an interface or a form?Thanks!   

Hi,I have a base with a lot of records being submitted that have dates attached such as events. I want to be able to show the next 20 records coming up, keeping in mind this will change any time a new record is created with an upcoming date in the next day or two. So that might make record number 5 in the sequence be pushed out to record number 6 since a new once came in. But I still just want to present 20 records at any point in time.Thanks!

HI All! I'm trying to create a formula but am stuck. A $100 product minus 5%.That total minus 25%.That full total minus $25.For an end total of $46.25Here's what I have as a formula, but it's just not working out! I can't tell if it's the parenthesis or the actual 25%.((({Product}-({Product}*.05))-(25%))-{COGS}) Any help is appreciated!  Thanks

I am sorting alphabetically the Primary Field which is a Single line text. It does not work. I have some data for this Primary Field that are duplicates and when I sort it, it should be right next to each other but it’s not. How can I fix this?

I have a long text field that may include newlines. Example: Where is Margaritaville? It’s in the tropics somewhere between the Port of Indecision and Southwest of Disorder, but no parallels of latitude or longitude mark the spot exactly. You don’t have to be a navigator to get there. Palm trees provide the camouflage, ocean breezes bring the seaplanes and sailboats, tourists and travelers. Passports are not required. Island music rules. No waiting lines for anything. There is a beach and a thatched roof bar perched on the edge of the turquoise sea where you can always find a bar stool. There are lots of lies and loads of stories. It’s a comical concoction that blends together like tequila, salt, and limes. Where is Margaritaville? It’s in your mind. When I use the translate block, the result has had its newlines stripped: Où est Margaritaville? C’est sous les tropiques, quelque part entre le po

Hi!I'm building RMA system in AT. I'm creating Form outside of my table for manufacturers, but some manufacturers have their own RMA form. So I want to somehow recreate their PDF (use it as a template and add my fields from AT).  Can I create Form by adding existing PDF (or photo) and just add my fields on top?Thanks.

Hi guys! Is it possible to automate the translating with google translate extension in airtable? So that you don't have to go to the extension and press the button "Translate with Google"?

Hi, How Can I batch add texts into a text field? Please see attached, how Can I add text "outdoor" into "Note" field under the exist texts?thanks

Hi allWe have been using Tableau to visualise Airtable data for a while now. As of July 3rd we are experiencing failures in Tableau, although not consistently, with error message "java.lang.RuntimeException: unknown is not supported by this version of Tableau.". Does anyone know the reason or even solution for this?Many thanks!Ester, part of Red Cross Flanders data management team

Is it possible to insert a chart or graph block into page designer? I can’t seem to figure out how. Any help will be greatly appreciated! Best wishes, Jason