Other Questions

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 Purchase

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 w

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

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(DATETIM

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 collect

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!

Has anyone successfully integrated Airtable with D365, where any edits or updates to the records in Airtable successfully updates to D365? I’ve created the integration and initial tests work fine for first-time inserts, but when edits are made in Airtable, the record in D365 is not updated - rather - a new record is created with the updated info. If you know of a solve, would be great if you could share. Thanks in advance

I would like to be able to have a list that leads into a list, I cant figure this one out Single select one would be Audio Gear and Video Gear, If I select audio gear, in the next single select drop down I would only like the Handheld mic, Lav and IFB options to be visible and nothing form the video gear category. Audio Gear - Handheld Mic - Lav - IFB Video Gear Switcher SDI Converter Monitor If its possible without creating a hundred new tables that would be great

I cannot get any of the barcdoes fonts in airtable ot work with my scanner (Inateck BCST-20) and the manufacturere is assuring me, after sending them a picture of the airtable barcode, they assure me that the code wont work at all. both code 39 and 128 , the fonts for these are a hoax. someone proove me wrong. The scanner manufacturer has been very helpful to proove to me that the airtbale fonts simply dont work. so what gives? Smartphone apps dont recognise any of them either. what is it im not getting? isnt this suppsoed to be able to print out a barcode?

I am responsible for billing regular users of our Village Hall on a monthly basis. Currently, I export the data from the billing system, reduce the number of columns to the pertinent, sort by Hirer and then by date and then subtotal booking fee by Hirer and I end up with a sheet like this: I have spent 3 or 4 days now trying to replicate this in Airtable, with no joy whatsoever. I have linked tables and tried to roll up, but I cannot figure out how to roll up for each hirer. The best I have managed is to group by hirer and manually copy the summarised price total to another sheet.

I’m evaluating using Airtable as a notes repository for my consultancy. We take a TON of notes (every meeting, every standup, every one-off conversation with more than two participants…). Some of these notes are for internal staff only, and some need to be shared with the client. We’re currently managing this information via Google Docs, but it’s quickly breaking down as notes docs proliferate. Airtable seems to provide a good solution in that I can model notes docs as records in a single database, and then provide filtered views of that database to specific clients based on the values of fields set on each record. That said, I’m running into a few blockers with the ergonomics of writing and viewing notes in the Airtable UI that I’m hoping to solve via integration. Here’s my ideal solution: Take notes in a dedicated documentation app (something like Dropbox Paper) The markdown created by the documentation app is automatically inserted into a new r

I recently installed airtable on a Samsung galaxy s4 and created a simple table with just a few records of data. Right after that the phone battery drained very quick, it lasted less then 50% of the normal time. After I uninstalled airtable, with no other change to the phone, the battery use was back to normal. Did anyone experience this? I can’t find any settings in airtable to limit background activities. But I don’t think there even should be, or?

Hello everyone! I need to modify a formula that I have because I want to calculate a result in column A when B is greater than C AND also if B is blank. This is the formula I’m currently using and it needs modification: IF({DeStaging Date}<{Monthly Rental Fee Renewal Date},BLANK(),DATEADD({Staging Date},46,‘days’))