Ask the Community

HiIs it possible to count the number of changes or modifications that have been made to a specific record?Rgds

Hi there and Happy Friday!I am trying to calculate the time it takes an individual to get a specific type of number at the time they enroll in our program.The formula I have is essentially, "If the individual does not have a preexisting number, calculate the time difference between the date they got the number and the date they enrolled in the program." The formula is: IF({LO has FTN at time of Enrollment}="No",WORKDAY_DIFF({Enrollment Date},{Turned in FTN})) That works but if “Turned in FTN” is blank, the calculation results in "#ERROR" and I hate "#ERROR". So, that means I need to add something like, “If “Turned in FTN” = Blank, then “””. I tried adding that a few different ways but am still getting #ERROR. Any ideas how to get rid of the #ERROR? Thanks in advance!  

Oh hello there! I am working with a team that is developing a base to capture competitor profiles. Within the base we have an organizational overview tab, contacts tab, program information tab, and a SWOT Analysis tab where we'd like to fill out the data on the competitors' strengths (from a drop down), weaknesses (from a drop down), opportunities (from a drop down), and threats (from a drop down) (among a few other things unnecessary to mention). What I'd like to do is have a matrix template that will pull in those selected drop down items and look something like the below for each organization/competitor. Would the matrix or page design extension be best for this? Might there be a better tool? I have some serious beef with the page design view and how limited it is - or perhaps in my case, just not intuitive enough to be impactful. Any ideas would be incredibly welcome. Thank you!

Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I would like to do is figure out a way that I can see only the last entry for every serial number. My thought is to have a third field for a conditional formula. Something that just posts the number 1 if it is the most recent date. Then I can use a view to only see everything with the number 1 in that field. The problem is that I need to pull the most recent date for EVRY serial number group. Not just the most recent date over all. Hope that I am explaining this right. Here is an example of the a sample base: Please help! Thank you.

Are there plans in the product roadmap to make the web clipper extension available for other browser than Chrome? If yes, then when ? I’m mostly interested in that being available in Firefox as I’m seriously considering to switch back from Chrome to Firefox. By the way, the web clipper tool is a great feature that helps users to quickly and conveniently add new records in a table in a comprehensive way. Thanks a lot for it ! Best regards, Younes

Hi! I'm trying to set up my first automation so that whenever someone submits a survey, AT sends that person an email with a summary of their responses. The client base are outside of the company and don't use AirTable beyond this survey, so I figured the automation route would be best. When I test using a test record I created in the base, it appears to run successfully. However, the first person submitted the survey yesterday and the automation keeps failing with the "The "To" input is empty" error. I currently have it set to popular the "To" field based on what the user enters in that question on the survey. I triple-checked the run that failed, and the user entered an email in that field, so I'm not sure why it's still saying it's blank. Should I add another step somewhere? Thanks in advance for any help! 

We create QR codes pretty frequently in our marketing collateral and it's not infrequent that we find out after something has been printed/distributed that we need to revise the URL it's point to for whatever reason.   I know there are a few services out there to generate a QR code. Is there a way to manage the associated URL though so if we need to redirect it at some point, we can?   

Hi, We’ve developped the Ubiqod platform to manage QR codes to interact with business processes. Here is a tutorial on how to use QR code to track working time in a Airtable base via Zapier. What do you think about a native integration between Ubiqod and Airtable? Would it be useful? Do not hesitate to give us your feedbacks!

Hi guys!I'm using Ubiqod for attendance tracking in our company. When you scan code, you click on the correct button (arrival, break, going home). After you submit it, the data comes to google sheet and with automation it gets to the Airtable. Now the problem occured. The timestamp from the google sheets it's not the same in the airtable. My guess is that this has got to do something with the different timezones. In googlesheet it's correct timestamp, in airtable it's 2 hours later.This is timestamp from google sheet:This is timestamp from AT:How can I transform this date in AT so that the hour will be correct (it was supposed to be "14:07" not 16:07). Thanks! 

Hello,I have a base where I keep track of projects and their status (in production, review, completed) organized in months. So, my tables look like: Jan 2024, Feb 2024, and so on.For monthly reports, I just grab information from a table (ex, Jan 2024) and create a interface. No prob there.The problem comes for QUARTERLY REPORTS, because so far I haven't been able to create an interface from several tables (Jan 2024, Feb 2024, Mar 2024). How would I go about to do so?Thanks, everyone!

I have developed an extension with specific business logic that I would like to release to multiple bases at once. I do not want to publish this extension to the marketplace as it would not be relevant to those not working at my company. Has anyone found a good way to release an extension to multiple bases at once? Or to release an extension to all bases owned by an organization?  Ideally anyone at my company could release the latest version of the extension to a base without much hassle.My current process is to follow https://airtable.com/developers/extensions/guides/run-in-multiple-bases to create the remote configuration files. Then I have a script that iterates through all of those and releases the current extension to that base. I could further automate the process if I was able to get the blockId without having to go to navigate to the base and retrieve that ID (reference post: https://community.airtable.com/t5/development-apis/how-to-get-the-block-id-fro

