Other Questions

I have a Formula Field that creates a custom URL from my airtable. In the past, if a piece of data was missing in the airtable that was referenced in the Formula field … the data would just be empty. Now though, it’s throwing an error unless all of the data is populated. Does anyone have experience with this? Can you do something like =if(isnull, “noData”) in the formula?

I would like to keep a total score in a separate field based on certain values in 1 to 10 fields. So let’s say: Field 1: Yes Field 2: No Field 3: Yes Field 4: No Field 5: Yes Field 6: Yes Field 7: No Field 8: Yes Field 9: Yes Field 10: Yes Then a summarized 7 must be placed in the final number field. 7x yes = 7 and if I change field 3 to no after 2 weeks in the database, then field must become final grade 6 without having to do this manually. Is this possible and if yes how? I read about rollup/formula fields but how to do this on these 10 examples fields? It should be all present in 1 table and not different tables.

Hi guys, I’m currently building a web app that connects people via text (will be done on whatsapp at first). I have a list of pre-generated whatsapp groups in a data sheet on airtable. This is a simplified version of the current flow I have set up: Customer signs up on site -----> all customer data from signup form moved into Airtable Zapier pulls relevant fields from Airtable -----> Automated text is sent with blank fields filled in Here is my issue: it looks like Zapier is only allowing me to pull fields that are populated from the customer signing up. Meaning, their name/phone number/email etc. I need it to pull from a different data sheet on Airtable. Is it possible to have Airtable update the field that was just created and add another column to it, prior to the next automated text zap? Here is an example of what I need to happen: John Doe signs up with johndoe@gmail.com and 444.444.4444 John’s record is updated in Airtable with his signup info John’s record is updated in Ai

I have a base that I’ve given “Commenter” access to. Is there a way to disable the “Download CSV” and “Print View”. I was surprised they showed up as options for a commenter role. Thanks, Stacey

OKTA is web portal provides services of SSO, Life cycle Management, Universal Directory etc. Is it possible to integrate Airtable to OKTA provisioning? Which Airtable plan supports integration? Please share plan and pricing details.

So I have a table called “Todos” with all of my todos. Each todo has a start date and time & end date & time. I have another table called “Calendar” that uses Airtable Sync to sync with my Google Calendar. I want to schedule my Todos IN CONTEXT with my Google Calendar events. To do this, I want to see my tasks AND Google Calendar events in one calendar view. Specifically, what I really want to be able to do is, drag, and re-arrange a Todo AROUND the events populated from my Google Calendar. I do not know how to achieve this second goal. The closest solution I thought of was to create a NEW Base and sync my “Todos” table and my “Calendar” table (since you can’t create a synced table from a single base… WHY?). This DOES let me see everything in one table, but I can’t drag my Todos around to re-arrange them. Here is a Loom video describing what I’m looking for in case that’s more clear: https://www.loom.com/share/9122696d6c5845088b19c363ca272ca8 I’d appreciate some advice here :

Recently, the interface has changed, moving the names of people who are notified of comments way up to the top. It was WAY easier to see who will receive comment notifications when those names were listed at the bottom, when you clicked into the Comment box. Those tiny, overlapping circles of user icons at the top takes much more effort to explore. Sure hope Airtable moves them back to the bottom, or at least makes the names more discoverable.

Hi there, I’m sharing a view in Airtable with the SHARE VIEW functionality with my work colleagues, and have added a password for protection. The password works for 1-2 days, then stops working and I have to reset with a new one. Has anyone else experienced this issue? I’ve looked online but can’t find a solution. Thank you

When adding a base to a table, I was wondering whether it would be possible to have developments with the same title combine so we don’t have two of everything? This is obviously possible with the fields, but was hoping it could also be done with titles as well? Thanks in advance.

Hello. I have a base that I offer for sale as a template. The purchaser copies the base to their account upon purchase. Is there any way of natively finding out how many times one of my bases has been copied? If this is not natively possible, is there any way of accessing the meta data for this? I’d like to understand if the number of sales correlates to the number of times it’s been copied. Many thanks,

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.