Other Questions

Hi, I’m not very clued up when it comes to the more complex features of Airtable so I’m hoping someone in this community can offer some assistance :slightly_smiling_face: I managed to solve part of my issue through searching these community forums here I am using UK postcodes to determine a salesperson’s region. I have a list of these vs salesperson which can be viewed here. I have a webform that is pulling into Airtable using Zapier so it populates the fields whenever a form is submitted. I’m now adding some extra fields to this so that our sales team can utilise the base as a leads tracker. I’ve got as far as using a formula to assign a salesperson based on the first 2 digits of the postcode:

Hi. I am currently trying to use Airtable for collaborators to be able to review applications and then use the form to leave input. I have all the information in a couple of tables and galleries, but I think I have hit an issue. I would like each collaborator/reviewer to only see information pertaining to the applicants they were assigned and not all applicants but do not know how to do that. Do I need to create more views or am I missing something? I would appreciate any help on this. Thanks.

Hi Airtable I have an Integromat scenario to backup Airtable records, but it does not seem to work. I keep getting a RunTimeError. I am also not getting the Multi select options for each record, filled in each field. Can someone take a look? Maybe @ScottWorld? Here are screenshots of the scenario and error.

It would be great if there was a way to automatically update the field on Airtable when you change the label in a gmail inbox. Can this be developed?

Hey community! Absolutely love Airtable and its simplistic multi-functionality. I love it so much, in fact, that I would like to make it an integral part of a new function on our website. This request goes a bit in the direction of allowing “Embedded Form CSS Styling” but is a little simpler. I would just like to be able to give out a very simple airtable view as TEXT ONLY, without the background, colour, option to expand, download csv etc. I don’t mind having the Airtable logo there. Is there a way to do this, or–frankly–another plugin for WP or any other way to achieve a similar result? Thanks very much in advance!

Hi, I am making a table of companies which then list the investors in that company as a multiple select field - like ABC Company as the record name, and then “DEF Fund,” “GHI Investor” as the selected investors. I want to then import a new list of companies and investors, which would only add new ones to this list - not overwrite the existing fields - in this case, lists of investors are often incomplete so ideally I could import multiple lists of investors and companies and capture all the investor names. So for example, if I imported a list of investors and companies to the base above, which showed that that “DEF Fund” and “JKL Fund” were investors in ABC Company, I’d like the result to be all three - “DEF Fund,” “GHI Fund,” “JKL Fund”. It just adds the new ones, doesn’t remove GHI Fund because it wasn’t in the new list - only additive. Any thoughts on how to do this? Thanks in advance for any ideas!

DATETIME_FORMAT(SET_TIMEZONE(Date, 'Australia/Brisbane'), 'DD/MM/YYYY') This is not working for me. It doesn’t matter what I set the timezone to, it keeps saying it is yesterday. I need help to fix this because it is driving me crazy.

Hi everyone! I am needing some assistance writing some code to be able to automate some things on my workspace. If you have experience with this, and would be willing to help us out, please let me know! We are wanting to optimize Airtable in a way that allows us to use it a reference, and not as much as something we have to continue working on constantly. Thank you in advance!

Hi team, long time Monday.com user, trying to move my company across to Airtable. One thing my team is pushing back on is the “look” of the status columns. Here is an image of what my guys are used to seeing on Monday: And then here is the corresponding data in Airtable Is there a data type that looks similar to the Monday version? Alternatively, any browser tricks etc that I could use to make the data blocks bigger/more colourful? Custom CSS tool etc Thanks Andrew

I haven’t been able to login for the past 10 minutes or so. Anyone else having issues?

I am not able to access Airtable account or my base. All I get is the message that “something broke” Anyone else having a problem? My internet is fine. Sali

why has AIRTABLE SHUT DOWN?

