Other Questions

Hi guys, I currently have an Events table that shows all my Events with their Name fields and Date Fields. I need in my case to set status for each of the Event - DONE, UPCOMING, LATER. How best can I achieve this. Most of the formula’s I have tried are not giving me the required solutions.

I’m new to Airtable and on a crash course when it comes to no-code. So please bear with me. I want to extract user/store specific eBay sales, P/L etc and put it into an Airtable. Is there an API that allows this? Or is there an alternative way? Thanks

Hi brains trust, Is someone able to assist with creating a duration formula that returns a “0:00” result when missing inputs? I need to track team processing time on a particular project and currently have the following formula inputted under column “DURATION” which works a treat if all columns are correctly filled in: {TIME PROJECT FINISHED}-{TIME PROJECT STARTED} I would like the “DURATION” column to return “0:00” when there is value in “TIME PROJECT FINISHED” but not “TIME PROJECT STARTED”, and vise-versa. This is so I can chase whoever is inputting the record to ensure they are doing so in full and correctly. I’m thinking this will be an IF/AND statement but I’ve only just got the hang of the nested IF statements so this is really pushing my working knowledge! Thank you in advance for your formulaic wizardry!

I know this has been mentioned but it’s causing me problems and I can’t find the answer. I have a base with quite a few tables. In some of the tables I can make a selection, as in drag the curser over a bunch of cells and it will select them, like it is supposed to do. In others I can’t, and I have no sorting or groups on, it just won’t let me select anything, and also won’t let me use the drag handles to populate multiple cells in a column like I usually can. There is something preventing these in certain tables and not in others but I can’t for the life of me see what it is. Would having multiple views in a table do that? I need that feature to work

I’ve starting using the web clipper extension to make it easier for our team to capture site issues in our issue tracker base. Does anyone know if it’s possible to grab user agent information (OS, browser, device info etc) when submitting a new record? I’m guessing the site would need to use a JavaScript parser like this but I’m not entirely sure.

I tried to use csv import but apparently it doesn’t support importing to long text fields. I have 1100 records I need to populate a long text field for and I would prefer to not attempt a copy and paste here with such a wide margin for error. Has anybody scripted this? I have the data to import in both xlsx and csv format, ready to go, just need to find a way to get it there intelligently and don’t see anything on the market right now.

Hello! We have a Jira cloud integration with Airtable. We are trying to get the “Find Jira Ticket” Button actually find the exact ticket in Jira. When we put the link, it only takes us to the queue and not actual ticket that it is corresponding to. Is there a formula (possibly an IF/THEN) that someone can help with? Here is a picture of the button: Or does anyone have a better option when dealing with seeing Jira Tickets in Airtable?

Hi Folks, I have a Zapier Zap that is working beautifully to create invoices in Craftmypdf and then email them, but I have noticed a problem. The Airtable view I get the data from has a rollup field that is a sum of charges in another table, a currency filed that contains any money due from previous months and a formula filed that adds those 2. In Zapier I use the dictionary function to assign the value in the field Due to a key, also named due but the value is no longer 51.90 but 51.900000000000006 Is Airtable passing this or is Zapier corrupting it? What can i do about it?

I am attempting to generate a Google Doc in a shared drive in our Google workspace. This works fine when I am having the Google Doc saved to my own Google Drive (the connected account is me). But when I attempt to pick a folder in a shared drive, I get the error: Google reported an error while processing this action: Create Google Docs error Is it not possible to write to anything other than your own Google drive?

Hi everyone. I run a printing business and I use the Project tracker base to follow my production. I am not very happy with the Timeline view. do you know any other solutions ? One more thing, I’d like to create a gantt project for every record, based on the subtasks of the record. I have no idea how to do so and be able to click on the record on the timeline view and show the specific gantt view. Any suggestion to create this ? Thank you very much Roman

