Other Questions

Hi everyone! I created an org chart for my company and I was wondering if there was a way to condense it into a smaller view, taking the headshots out. It seems pretty spread out and we want a more condensed version to show our board. Thanks in advance!

Hi There, We currently use a piece of software to track our orders on a daily basis. I want to bring the raw data in and have it sort the line items together so I can create automated roll ups on clients and orders and products. Rather than manually linking the records is there an easy way to do this?

Hi All, very new to this and looking for some help. I’m looking to quickly see if a briefing has been completed or if any fields have been left empty (to then later report on this). Example I have 5 fields, if one of these fields is empty I want the output to be “incomplete”. I have been trying with this: IF({Message Name}=BLANK(),“Incomplete”,“Complete”) but this only works for me with one field. Any way I can check multiple fields to see if one of them is empty?

Hi all! Thanks in advance for any advice or help! We’ve got the following situation: We have a table with a Date field, so each entry has a date Each entry also has a checkbox field (so checked or unchecked) We would like to do the following: In another table, for each week get a sum of the number of entries in the other table that (a) occured during that week, and (b) have the checkbox checked Does anyone know how to do this? We’ve been playing with roll-ups and counts but we can’t seem to find a solution that doesn’t require linking to every entry in the table… Thank you!

Hello dears, i need a help. How to create more than 1 grid view within a table, whenever I modify one grid view change the other?

First of all: I am thrilled about Airtable for the filtering options, scripting blocks and great API! But there is one thing that is driving us mad: Sometimes if my colleage creates some new records, the day after they have somehow disappeared (they are not filtered - I have double checked)…so he creates some new records with the same content. But then some days later the original records reappear as by magic…so than we have duplicates :-/. Does anyone recognize this? And may there be a solution. I wouldn’t know how to avoid this. Best regards, Ronald from the Netherlands

Hi there, I’ve a website with an embedded Airtable database view and a chatbot where I’m using the API to make some research trough the DB. When the API returns a result, I want to send back the user to the website and display the fetching record into the embedded DB view. How can I do it ? Thanks

Hi everyone, I designed a page that I really like in one of my bases using the Page Designer app. I’d like to move this designed page over to another base. Is that possible? Thanks in advance! Matt

It’s amazing that we can now create Jira issues from Airtable…works beautifully. I was wondering how to: Get the url of the newly created Jira issue back to Airtable so I can have a link to it? Add the Jira issue as a child issue to an existing Jira issue? Update Airtable when the status of the Jira issue is updated. Any suggestions would be much appreciated.

What were the pros and cons of migrating? What do you miss from JIRA? What makes Airtable even better than JIRA? Just curious!

Hey team! When a new record is added, I would like for a drop down option to be automatically selected. For example: When the record for Aqua Lily Pad is added, I’d like “Inventory Arrived?” to automatically select “Inventory Not Arrived” (option not shown) and “Program Status” to be “In Program”. Is this possible?

Is there a way to add a time of day column? We have sessions starting at certain times. Don’t need the date. Also, I was doing a test where I added time as 24 hour time as a single select. It won’t sort properly.

I and a few team members use airtable for some document tracking at work. I built a very simple expense report base on the side that is essentially just two tables: 1 for “reports” and 1 for “expenses”. A bunch of expense records link to one report record, and a roll-up totals all the expenses. I threw together a simple page-designer template to re-create our company’s standard excel form (yes, we still use excel and a bunch of cobbled together receipts, its a mess) that pulls in the linked records from the expenses table to make a grid and then the roll-up in the report table to give the total. What I can’t figure out how to do is to include all the attachments for receipts and invoices I am expensing for. What I want to do is create a new expense line in the new table, put in the date and the vendor and the total, and then attach a PDF of either the receipt or the invoice from the vendor. I then want ALL the invoices/receipts from the various records linked to a given report record t

Hi Everyone, We’ve just discovered that about a month ago, we managed to mistakenly change a huge amount of information in a multiple-select column. It’s a mystery, because not all entries are changed… but it looks like maybe 4/5ths of the data are now incorrect. It looks like it would have taken a lot of thought to do this and we cannot fathom how it was done by mistake. In case this clarifies it at all, the column is for countries (in which orgs work). All countries plus a few broad regions are listed there, and orgs have anywhere from zero to 20 or more countries listed. It appears that all INDIAs have become SPAIN, all CHINAs have become JAPAN, GREECE has remained GREECE in some places but become POLAND in other records, WORLDWIDE has remained WORLDWIDE, BOLIVIA has become AUSTRALIA (and on and on). Some orgs with single entries in the country column are still correct - others are wrong. Some with multiple entries in that column are all wrong, and in other cases, some remain corre