Hi there - I am trying to learn airtable and zapier integration with this common test case - if a date is use, zap an email. Based on what I’ve read in the forum, to do that I need (1) to create a “view” report on airtable to list what’s due, (2) create a zap everytime a record is added on that airtable view, it push out an email. My questions, since Zap will execute when a new record is added on “view” will “it” work if I do not open my base table? “it” means will airtable update the “view” record daily even if I didn’t access (maybe bec I am on vacation for a week, and didn’t bring my laptop) the base table? If it does get updated automatically on the back-end, when does it get updated? Is it 1201 each morning? Is it batch mode? Just trying to figure out the update timing, so I know how best to use the integration with zap. Thank you.

I have a workspace collaborator that I want to make a base-only collaborator. If I delete them from the workspace, before adding them back to base only, will I lose their connections as Contributor in that base also be removed?

There is no way to updated existing contacts in Airtable with Google contacts via zapier. You need a “updated record” trigger in airtable. Without the ability to update existing contacts from airtable to google contacts then what does this mean from the airtable sales site: "Looking for a way to bulk manage your Google Contacts? “ Is the assumption here that no contact records are ever updated? what am i missing?

I have a list of video assets that I was originally tracking in Google Sheets. I have three sheets/tables- the first table has the main data and the following tables include tags for the videos. All the records on all three tables are the same, they just have different tags. I couldn’t link the records in Sheets and so I was manually updating the records with the tags. Now I’ve discovered Airtable and this would have made my life a million times easier. So, I need to convert those other tables into a new field and this will solve the issue of this table being too big (too many records). Because I was using Sheets, on the tags sheets, each tag is a column/field. It should just be 1 field that is multiple select that I just choose which tag applies to that video. I’ve converted one table to single select and fixed the labels, but now I need for those single select fields to all combine into one field that can become a linked record. Do I use rollup? I really don’t know what to

I have multiple affiliate links and descriptions that i would like to separate from their linked record. I’d like to have D1 (Description 1) and L1 (Affiliate Link 1) to be CONCATENATE(D1, L1) However, with the lookup field pulling in the affiliate descriptions and links, they are all listed as D1, D2, D3, etc. & L1, L2, L3, etc. How can i separate them from that list and pull them into another field for other use? While maintaining a correlation between D1 and L1 and D2 & L2, etc.

From what I understand Airtable advocates using as few tables as possible. I have also come to love the working with grouped and filtered fields in Airtable. Potentially this could make it easy to filter out empty records and use one table like a catchall that could be used for multiple purposes by grouping and filtering. But from my limited knowledge about databases and spreadsheets, I have the impression that you always should avoid empty anything. Is the best practice to avoid this in Airtable as well?

Is there any way to have a hierarchical structure in the organizational chart block that is more than 3 rows deep? I am building a family tree and I’d rather the org chart continue to build vertically instead of horizontally, but it seems to continuously lay out horizontally which is making some of the connections confusing to read.

Like the calendar view but if you introduce Gantt you could take Smartsheet out of the market :slightly_smiling_face: until then they have an edge over you!!! As an interim to full Gantt view could you show tasks with a start and end date as a span e.g. multi days rather than start date only?

Hi everyone ! I’m using the lookup tool but i want to know if it’s possible (maybe with a formula) to convert what’s inside the lookup column into a multiple-select column ? Thank you !

I want to generate HTML code for a link so I can merge a URL into an email. So I need something like: “<a href=” &""" & {Article URL}& “”" & “>article” But this doesn’t work. Is there a way to ensure that the formula can produce a "?

I am looking to export a view directly to s3 and I was wondering if there was a way to do this with a scripting block? If not is there any good 3rd party that will help do this?

Hello, I’m wondering if there’s a way to change single select option automatically. To give a context, we have two tables in a base, one for Sales and one for Inventory. The Inventory table contains both available and sold items. We’ve linked the sheets and used lookup to populate Sales data from Sales sheet in the fields in Inventory sheet (such as Order ID, Order Date, buyer info, etc.) I want the Single select field to change from Available to Sold, lets say when there’s an Order ID for a record. Is there a way to do this, maybe using the scripting block or any other Airtable features. Thanks!

Hi, I’ve been trying to visualize data in blocks using charts and was wondering if there’s a way to add data labels to these charts. For example, if I make a pie chart, is there a way to mention percentages on the chart. At the moment I only see the percentage when I hover the mouse on the chart. (see image)