Other Questions

I have found a few posts about this already, but none more recent than two years ago. I find this feature gap baffling, and I can’t imagine being able to use Airtable without it. My use-case is simple. I have an ever-growing list of sign-in for meetings. I want to have a separate membership table that has one row per unique person - a given person will sign in to many meetings - and, for example, a count of the number of meetings that person has attended. This is trivial to do with linked records and Rollup columns. However, as best as I can tell, for each new record in the source sign-in sheet, I have to manually add those linked records to the derived membership table. That is a nonstarter for me, and I have several other use-cases I was hoping to make after this prototype, but they all require this very simple feature. I don’t understand why a column can’t be set to automatically link to all records in a corresponding table. This is the most basic feature of any rel

Love the Zapier integration, but without the ability to trigger on update/change/edit of a field, it’s pretty hard to keep other databases synced with Airtable - not sure if this my mistake or not. Additionally, I can’t move my system across to Airtable without the above feature or the option to run a Zapier zap on all database entires in a view/base. For example, if I want to email all my contacts, I can’t do that via Mail-Chimp etc, because the triggers only fire on creation of a record not on update/change/manual selection. Can you advise any workaround because this is one of only two barriers to me moving a client to your platform.

At the bottom of a linked record dialog box, a button shows, “+ Add new record” Anyone know if there is a keyboard shortcut for this button?

Hi All I have two tables in a base. One has a form where the data is entered. I do not care to see the tables because I have blocks create to visualize the data in the tables. I would like to set the dashboard as the main landing page for the base. Is there a way to change the settings in a base to have the dashboard be what you see when a base is launched? Emma

Is there a way to automatically copy values from one column into a linked column? Could I achieve this by having a formula in the linked column that copies data?

Hi fellow Airtablers, I have a large base with about 20+ tables and probably >15 fields in each, many of which are formula/lookup/rollup, so I frequently reference the base-schema block to see what fields are related before I make a change to the underlying structure. I’m struggling with the, seemingly random, directionality of the ‘dancing ants’/dashed line relationships. It doesn’t appear to be related to which direction the value is being pulled. Is there a way to have the block show the ‘precedents’ the way you can do in Excel? For example, I’d like to be able to tell if the field I’m hovering over in Table A is pulling in values from fields in Table B - or if the relationship is the opposite - if the field in Table A is actually being pulled into Table B. This would be especially useful for Formula fields that are based on other Formula fields or intra-table calculated/lookup fields. Is this feature already available and I’m missing it?

Hi everyone, My partner and I just started to learn on Airtable about weeks ago, and we are now convinced that it’s the tool we need for our organization and business in general. I’m writing a topic to learn more from your knowledge and maybe have some tips to do things right and not to heavy for something that may be simple. Here’s a short brief of our business : We are a start-up that specialized in building neon signs for houses as offices, restaurants/pubs … Our website is 1st rank on our mains keywords on Google, then we use JotForm as form software to receive data. We are able to create around 40 new contacts a day, only based on the forms submitted on the JotForm. Once we have the data, we make designs on Adobe Illustrator based on the needs of the customer. We also want to implement a renting service with some generic products, stocks, availability, calendar etc… What we’d like to make with Airtable : Be able to fo

Is there a way to restore a snapshot overwriting the current base? As opposed to creating a new one. Thank you!

For the last few days, when I try and download as CSV, it says “preparing CSV for download” but it never downloads. This is on Chrome Version 83.0.4103.44 (Official Build) beta (64-bit), Win 10 Both on desktop and laptop, and in incognito mode with no extensions etc. It DOES work in Firefox 76.0 (64-bit), and the only difference is that the error about the WSS connection isn’t present in Firefox. From what I can see, I think it might be something to do with this… https://www.chromestatus.com/feature/5706745674465280 If I go to “network” tab, I can see the following, If I then click it, I can download the file. Just though I’d check here before filing a bug - here’s the browser console output… Resource interpreted as Document but transferred with MIME type text/csv: "https://airtable-csv-exports-production.s3.amazonaws.com/xxxxxxxx[redacted]" vendor-modern.b

Hi All, I’m really loving Airtable so far. I just imported all of my old notes from a past DB, and am in the process of linking each note to each contact and database user. I’m kind of at a loss for how to link them an get expected behavior. Up-front, I currently have about 30k entries total… 13k contacts. 17k notes designated under Engagements. I see plenty of content on how to create inherently linked fields, and have that data flow through as you create new records. I also see plenty of examples of how the data is structured in templates. In my case, from my old DB, I have a unique ContactID, a unique OwnerID, and Unique Note IDs. I would assume that linking ContactID in my Engagements to Contacts would flow through, but somehow it created a brand new series of rows in my Contacts that are completely blank, except for that field… Only about 2k out of my 13k contacts. My desired outcome is to end up with a structure like the Sales CRM, wh

Hello everyone, my first post here, looking for some help. I am trying to Send an email every time a new record show in my View. The problem I am facing is the fields that are “Linked to” are showing up encoded, I want it to show the actual result in the email. For exemple: Name: John Webb is showing up as Name: ecLSgtZ3ZsfIejGD Print screen added. Hope you can help me find a solution for this. Thank you in advance.

I want to share a view with an external collaborator, so they can see a limited set of data from my base. I also want them to be able to update/edit only a single field in those records they can see in their view - ie they cannot create. anew record, then can only update existing records through editing a single field. Is that possible to achieve?

Hello there, newish to AT, i wonder is there a way to set the URL of the attachment field dynamically using code ? i have used the formula field to build a URL to an image, and i know wish to set the URL of the attachment field to that URL ? doable ? thanks in advance for any help you can offer. Kevin

