Other Questions

Hi, For a desk booking system I am looking for an app maker. The app I want to create is an visual desk booking app. Clickable available desks/seats on a 2 floor map of our building. The pointers need to be marked a colour when booked later today, or another color when free (or by a filter on a later date for that day) Is it possible to add a custom map to a Maps solution would be the most simple solution or is there another way in Airtable? Much appreciated! Arno

I have a Table for Product Creation that is linked to individually tracked Inventory on hand with a rollup to count down available inventory left as it is used in production. So, when I get to a point in production, I need to select multiple matching ingredient records with separate record ID’s because, let’s say, I need 2.5lbs of Flour but I have a 1 Lb bag remaining and a ten Pound new bag in inventory. Using multi-select you can choose booth ingredients, but the rollup removes the value from both instead of using the last of the 1 lb. bag and then removing the remaining amount from the 10 lb. bag. So instead of having 1 bag left at 9.5 lbs. I have 2 records 1 showing -1.5 lbs. and the other showing 8.5 lbs. left. Do I want to combine first so when they are removed in the process tab there is only 1 linked record to rollup, or is there a formula to cascade a value between records?

I’m using airtable to track maintenance work orders. The issue I’m currently running into is tracking parts quantity used in a work order. A work order is a task that I assign to my technician for them to complete. When they’re assigned a work order, they’ll have to attach the parts they use to complete the work order. Right now I have a 1-1 relationship with the parts which works well when they select one part, but when they select two parts, the quantity in the Parts table is thrown off. I’ve read about junction tables and many-to-many relationships, and I’m struggling on how to get this set up. I want my technicians to still select the parts and quantity they used in a work order, and then I want my parts to get updated. For example - Work Order - Test Parts Used - Filter, Screw Quantities Used - 1, 5 This should deduct 1 filter and 5 screws from my parts table.

Hello! Since 2018, I have been running the registration system for an annual week-long conference using Airtable. So far, each year of the program has been run out of a separate Airtable Base. People attend for many years and it would be nice to be able to give them a way to view all of their data accrued over the years. (There are various challenges and assessments that generate data year-to-year, and it would be beneficial to give attendees a way to see all of their data over the years.) What is the best platform to create user accounts tied to Airtable data? The users would ideally be able to sign in to a profile with a username/pw and see their data from all years of attending the conference. I know that you can sync bases and have messed around with this, but it requires all user input to be put in exactly correct, or it will not automatically find and sync records from different bases. This results in a huge manual process of finding correct matching recor

Hi! I am trying to update an event in google calendar with the event ID but an error comes up saying: “Google reported an error while processing this action: The calendar or event you requested could not be found, or you do not have permission to it.” Does anyone know what can be?

I work with a bunch of clients and I would like to track all the projects we have received from them organized by year (i don’t need help with that part)… In addition, is there a way for airtable to track all these projects or bid created from that specific client to determine the percentage a sale would be lost or made. Or create a graph to see how the client was obtained/connected to our other clients…(referral/email/tradeshow)?

Is the primary field customization feature available? The Select fields to sync, “Advanced” option is not visible on our Pro Plan. Airtable Support

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:

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?