Solved

I have a Scenes Table with records listing each scene (Scene Name) to be shot for a video (Video Title). Once the Scene Names are all listed they go to a Shots Table where shots for each scene are created. In the Shots Table each record is based on the Shot Number. I have a checkbox field (Shot?) that I check when that shot has been filmed. Filmed scenes get sent to an Archive View when that checkbox field is checked. What I’d like is an automation that checks my (Shot?) field in the Scenes Table when all shots for that scene have been checked in the Shots Table and entered the Archive view. For example, in the screenshot below when the shots listed in the (Shots) field enter the Archive view in the Shots Table the (Shot?) checkbox gets checked. If a trigger tied to ALL shots entering Shots Table archive view is problematic, I’d settle for when any shot enters the archive view for a scene, it triggers the checkbox for that scene in the Scenes Table. Thanks for your help.

Hi, I’d like to have a view that shows only the records that are created when a form is filled out and then sent. I sometimes add records mannually in a table, but most of the time the records will be created by someone (client) that fills a form. I’d like to have a view for only those records. Does that exist ? Thanks Thanks

My coworker is leaving the business, and so her Airtable account will be deactivated after her last day next week. Will her name still come up in activity history if she had done something? or if she had been tagged in something?

We have a base that lists all of our dealers’ contact information, including state. State is a single-select field, with all states listed, just to make it easier for people to enter the correct state, and also to ensure consistency of the state abbreviations. I created a grid view grouping our dealers by state, which worked fine. However, at the top of the list is an “empty” record – and I can’t figure out why. I looked in the single select list (where you manually input the data) and didn’t see any blank or empty fields. I also looked at all the individual dealer entries to make sure each one has a state selected, and they all do. Any ideas why that empty field is appearing?

I have some multiline text I for some reason do not seem to be able to split into parts. My text is: “506070 80” let arr = multi.toString().split(" "); console.log(arr) //["506070 80"] Does anyone know how I can split this? If i make real space in the multiline text it splits as expected.

My office manager and myself are both owners on the same table which we use to track orders. Sometimes it is necessary for us both to be in that base/table at the same time but be filtering for a different thing (typically customer name). If I have it filtered for last name “Miller”, but in her workspace she needs to filter by last name “Jones”, I lose the Milers and suddenly see the Jones. This obviously doesn’t work for us! This is the reason that I created a separate user for her–I hoped this would solve this problem. I don’t want the same view as a different user, I want the filtered view I select. We both need to be able to make changes to the table so we both have full permissions.

Hi there - Currently, I am trying to do a data automation script to check if values meet specific criteria and then make recommendations for what is there vs what isn’t. The script is working as intended, however my CPU time is exceeded (3438 ⁄ 1000ms). Any recommendations on how to fix?

Hi all, I’ve read various threads on permissions etc when sharing Databases. I am still confused if it’s possible for read only users to still be able to filter views or if there is any way at all to be able give people the ability to use filters without having to pay extra on my monthly bill. I think I’ve tried the various methods but every time I make the access privileges read only the filters disappear. For people viewing the data it is only really useful if they can filter it down to what they are looking for. I’m also a bit worried in my tests if I gave someone editor permissions im suddenly going to be billed for it *yikes! Any help would be brilliant. Glen

I’m surprised I can’t find anyone else having asked about this; is there any scope for: increasing the PATCH limit from current max of 10 or making it explicit in API documentation that PATCH is limited to 10 … so users aren’t left troubleshooting an error that can be quite subtle (I had to tell browser console to unfold several layers of nested error logging).

The primary table contains an appointment date (date field - ‘Appt Date’) and pre-set appointment times (single select field - ‘Appt Time’). We have configured a single-select field (‘Action’) to manually add the record to a view, which successfully triggers the sending of a text message via Zapier and Twilio. We want to automate the sending of the text 30 minutes before the appointment time, but we have almost no experience with formulas. The formula should set the ‘Action’ field to ‘Send Appt Text Reminder’ 30 minutes before the ‘Appt Time’ when ‘Appt Date’ is today. Your help is appreciated and suggestions for a better way are welcome. We are slightly limited, I think, by the fact that the Zapier/Airtable trigger is when a record first appears in a view. But we have everything working manually; now we want to automate the sending.

I’m rolling up a list of quantities, and need to determine which quantity was the most recently ordered. I have a separate Rollup field on the same table identifying the most recent date, but I need to be able to set the value of the filter on quantity rollup to only show the quantity when the production date matches the date I have in the second rollup field. Is there a way to set the value of a filter to match a field value? Cheers, AK

Hi My automation behaves strange when using two trigger conditions. I created a very simple automation to demonstrate the bahavior. Trigger: When record matches condition When “Force sync” is True OR When “Time since last modified” > 600 Action: Run a script (using default code) Some explanation about the settings: “Force sync” is a checkbox field. I use it to force the automation to start “Time since last modified” is a formula field that calculates the time (in seconds) since the last modification of the record. The formula is IF(DATETIME_DIFF(NOW(),{Last modified time},‘seconds’)>1000000000,-10000,DATETIME_DIFF(NOW(),{Last modified time},‘seconds’)) The issue: The automation isn’t triggered when the “Force sync” is set to true. The cause? Apparently it has to do with the formula field. If I change it to a Number field it works as expected. Then why is it now working with the formula? KR Ashgard