I’m trying to build a sort URI with multiple sort fields and directions, but I don’t understand the syntax. Suppose I have this sort object with three fields/directions: const sort = [ { field: "title", direction: "asc" }, { field: "value", direction: "desc" }, { field: "category", direction: "asc" } ]; //I thought I could just daisy chain them like this, but it doesn't work. let sortUri; sort.forEach(sort => { console.log(sort.field, sort.direction); sortUri += `&sort%5B0%5D%5Bfield%5D=${encodeURIComponent( sort.field )}&sort%5B0%5D%5Bdirection%5D=${sort.direction}`; }); const url = `&filterByFormula=AND(FIND(%221000%22%2C%20%7BLocation%7D)%20%3E%200%2CAND(%7BValue%7D%20%3C%2010000000))${sortUri}`;

I’m new to Airtable. Is there a way to mark an ongoing due date so that it shows up in calendar view say every two weeks on the same day? For example, if I need to design and send out an email blast for a client every week on Wednesday, could I somehow mark the record to show up on the calendar every week? Thanks!

I would like to create a daily log to track how often I got up from my desk to take a brief walk. How would I go about counting the number of times I did it? Here’s what I did so far: Row A (“Date”) Column 1 (Checkbox) Column 2 (Checkbox) Column 3 (Checkbox) Column 4 (Inserted this Formula: SUM({Break1}+{Break1}+{Break1}) It seems like overkill, though, to have to create a new column to track each activity. Is there a simpler way I can do this?

Is there a way to share Views without requiring recipients to create an Airtable account?

I need to invoice/quote customers with layouts that include both text and images. I’m trying to increase the image size of a record but can’t seem to do so. Is there a workaround?

I’d like to embed a view of a specific record on another web site. I’d like to specify the record id / view id on the URL so I don’t have to create a custom view for each record, which is a waste of time. Ideally, I’d like to just embed in an < iframe > the expanded view of a specific record in a view. I’ve tried the following and it displays an unhappy face: < iframe src=“https://airtable.com/tblhtZEdSQOe7XDl1/recP1MM6ZUrqKfpJy” frameborder=“0” onmousewheel="" width=“50%” height=“533” style=“background: transparent; border: 1px solid #ccc;”>< /iframe> The user viewing this webpage will have login access to Airtable. Alternatively, if I could pass in the record ID into an embedded view that would work as well. I know I can filter within the view, but can I specify the filter options on the URL of the embedded url?

Hi all i have tried to “send a record” from a couple of my bases both in free workspaces and a pro plan and i never receive the email i get the pop up of the record enter the email and send and that is the last i see of it. is there something i need to set up? or am i not doing something ? Many thanks for your help Ian

I am using Airtable to collaborate with a group of people with varying permission levels. In some instances as we are working on updates to the Base content, we only want certain permission levels to see the updates being made whilst the rest of the Base should still be accessible to the team. Once these updates are complete, I would then want to publish them for all in the Base to see. Ie. is there an option to add things which only certain permission levels can see and which others (with reduced permission levels) who already have access to the Base can not see until it is ‘published’ for others in the Base to view? Many thanks in advance.

Hi all, I have one table in a base that I would like specific persons (not necessarily collaborators, but Airtable users) to be able to view (and ideally edit), without granting them any access to the rest of the base. I understand that this is not possible as collaborators have access to the whole base and not parts of it. Let’s call this table “Tasks”. I would like specific employees to be able to see, for example, what tasks they have been assigned, their deadlines and so on, without giving them access to other tables within the base nor all of the linked records in the “Tasks” table, which might contain confidential information. I thought of creating a different base that would be automatically populated only by the said table (“Tasks”) but again linking between bases is not supported (I will have to copy/paste records, which is not quite the idea for what I’m trying to achieve here). Any ideas on how to get around this? Thank you! Crisa

Here is the code I am trying to save but keep getting errors. Any ideas? IF(OR({Do you have all the Information needed}=“No”,{Do you have all the Material you need}=“No”),CONCATENATE({My Name},“Can’t perform”{Production Goal for the day/Week:})

I’m using the Displaying quarters in fiscal year formula in one of my tables, however, for some reason, Q4 months are showing up as Q1 in my table. The formula I’m using is below. Here is a snippet of my table Here is the formula listed below: IF(OR( FIND(01,DATETIME_FORMAT({Date},‘MM’)), FIND(02,DATETIME_FORMAT({Date},‘MM’)), FIND(03,DATETIME_FORMAT({Date},‘MM’))),“Q1”, IF(OR( FIND(04,DATETIME_FORMAT({Date},‘MM’)), FIND(05,DATETIME_FORMAT({Date},‘MM’)), FIND(06,DATETIME_FORMAT({Date},‘MM’))),“Q2”, IF(OR( FIND(07,DATETIME_FORMAT({Date},‘MM’)), FIND(08,DATETIME_FORMAT({Date},‘MM’)), FIND(09,DATETIME_FORMAT({Date},‘MM’))),“Q3”, IF(OR( FIND(10,DATETIME_FORMAT({Date},‘MM’)), FIND(11,DATETIME_FORMAT({Date},‘MM’)), FIND(12,DATETIME_FORMAT({Date},‘MM’))),“Q4”))))

I want to use a project management base and then create reports for the executive team to show our progress. Can I create a report? Can I customize it to an in house standard template or a totally custom report with graphics without leaving Airtable? Thank you in advance for your comments and advise!