Solved

Hey Airtable community, Here’s my formula. The formula itself works, but I want to format the output as a currency. Why is Airtable saying it’s not a number? IF({Score} = 1, "75", IF({Score} = 2, "120", IF({Score} = 3, "180", IF({Score} = 4, "240", IF({Score} = 5, "225" ) ) ) ) ) Any help is much appreciated! With warm regards, Alex

Morning all. I have a base I’m working on that calculates overtime, It also compares the overtime shift worked to an employee’s scheduled shift. I have a set of DURATION fields for each employee - Mon Start, Mon End, Tues Start, Tues End… for all 7 days of the week. Based on the day of the week our OT shift works, it shows the appropriate day’s shift. I’m pulling the start date of an event from one table (Overtime Events), the employee’s normal shift from another table (Employee Data), and the calculation is in a 3rd table (OT Shift Data). I’m trying to concatenate the DATE ONLY from when an overtime shift begins, and the DURATION field from the employee’s info, to create one date field I can use for other calculations. None of the date/time formulas seem to give me the results I’m looking for. Can anyone please offer any advice?

I am trying to push multiple values in a look-up table at once to a single update field. So far I am filtering the record, finding the IDs of the values in one of the values. Pulling out specific ones and then I am not sure what to do to update multiple values inside of a new field with a look-up table. Note, I didn’t copy and paste properly. The syntax is not the problem, the problem is that I do not know how to get the multiple look-up values to update. //// CODE BELOW testID = “recZnhmuRKPJEvVE0” let t_results = base.getTable(“results”)// let thisrecord_as = await t_results.selectRecordsAsync(); let thisrecord = thisrecord_as.records.filter(f_record => f_record.getCellValueAsString(“cli_res_id”) ==testID ); for (i=0; i<thisrecord.length; i++) { let this_spec = thisrecord[i].getCellValue(“Input_Look_Up_Field”) let this_fm_id = thisspec.id var pushval = { fields: { "UpdateField": [{id: this_fm_id}] } } } if (pushUpdates == 1) { await t_Client_results.updateRec

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!