Hello! I've got an inventory board ("Print Products") that has hundreds of products (each with variable quantities). I add new amounts of each product regularly (in "Order Received" and "Products Received" for individual line items). When I sell items they go in "Order Sold" (with "Products Sold" for individual line items).The problem is, I move various amounts of various products between multiple locations. Sometimes they sell at a location, but sometimes they don't and I need to move unsold inventory around between locations. I created another table "Currently At" to try to keep track of how much inventory was at each location, but I'm finding it incredibly time consuming and tedious to input each quantity one line item at a time so that I can check in/check out the different quantities of each product. I was able to write an automation so that when I put something in "Products Sold" it automatically put it in "Currently At" with the correct quantity decrement. I can make forms

Hello!I have two fields that I want to meet certain criteria to return a value in another field.Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date field is empty have this field stay empty Thanks!

Hey I am trying to set up a formula for the below problem. I am provided with a list of names in the 'home' column and certain entries I need to change to end up like the 'bot name'. I have tried switch/If functions and I just get errors.  

Hi!I'm using an airtable base to calculate my working hours as a freelancer who works in live entertainment and I'm trying to figure out the best way to have a flexible system for different employers' rules for minimum paid hours of a shift, after how many hours before OT and DT, and also how some allow for DT after midnight. There is also the possibility with some for Sundays to be considered "premium days" regular time=time and a half all day. Right now there is a tick box per "shift" record that allows me to say this shift is "premium".Right now I have a table of "billing rules" with lookup values for each parameter.Each shift is linked to a "billing rule" record, and these values are lookups. The lookup values are then used to determine how many hours fall under each.The formulas to determine how many hours fall into each bucket involve a bunch of IF functions. If the billing rule is "flat rate" these hours are set to 0 and the total is overridden. Here is each:The total billing fo

How can I display a ratio between two values in interface (dashboard)?I have the field "hours" in a base.In the dashboard I want to display the number of hours last week divided in a static number.Like:All records from last week.Total amount of hours from those records.Divided in 8.Plot this on a chart so I can see progress over time. I'm OK to go through a new table in the base to solve the problem

I have two tables: 'Booked calls' and then 'CRM'.We are an agency that books calls on behalf of our clients. My booked calls are captured by webhook and linked to various other tables with KPIs. But now I want to build a CRM table for different clients, e.g. 'Client A CRM', 'Client B CRM', etc.How do I create an automatic link so that records coming into 'Booked Calls' are automatically added to the relevant client CRM?

DG mw me nahi hai na to be a great day hoga to be a

im accautn is Block support of the day is the best way to get

Hello, I am trying to create an automation using the Repeating Group option but I can't get it to work.I have a main table where I keep records of customer files. Each record has a responsible party that is linked to another table called "Responsibles," which contains the name and email address of each responsible party.What I want is for the automation to check the file records every Monday and send an email to each responsible party with a table showing their files.It is possible that a file may be assigned to more than one responsible party, so that file should appear in the table of the email for the different responsible parties.I have been testing this but I don't know how to configure it. Thank you.

Morning.We have a request that seems pretty common but searching the articles the info is a bit conflicting, so asking a fresh question.We have a base with data that we work with.  Think of it like a CRM.What I need is a way to set a view of data (state based) so that a user can only see the cases they are working on. That is pretty easy with a view etc. I also only want those users to only see certain fields from those people to not be able to edit the view or configuration of those fields. Except 2 fields which they are allowed to do a drop down on. Reason is basically to stop users from deleting or changing important data, or viewing other peoples data. Thats the main request. A lock down view for our users that they cant download, change, print, copy. they can only view . . except 2 fields that they can toggle. (our users are very basic).Second part of that, is I want them to have the ability to run one automation in that. A button that will send a locked down message to

I have a script set up to delete records when they enter a view. I fiound the script on this forum, it's:  let table = base.getTable("Field & Nursery"); let inputConfig = input.config(); let recordId = inputConfig['recordId'] await table.deleteRecordAsync(recordId); However, when this script runs, it triggers another automation. Update (I misspoke about how the automation works - amended here) The deletion is handled by:- If the record appears to need deleting, the status changes to a pending deletion status- A formula looks for records of the pending deletion status that are over x days old (depends on the kind of record) and outputs a "Delete" string (otherwise this field outputs nothing).-The automation looks for records that match "Delete" in the formula field.The script seems to behave in a way that the fields that are being watched "look" updated.However, because the script is deleting the record, this second automation fails. I assume there is s

Hello. I have just started playing with Airtable, and I have run into an issue. In SQL this would take but a second, but I cannot seem to figure out how to add this filtering. If you can help, I would be quite appreciative... TIA.The situation:1. I have a table called "Events". It records customer reviews of events that have happened.2. I also have a table called "Continents" (with 7 rows) and one called "Countries" with 195 rows. What I am *trying* to do is to have essentially a two-level dropdown list. I have added a field to the Events table that has a lookup to continent. That works just fine.The issue comes when I try to figure out what I'd *like* to do which is to set up a definition for the Countries table. I have added to the Countries object a field for continent which is a link to the continent for that country.The real problem is that I'd love to add the relation such that when I choose the continent for that country that I can then show a dropdown list which is the lis

Hi Airtable Community,  is there a way to auto assign tasks according to a single select field. I have a single select with multible Teams (CRM, Website, Social Media etc.). I want a new record to be auto assigned to the team lead of the team from the single select field. New records will be created with a form.  Best regardsMirko 

I am trying to connect with other application that asks me for my client_id, client_secret, api_token, and refresh_token.So far I have set my api_token,  client_id and client_secret, but still struggling with creating the refresh_token. Where should I find it?