Hi, For each record, I have a start date (Date de parution) and an end date (Date 6 mois). They unique to every record. I want to count how many we have sold of every record within those date (Sales are in the Ventes 2021 tab, which is already link to my working tab). I cannot filter by a Date field, it seems. How can I work around this? Thank you

Hi there, The missing european number format (#.###,##) instead of #,###.##) was a real pain for me as well. I have customers entering number values in different ways via form, so i cannot use number input fields. However since i do have to make calculations and output values on those fields for reporting, I struggled a lot. I use a text field and thanks to the “number and currency pretty routines” i was able to build something that would allow me to transform a text field into a numeric field to do calculations and then to make it pretty for reporting. However this only works for values below 1.000.000. Maybe this will be of use to some of you out there and maybe someone wants to build on that to make it work for numbers over 1.000.000. Here is the base: Airtable European number format - Airtable Explore the "European number format" base on Airtable. All the best

Hey there - TL;DR What’s the best way to pull an attachment from a separate table into a row based on two separate field criteria? I have a base setup that helps me manage consigned inventory we place in our customer’s warehouses. Each row contains the open sales order number, consigned item, and the status. When the customer updates the status, it notifies us to bill the unit out and replace the unit. I want to pull an attachment into the the row based on the {Customer Name} & {Item Type} that I can then send via an automation when the status is updated. What’s the best way to go about that? Lookup fields only lookup based on one field and this is determined off of {Customer Name}, then {Item Type}. Thanks

Hello- Looking for help to open an airtable attachment that is a PDF directly into acrobat, any idea’s? Thanks, SG

Am looking for a good explanation the use of Simple Heat Map extension. So far I have found only this, Simple Heat Map - Apps - Airtable Marketplace, and either more to it or something amiss my extension install, or I have simply failed to grasp what seems a straightforward tool and its use. Regardless cannot make it work for my base content -and it rather simple: a few categories and some values. Any help appreciated. Thanks—

I have a base with a “multiple select” field type — and I would like to update some of the fields based on data from a CSV import. I’ve looked into three angles… As I understand it, CSV imports can’t update a field, just override it. But my fields have existing data that I want to add to, not override. It’s also not possible to merge fields (if I were to import the data into a new column, I couldn’t combine with the existing data). Because I only want to update certain records, I can’t do a batch update (which would apply to all fields). Am I misunderstanding any of these pathways — or is there something else I don’t know about yet? Thank you!

Good Morning, I have been given a task to compare all of our active students in one table to another table that has collected contact info from students. We want to be able to automatically mark the students in the contact table with a check when they are also in the active table (for filtering purposes). I do not want to manually do this because we tend to have between 400 and 1000 students that are active at any one time and our contact info table has 4000 records. Thanks ahead of time! Dan

I’m building an app where I want a user to enter the base URL (which has the base id and table id in the URL), then use the table id to get the name of that table. I’ve looked into using the metadata API where I can list all tables in a base, but I’m in a rush to build this app and need an answer today. How can I get a table’s name by its ID?

Hi there, I am currently working on a project to summarize data across multiple bases. I have set up share links so that in this single base I have a share table from each of my other bases. Each of these tables is laid out the same way [Name] [Amount] [Date Purchased] [Store Purchased] I want to combine these records from these multiple tables into one big table e.g If table 1 looks like: [Name] [Amount] [Date Purchased] [Store Purchased] Aaron, 10, 10/11, New York Abby, 34, 10/12, New York And table 2 looks like: [Name] [Amount] [Date Purchased] [Store Purchased] Aaron, 21, 10/30, Los Angeles Anna, 34, 10/31, Los Angeles Then my final table would look like [Name] [Amount] [Date Purchased] [Store Purchased] Aaron, 10, 10/11,

Hi all, new-ish to Airtable and I’m having to build an inventory table to check for equipment conditions. The purpose of this table would be to show the type of item, brand, make, some descriptions, cost of item, condition, and date condition checkup was submitted. The condition are pulled from another tab which is where my workers would be submitting their checkups, usually done once per week. My issue here is that as of now, if a worker submits a second check up (lets say by week 2) the condition field will populate as “good” “good”. I would like to have a single, most up-to-date condition in that field and have it delete the previous entry. For example, if item 1 has been “good” for 4 weeks, but by week 5 something were to happen, the worker would check “needs repair”. I would like the “good” to auto delete and be replaced with “needs repair” until otherwise noted as good on the next check up. I’m not sure if this is a task for formulas or for automation. I was toying around with bo

Is there way to use a checkbox or other formula to move a record from one table to another? (Add to Table B and delete from table A)

I am working on importing a CSV into my table, I have everything set up how I want it with linked records etc. The merge field that I need to use is not unique, we have different bursts of activity using the same reference number and we need to import different rows using the same number. There is no other unique identifier, how can I get around this and make it import all data even the rows with the same ref number? Thanks

I recently had to build a table to manage a number of events that happen outside of my time zone, and I thought I’d share what I’d learned in case someone else needs to do the same. Now, Airtable offers quite a few functions and features to handle timestamps: Airtable - Support Formula field reference For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation... Today I’m mainly going to focus on SET_TIMEZONE. How SET_TIMEZONE behaves Here’s a sample table I’m going to draw examples from: Airtable Grid view - Airtable Explore the "Grid" view on Airtable. {Given Time} corresponds to [date] below {Time Zone} corresponds to [tz_identifier] below SET_TIMEZONE takes two arguments, [date] and [tz_identifier], with the description “Sets a specific timez

Hi, I’m trying to figure out calculating correct fiscal year since our company fiscal year starts from April: 4-6: Q1 7-9: Q2 10-12: Q3 1-3: Q4 And I currently have below formula generating value from cell {ETA} but getting the YEARS correctly is tricky. Any ideas? IF(OR( FIND(04,DATETIME_FORMAT({ETA},‘MM’)), FIND(05,DATETIME_FORMAT({ETA},‘MM’)), FIND(06,DATETIME_FORMAT({ETA},‘MM’))),“Q1”, IF(OR( FIND(07,DATETIME_FORMAT({ETA},‘MM’)), FIND(08,DATETIME_FORMAT({ETA},‘MM’)), FIND(09,DATETIME_FORMAT({ETA},‘MM’))),“Q2”, IF(OR( FIND(10,DATETIME_FORMAT({ETA},‘MM’)), FIND(11,DATETIME_FORMAT({ETA},‘MM’)), FIND(12,DATETIME_FORMAT({ETA},‘MM’))),“Q3”, IF(OR( FIND(01,DATETIME_FORMAT({ETA},‘MM’)), FIND(02,DATETIME_FORMAT({ETA},‘MM’)), FIND(03,DATETIME_FORMAT({ETA},‘MM’))),“Q4”)))) & IF(AND(VALUE(DATETIME_FORMAT({ETA},‘M’))>=6, VALUE(DATETIME_FORMAT({ETA},‘M’))<=12)," - FY’" & DATETIME_FORMAT(DATEADD({ETA}, 1,‘year’),‘YY’)," - FY’" & DATETIME_FORMAT({ETA},‘YY’))

My organization (10-ish folks) is having problems buying into the value of more diligently managing contacts in Airtable. Airtable has been made the primary technology in the org, along with the Google ecosystem. However, it’s highly likely that a good % of the org is not updating info in a timely manner nor adding new contacts. I’m interested in discussing any good hacks that might allow the team to more easily initiate contact data updates in the flow of the vast majority of tools they use (gmail, gdocs & zoom). I had one idea to set up an automation involving Make and Airtable, where a team member can bcc an internal gmail address when communicating with a person (contact) they want to add/update info for. Make could parse the info from the email header fields and add a record in an Airtable base. This record would kick off an automation that would look for a contact matching the email in the contacts table, and then do something to begin the process of collecting updated/new i