I’m a newbie so this may be a dumb question. I’m building a To Do list. I’d like the primary field to be a Single Select for category (priority to do, shopping list, normal to do, etc.). Since Single Select is not available for the primary field I thought of using a formula that would simple be the name of my category field. This works, but duplicates data in the category field leading to confusion. I thought about hiding the primary field, but this also is not allowed. I then thought of auto number, but this too is not allowed. I tried the function record id. It works, but what it returns is confusing and meaningless to the casual user. Can someone suggest a better way? Thanks

i have the following colums that iam trying to combine in a formula : customer billing (with only two possibles choices: direct or indirect) indirect total sales revenue (a formula which multiplies a monthly amount by a number of months) I need a formula in a new column which combines the two following conditions: IF “indirect” is chosen, then copy the same amount IF “direct” is chosen, then apply a 12% on the “indirect total sales revenue” i hope it is clear enough. Thyank you very much in advance! fsabate@isadviser.com

Hey there. I have a custom app that’s installed in a couple Tables. I would like to convert it to a Marketplace app so that others can install it. How can I make that happen?

Hello, is it possible to move/export a tab from one base into a different base within the same Workspace without having to download the CSS and losing all of the attachments, formatting, etc.? And if that’s not possible, is it possible to merge two bases? Apologies if this is basic or has been answered, I could not locate any previous discussion on it. Thanks!

Hello Everyone, We have a QR code tenants can scan which will redirect them to a form to fill out. We are not really fans of the fact the form is in a airtable.com/blabla website instead of one of ours. The QR code is already printed and scattered around the community and it leads to an airtable.com/blabla website. Can we redirect the users after they scan the QR code to a custom website which has the form held on the airtable.com/blabla website? Thanks

Hi all! I have a base of student information that needs to be updated every semester when new students enroll. I get an excel spreadsheet from our registrar with the student information on it, but I’d like to pare it down to just the unique records before I import, or have Airtable only import unique records. I just dumped everything and used the Dedupe app last semester and it took me several hours to tidy everything up, so I’m not doing that again. Is there a quick way to only import unique records into Airtable?

I’m trying to use an automation to look for a record in one table to update a record on another table. I’ve created a form that I’d like my team to use to update students testing status (Yes/No) I tried to set up the automation with a Trigger on a new record created on the Test Update table I’d like to use the student name on this new record from the Test Update table and look up their info on a separate table to update their Test Status. It looks very easy to set up but I must be missing something obvious because I can’t get this to work. The trigger appears to be working, but in the update step, I get an “invalid input” error. Attached screenshots of how I set this up and the error info.

As you can see from the image, I want to add a drop down option to multiple records. Is that possible? If not I need to manually select for a lot of records…

I’ve read in this thread that the Airtable block CLI requires Node versions below 15. Unfortunately, I’m on an Apple Silicon Mac trying to help my fellow developer with a custom app project. As it turns out, as far as I can tell, Node 15 is the minimum that builds on Apple’s arm64 architecture. This in effect means that until block is updated to support Node 15, I cannot help build custom apps. I have tried installing older versions of Node with NVM, and they fail to build. Is there any way that I can use block with Node 15, or any idea of the timeline for it to be ready?

Hey Everyone! I have a lookup column with dates like this 5/30/2020, 5/29/2020, 5/15/2020, 5/7/2020, 9/21/2020, 11/27/2020 I need to only show the last date. I also need one for only showing the first date. Thanks!

Hey all, we are trying to get unique project numbers for our airtable. (We are managing video projects). Last year, we just did an auto number and had a formula to add 20000 to that number. 20001, 20002, 20003, etc. This year, we want the unique project number to be P21001, P21002, P21003… P for our name, 21 for Year, and 001 for the unique project number. We also want 2020 projects to be P20001, etc. I found in the forum the formula for getting the YY: MOD(YEAR(CREATED_TIME()), 100) Can someone help me figure out how to make the formula that will work for any year in this way? Thanks so much in advance!! Austin

Imagine I have 2 tables: STORE and ITEMS STORES are linked to the items table so that multiple items can show up in each store. The ITEMS table has a column called “Last Updated”, which is a bunch of dates I created a lookup field on the STORE tab that looks up the linked ITEMS “Last Updated” field. This returns a list of dates in a string: 10/20/20, 10/19/20, 11/2/20, etc Question: I want to take the Max of this field but I don’t know how to do this. I tried a formula like: Max({Items Last Updated}) but that doesn’t seem to work. Sadly, Airtable doesn’t seem to have a Split() formula equivalent. Any ideas? Thanks in advance!

If I add four collaborators to my Pro plan base, can they add other collaborators? If so, is there a permission setting to prevent this (both for security and cost reasons)?