Hi everyone, Recently started using Airtable as a bug tracker to get notifications in discord. We’re currently using an Airtable form to populate bug and can / cannot reproduce data. This is posted by Zapier to our server. What I’m trying to do now is connect Discord to Airtable and when a user can/cannot reproduce an issue, they will type in a channel and it will post a new record in Airtable. Our can / cannot reproduce is in a separate table from the bugs / issues and we’re using a linked field to identify title of bug. When I go to connect Discord to Airtable via Zapier, I cannot seem to get the bug title field? Also wondering how I would declare my bug title and repro steps in a single discord message? Any help would be appreciated.

Hi, I do have a datetime field containing,… well, date and time. I’m building a view now for a export and I need the filter to only show me certain entries prior to a special time (not only date). It looks like the filter does only take dates and not a time - at least I couldn’t find a syntax that works. How do I filter and show only entries that happened before a certain date AND time? Thanks, Frank

Hello, I have a table that has a Date Field. I wanted to use the filter option for a table to filter date records for a specific year such as only show dates that are 2020. With a date field, I don’t have an option to choose a date for a year. Is it possible to use a formula in this Filter section?

Hello! I’m pretty new to Airtable and can’t seem to find if there is an app that does what I’m looking for. I’ve built a base of solution providers that my company partners with - it details all kinds of services they provide and what platforms they work with, along with other info about them. What we’re looking to do is have a single landing page our sales agents can access where they can enter the different criteria to match up one of our users with the right provider for them based on the various criteria they enter. For example, one of our users needs a provider that provides web design services for ecommerce stores and is certified to work with the BigCommerce platform. In the landing page they would select “design servicest” for the service and “BigCommerce” for the supported platform. Then submit the form and see which entries from our airtable base match their query. Is there an app that does this already? I realize they could use filters and sorting in the base itself, but giv

Thank you in advance for your help. I would like to connect my dropbox account to airtable. Airtable will not permit me to add my business account, only personal folders from my personal / business account. I am baffled. Why not? Is this restriction coming from dropbox?

Hi! I want to add a formula field that returns today’s date + a certain number of days. The number of days added to today’s data varies by row. For example: Row one has a production time of 12 days, Row two has a production time of 4 days. I would like to add a column that takes today’s date, and adds 12 to it for the first row, and 4 to it for the second row. Is this possible? Thanks in advance, M

I have a column in a table formated as rich text. I want to auto populate other cells in the same column with the same rich text in the first cell when a status in another column changes from “empty” to “is not empty”. I update a record once a response is received and need to auto populate a check-box set of data in another cell once the status is updated. Other option maybe? Batch update rich text? Anyone know how to do this? Thank you!

Is there a way to open apps setup in airtable, using the airtable mobile device? I use the time tracker app in one of my bases and I want to be able to track time on the go also

Hi there. I have a database with multiple tables (tabs) but I only want to share one of them with my customers and I would like for them to only be able to have access to edit one field within that table. This would allow them to keep track of inventory and work done while having it synced up to my database. Is this doable? Thanks Brad

Hello Everybody. I would love your help in pointing to a template or example on how to set up a table that takes orders from another table and gives a daily summary by cashier. Table: Invoices Invoice 1 - Jane - 3000 - 1/2/2021 Invoice 2 - Dave - 2000 - 1/2/2021 Invoice 3 - Jane - 2000 - 1/2/2021 Invoice 4 - Dave - 1000 - 1/2/2021 Invoice 5 - Dave - 1000 - 1/4/2021 Invoice 6 - Dave - 1000 - 1/4/2021 Desired Table Each row by date and cashier 1-2-2021 Jane - Link Invoice 1 & Invoice 3 - Total = 5000 1-2-2021 Dave - Link Invoice 2 & Invoice 4 - Total = 3000 1-4-2021 Dave - Link Invoice 5 & Invoice 6 - Total = 2000

Hello, We want to recover the data we have in Google Data Studio to integrate it into Airtable. The data has to be synchronized between the two, meaning that when the data from Google data studio changes, it has to change in Airtable as well. Ideally, the data should be in real time. Do you have a solution for me please? Have a nice day, David