Other Questions

Is it possible to create a formula or script that will automatically add collaborators to a collaborator field, under a given condition? Specifically, I’d like Airtable to automatically add a “collaborator” to one multi-select collaborator field when that collaborator is added to another specified field elsewhere in the base. In my project mgmt base, we have separate collaborator fields for our Projects and Tasks table: (1) an “assigned to” field in Tasks (defining ONE person who is currently working on a given task) and (2) a “project team” field in Projects (defining ALL the people involved in the project). Both fields are necessary for different types of tracking. The Tasks field allows a user to see the task on his to-do list. The Projects field allows the Project to show up in his “current projects” feed (essenitally allowing him to “follow” the project, even if a task is not currently assigned to him). Unfortunately, this approach often requires double-entry (since, by definition

I have 2 date columns… Date 1, Date 2 2020-10-01, 2023-02-01 2019-04-01, 2022-03-31 I’m using the formula specified here to output the difference in years/months… IF(AND({Date 1}, {Date 2}), DATETIME_DIFF({Date 2},{Date 1}, 'years') & ' years & ' & (DATETIME_DIFF({Date 2},{Date 1}, 'months') - DATETIME_DIFF({Date 2},{Date 1}, 'years')*12) & ' months') It currently outputs “2 years & 4 months” for Column 1 (correct), and “2 years & 11 months” for Column 2 (incorrect). Column 2 is 1 day off 3 years exactly, and I need a way to round it to the nearest month. Any ideas would be very much appreciated.

I have 2 tables… Companies CompanyID, CompanyName, ContractIDs Contracts ContractID, ContractTitle, EffectiveDate, ExpirationDate, CompanyID They’re linked together via the final field in each table where 1 Company can have multiple Contracts. I want to create a field in the Companies table to display the ContractTitle of the most recent contract but am struggling to find a solution using Rollups. Of course, I can add a field to Companies using a Rollup that takes the MAX(ExpirationDate) to at least give the latest contract expiry, but I can’t find a way to use that expiry to bring back the single ContractTitle field with that expiry per Company. Appreciate any thoughts at all on whether this is possible!

Is there an option to limit a lookup field to only one selection in a form (I cannot see it).

Is it possible to change the first view that opens in an iOS app? When I open a table, there is always a view that opens. It’s not the top view, it’s not a favourite view, it’s not a previously opened view. I think the web version keeps the previously opened view, but iOS doesn’t seem to do that.

Hi, I’m manually sending an SMS through Twilio with the SMS app. I have a view called “Stage 2” where all the records that enter this view, should receive our reminder SMS. I created a field called “Sent SMS” which is a checkbox field. Is there a way to automatically set the “Sent SMS” to ‘ticked’ or ‘true’ after the SMS script has run? In order for those records to be filtered out of the “Stage 2” view and not get another duplicate SMS next time we manually send one out. Maybe a script that batch updates all records in view “Stage 2” under field “Sent SMS” to “true”? Could anyone know how to approach this?

Is it possible to copy formatted text (Italicised in places) from Excel and paste it into a Long Text field (with RTF enabled) and maintain formatting? It would be great not to have to re-italicise hundreds of fields manually when pasting this info in. Many thanks!

I have a form wit a look up files, so I open the form to add a new donation from a client, I find the client but what I want to do is when I look for the client I want to see their information (address, phone number etc) can you guys direct me to the correct pad pls

I have a table of species, 1 per row. I have another table (.csv to import) where species are linked to habitats. Each row is a unique habitat, and several rows may be linked to the same species. I want to pull the habitat types into the original species table, where one field captures the many habitat types linked to the species. using linked fields and rollup or lookup I can not get it to show me all the values of habitat that may be associated with a species. It just shows me the first one it comes across. I chose linked to many when I linked it. I searched the archives but couldn’t find the answer to this question (though I’m sure it’s here somewhere) - apologies - I link to the answer would be very welcome rather than rewriting it. Elizabeth

I have seen several posts about this, but they are older. I need to be able to limit the views at various levels for my employees. Per Airtable, you are supposed to have most data grouped together, and use views to filter it. But then there is no way to hide sensitive information from employees which makes all data available to all people. Crazy! All I am trying to do is track projects, but I don’t want my entire company to have access to the financial info associated with each project. Basic basic stuff. I am hoping this has been resolved as it is a pretty basic function. Competitors seem to have it figured out. Airtable, if this is not available, when can we expect this basic function?

Hi! I have a membership community and I am using the Gallery view of AT to share my ‘roster’ of members. I am able to share the whole “gallery view”. What I want to do now is to only share a single record in Gallery view to my members. This concern was discussed in the AT Community last 2019. Then, this feature was not present in AT and a third party offered their product to offer this specific service ie miniExtensions Is there an update to this from Airtable developers? Is there a new solution for this concern?

When I’m using concatenate formula for a unique ID, I’m using it like this CONCATENATE(Task1," - ",{date}). And it ends up being weird-looking, and when I say weird looking I mean only date part is weird. This is what I get “Task 1-2022-02-10T[00:00:00:000Z”. How can I remove those zeroes?

So i was able to successfully test this Airscript – 18 May 20 Unique values Getting the unique values for a field in Airtable It basically gets the unique list from one field, but what if you need 3 fields and you have to get the unique set of records from that list. From 1 A 0 1 A 0 1 B 1 1 B 1 2 C 0 2 C 0 Into 1 A 0 1 B 1 2 C 0

How do i remove users that no longer want access? Not easy to figure out. :frowning: Where do I have to go to manage access of those no longer needed on the table?

Hi, I’m trying to update a record from an original base, rather than the synced one, from the synced spreadsheet. How would you do this? My best try has been to update the original record via Zapier, with the trigger being an unsynced column on the synced table, and looking up the identifier on the original table with the proper identifier. The problem of my solution is that Zapier doesn’t recognize unsynced columns on synced tables for the automation, so I’m stuck with either: Doing something so Zapier recognizes the unsyced columns Finding a different solution altogether What do you think? Thanks in advance **With unsynced columns, I mean the new columns you add on a synced table.

I am not a database person but have built several simple access databases where I used subforms to create a one-to-many relationship. For example, a project tracking, but unlike all of the airtable examples I see, I want to have say a project name and short description in one table and then in the other table a date and a long text field with the particular update for the project. So I could then view each project and all of the updates to it by date. With access this was easily accomplished with a subform linking back to the main table in a many to one relationship. Is there a way to do this in Airtable? I looked briefly at a junction table but did not quite follow, is this how to accomplish what I am after? Thank you.

At work, I’m clicking a button on a gauge and it inputs the measurements into fields from left-to-right, F01, F02, F03, … F50. The gauge connectivity can be bad and measurements are missed, making me have to start over. I usually load Window’s magnifier to see measurements from afar. I was thinking of making an Apps page with F01–F50 stacked (and figure out transparency and stuff) so as I measure, the newest measurement appears over the previous one. Seems like a bad method.

HI, I’m working with Airtables gantt charts but find them a little limiting compared to things I have used in the past. At my company we have events, things that happen over the weekend, and more holidays than most. I would like to be able to block out the entire time an Event is happening because most people can’t work on anything else. I would also like to keep weekends visible because we have tasks that happen over the weekends. Additionally, I would like to see company holidays on the calendar because most people don’t work during those. I know I can hide weekends and holidays, but I would prefer to still see them on the calendar but have airtable work around them. In addition to that I would like to be able to collapse the view more so that I can see more of the airtable in one screen rather than having to scroll a lot to see how projects may overlap. I have worked with other time management programs at other companies that allowed all of this to happen and I am finding airtable’s

I have a table of invoices for hotels where sometimes not all the data comes through, so I get the Total, but not the rate of the items, or the tax. I’m going to set up an automation that reserve calculates, but it’s breaking my brain. So I need a formula that does these: {Total} - {tax}= subtotal {subtotal} - {fee} = Hotel Fare [Hotel fare} / {nights} = nightly rate It seems easy, but it’s not working for me. I’m not sure what I’m doing wrong. Airtable Grid view - Airtable Explore the "Grid" view on Airtable.

I’m evaluating Airtable to implement it in the company I work on. When I try to print a Grid that’s grouped by a field, the title text gets cut, unless I make the first column really large, which is not feasible. Is there a way to make the text wrap to a second line in the title? Printing (both to PDF and on paper) is a requirement, so I can’t work around it.

I’m helping someone with an existing Airtable setup, where we need to sync some additional fields. But I’m not seeing where exactly it is that I’d be able to do select additional fields?

For example, if you add a new field to a table/view that is currently sync’d to another base, how do you get that field to become part of the sync? Is that even possible? In this specific case, it’s a lookup field if that matters. I tried to search for the answer to this question, but haven’t had any luck so far. Thanks!

Hey guys, do you know a way to use a monospaced font on Tables (Grid Views)? It makes things clear since the whole text will align.

Hi, I have 3 Fields “Name” “Results” “Position” I will like to compare the values in “Results” Field and position it from ‘1st - last row’ (Field “Position”) If “Field Results” Row 1 or Record 1 is > Row 2, then Row 1 = “1st” else If “Results” Record 2 > Record 3, then Row 2 = “2nd” else if “Results” Record 2 = Record 1, then Row 2 = “1st” What I want the “Position” Field to do is, compare if Results Field Row 1 is Greater than Row 2 then Position Field Row 1 is equal to “1st” And if Results Field Row 2 is equal to Row 1 then Position Row 2 will be “1st” Or if Row 2 > row 3 then Position row 3 = “3rd” Finally if “Results” Row 1 = Row 2 then both "Position Row 1 and Row 2 will be “1st” But “Position” Row 3 will be “3rd” What formula do I use to achieve this? Help me people This is what I want to Achieve

Hey everybody, I run a large online community and use Airtable to host the member directory. I ask for ~10 or so fields so that it is easier for members to find and connect with each other once inside. I want to build a calculator or questionnaire that continually calculates how many members meet different conditions in the fields. The idea is to use this as a growth tool where new website visitors can better understand how many of their peers are in the group before they submit their information to join. Does anybody have any recommendations here?