Other Questions

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

Greetings Airtable Community! I have a base with 6 tables that is shared with two collaborators. The most frequently used “master” table—named Events—is at the far left of the upper tab structure. Each time I open the base, this “master” table is selected. However, when my collaborators open the base, another less important table is selected. Is there a way to force the base open to a specific table? Thank you!

DAK please whether possible to open more than 1 base at a time. Currently (using the tab feature on my browser, Safari) I am opening AT in two tabs and then open 1 base in each so that I can switch between them for my purpose (which is to copy and paste content from one base to the redundant other base so that it can be deleted ). (I know about sync bases but that’s not what I want to do.)

Hello, I’ve synchronized several bases in a main one. Now, one of these synchronized bases won’t evolve, so I’d like to merge it in the main one … is it possible ? I mean, I don’t need synchronization for this particular base, and I want the main base to show both merged records and synchronized ones. Is it possible, please ? Thanks in advance for your help. Best regards. Nicolas Caplat

Hello guys, I am having a problema on my sync bases where 1 of the sync column is giving wrong number in the sync field. Here I leave some photos to see more illustrated: Baseline Base Sync Base and I already deleted some of the registers in the baseline base but in the sync that continue of this base, the register is still there! Baseline Base Sync Base How can I fix this?

I use the app and have a list of about 44 people on my airtable list. However, I need to number them in order to keep track of the numbers of people that we’re adding on a regular basis. There does not seem to be a way of adding a column that numbers each line. Any suggestions?

I’m using Jotform, collecting payments with their Stripe integration, and want to get all the payment info into AT with the AT/Jotform integration. I have everything working EXCEPT - Jotform doesn’t give me the option of uploading the payment amount itself. Student have a choice of paying $65, $25, or $0 on the form. I need to upload what they actually paid into AT. See image - the “choose” field is grayed out. The “choose” field results do show up in the Jotform table, so I don’t understand why it doesn’t allow me to send them to AT. I tried configuring the AT field in different ways (single select, mult. select, short text, long text) - didn’t make any difference. Thank you for your help!

I’m creating a trip-prep checklist product and want it to be as user-friendly as possible. This means having the ability to hide entire categories that don’t apply to a person’s trip. (Specific example: I have a field/column for “category.” One of those categories is “swim.” I want a person to be able to hide all the swim line items with a single click.) I don’t want to give my users in-depth instructions on how to hide and filter. I’d like users to answer a series of simple yes/no questions, and NOs would result in related records being hidden in all the views. What are my options to achieve this? Thanks in advance!

I have two rollups, one for “latest morning absences” and another for “latest evening absences”. What formula do I use to return the latest of the two?

Is there a way to use an Excel import to update existing entries in Airtable, rather than creating a new table? Assignment would be done via a specific column, with unique entries per row. thx for help!

I have a linked field with values A, B, C. I want to display those values in an interface in rich text, ideally as a bulletpoint list. Can I use a formula to do this? Is there another workaround? Thanks!