Solved

Hi, I have a time and date stamp being created in a field (Last Modified Time) for a field that we use to say when an Estimate can be made - sort of a “Clock starts ticking Now!” timestamp. The original field that the Last Modified is watching is filled by a Zapier workflow. I then have a second field that gets time and date stamped (Last Modified Time) with when we check a box for when a user says the Estimate is done. Lets say the 1st field has a date and time stamp of 8/1/21 2:30 pm, and the second field has a time stamp of 8/2/21 3:34 pm. How do I calculate the difference between the two? The goal is 48 hrs, so if the total came out as hours I would be fine with that. I currently have tried the following formulas but it seems to be related more to the fomatting allowed by AT but that is just a guess. Here is what I tried: DATETIME_DIFF({Time Stamp on Estimate Checked}-{Time Stamp - Start Time}) also tried: {Time Stamp on Estimate Checked}-{Time Stamp - Start Time} Any help would b

Hey all, I’m struggling to create a view… For context… the table in the screenshot below is an integration that copies every email from my gmail account into AT. I’ve grouped this particular view by “subject line” for the purpose of “batching together” subject lines that have been sent twice or more. My Q is - how do I create a filter that ONLY shows the groups that have 2 or more of the same within them? In other words, how can I create a filter that shows only the emails (subject lines) that have been sent two times or more? Thanks! Christopher

I have been messing around with formulas for two days, trying to figure out how to put a checkmark in the column if the post date is today or after. So, for my social media posts (which I don’t have automated from Airtable, I post them using another platform), once the time has come and gone that the post should have gone live, I want the formula column for that record to have a check box. Thanks in advance for any help with this. Kelsey

Hi! I am trying to set up a field to automatic track the day of a meeting. This meeting is the last Thursday of each month. I found a formula to automatically populate the last day of each month but I can’t find/figure out a solution to change that date to the last Thursday. For Example Last day of the month for August is 8/31/2021 (Tuesday) but I need it to be 8/26/2021 (The last Thursday) Here is the formula I found for the last day of the month: DATETIME_FORMAT( DATEADD( DATETIME_PARSE( DATETIME_FORMAT( TODAY(), ‘YYYY’ ) & ‘-’ & (VALUE( DATETIME_FORMAT( TODAY(), ‘MM’ ) ) + 1) & ‘-01’, ‘YYYY/MM/DD’ ) , -1, ‘day’ ) , “MM/DD/YY” ) I was thinking another formula field using WEEKDAY() might work but it just gives an error when trying to change the day. Thank you in advance!

I created a formula field to merge three date fields into one. No record has more than one date, so I wanted them all to be in one place. However, when I used concatenate, the dates are very long, so I’m trying to use DateTime_Format for all three, but I keep getting Errors. I’ve tried looking this up and have tried different combinations, but no luck. Here’s what it looked like originally before I tried formatting

I’m not a programmer, I’m trying to update a record based on the conditions selected. I’m battling to understand the ‘await’ function. I believe it’s a promise and that it splits the code until the conditions are fulfilled? I kept getting an error if I put the await inside the if conditions. I’ve re-written this a few hundred times and tried looking up what other people have done and now I’m throwing in the towel. Below is the full script, any guidance would be hugely appreciated. // Change this name to use a different table let table = base.getTable("Game Tracker"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let seats = record.getCellValue("Employees"); let segmentSize; await table.updateRecordAsync(record, {"Segment": segmentSize}) if(seats) { if(seats > 300) { segmentSize = "Enterprise"; } else if (sea

Hi all, I am trying to combine text from two fields using Concatenate (and that’s simple enough) but when I try to add a Substitute formula to shorten one field’s text, it doesn’t work. I am new to formulas, and am sure I’m doing something wrong here. Here are the two formulas that work on their own, but not together. Thank you for any insights! SUBSTITUTE(RIGHT({2021-22 School Program & Membership},LEN({2021-22 School Program & Membership})-22) CONCATENATE({Program Booked},’ / ',{School Name})

I’m trying to import a large spreadsheet to a new table. The spreadsheet has about 8.5k rows and about 30+ columns. I’ve tried to import it via both the Google Sheets and Excel importer and in both occasions (on several attempts) it shows the correct data/sheet to import but on clicking ‘Import’, it just hangs on ‘Importing your data…’ with a spinning circle (and a greyed out background). I’ve even left it for 24hrs and it’s still on the same page. I’ve cancelled and started again several times and the same thing keeps happening and there’s never any evidence of even a partial import (it never even creates the new table). Can someone please advise only I’m not a enterprise client (I’m a Pro Client) so they’ve advised I contact the forum. Thank you Stephen PS I’m importing in from the Mac Desktop Client not via the Web Client.

Hello, Is there any way to allow only some fields to be editable in a view ? Through sync’ed bases / views / anything? Regards, Ruchika

Hi all, I’m trying to create a formula that helps me trim a product specific link to its root website link. For example, I have: https://freestar.co/products/12-x-bottles And want to get: https://freestar.co In some cases, the links are https://www. and sometimes they are are above (without the www). Could you help me out?

Is it possible to access a base outside of a base in which an app is installed? That is, if my application is integrated in one base, can it use something similar to the useBase hook on outside bases to which I have access?

I’d like to have a zap that takes a new lead of ours and creates/updates them in a base we have for leads. Within this base, we have a multiple select column that indicates the source of the lead. As leads can enter our world in many ways, we are looking to capture all the ways they’ve interacted with us prior to arranging a sales call, or becoming a client. I have no issues creating a zap to do this, EXCEPT when it comes to the source field which is the multiple select. Is there a way to ADD to the list instead of having the field wiped of what is already there and only showing the source provided by the zap that just completed?

I have created a form under one tab, when I add another tab could I duplicate the form I created before under the first tab?

Hello, Cell value 0 is blank Cell value 0.00 is blank Cell value empty is also blank How to treat cell with 0 value and empty cells differently? All the following forumas are returning result for both the {Buy} cells that has zero value and the {Buy} cells that are empty. I want result only for the cells that has 0 or more value not the cells that has empty values. IF(AND(IF({Buy} >= -1, TRUE(), FALSE()),{Sell}), (Sell-Buy)*Lot*Qty) IF(AND(IF(NOT({Buy} = 0), TRUE(), FALSE()),{Sell}), (Sell-Buy)*Lot*Qty) IF(AND(IF({Buy} = BLANK(), FALSE(), TRUE()),{Sell}), (Sell-Buy)*Lot*Qty)

Hello Community, i have a “problem” about shared view with my clients that doesn’t have an Airtable account. They can open the view normally and see data, click buttons and so on without any problem. The issue occurs when they click the button that opens a form to upload new attachments: the problem concerns the update of new attachment in the shared view, they need to reload the view to see the new attachment while in my view this happens in real time without reloading. Anyone have a solution? Thank you, Alex

Hello, I’m trying to generate a monthly report can someone give me an idea on how to do it please other than Filtering the date.

I would like to switch from Pro plan to Free plan for a few months while it will not be getting used. I currently have several thousand records, far more than the free plan will allow. When I switch back to Pro plan will all my records still be there?

Hello people, My goal is to use sweet airtable to store the data from my psychology experiment. I would like to create 5 table (Metrics, 1-4 experiment). Each experiment needs to contain a lot of fields. Data schema is -probe[i]-id -probe[i]-feature1 -probe[i]-feature2 -probe[i]-feature3 -probe[i]-feature4 Each experiment will have i === 192 which means I need to create 960 fields. I was searching for script to do it automatically, however I did not find per-defined one. I found this site (Airtable Blocks SDK), however I have not clue how to get is going (tried automation, apps). Im not sure, if the tool is not suitable for the task or my programming skills are not suitable for the tool. I would be grateful, once I will get advice how to overcome the problem. Cheers

I’m probably overthinking this, but struggling to find the right formula to accomplish the following: I have a list of addresses in abbreviated format “123 Main St”, but some addresses have numbers on the end (“123 Main St #2A”). I’m trying to find a way to extract the “St” without affecting addresses with street names like “State” or “Sterling”. It doesn’t need to be perfect, so addresses with St that have a number after them can remain in that format. I’m thinking I need a formula that combines IF, RIGHT and SUBSTITUTE, but can’t quite get it. IF “ST” is contained in the last two characters, extract them. Thanks, Airtable!

Hi everyone, struggling to pin down a formula… My goal is to track investments over time (i.e. date of deposit, how much was deposited, what the total amount was in my wallet at the time of that deposit, and finishing with profit/loss since I began). The formula I need is for profit/loss since starting. I figure this value is “Total Amount After Deposit” minus the SUM of all values in the “Converted” field (which are all deposits converted from EUR to USD on the investment platform, i.e. Converted1, Converted2, etc)… So how do I get the SUM of ALL Converted values into the formula? (See screenshot for reference) Any questions/clarification required, please let me know. Thanks! Christopher

Hello Airtable community! I’ve been cobbling together a Base for managing my freelance business which includes tracking bank transactions, expense categories, clients, projects, billable hours, etc. I’m attempting to recreate the 2021 Tax Rate Schedule for the Single filing status from the 1040-ES. I believe I’ve gotten most of the income tax bracket arguments to trigger properly but am stuck for any amount over $209,425.00. Adding even $0.01 to that quantity ends up with a seemingly empty result. Where am I goofing up my formula? IF(AND(INCOME >= 0, INCOME <= 9950), (INCOME - 0) * .1 + 0, IF(AND(INCOME > 9950, INCOME <= 40525), (INCOME - 9950) * .12 + 995, IF(AND(INCOME > 40525, INCOME <= 86375), (INCOME - 40525) * .22 + 4664, IF(AND(INCOME > 86375, INCOME <= 164925), (INCOME - 86375) * .24 + 14751, IF(AND(INCOME > 164925, INCOME <= 209425), (INCOME - 164925) * .32 + 33603, IF(AND(INCOME > 209425, INCOME <= 523,600), (INCOME - 209425) * .35 + 4

I have 2 different kinds of {App Pseud} formats, e.g. kay_obsessive goblin fic (Kiestan) Then I have a formula to spit out a URL, where the concatenate is the important bit: IF(OR({Work Submission Pseud}!={Synced Participant},{Assigned Writer(s)}=BLANK()),BLANK(),CONCATENATE("https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/",SUBSTITUTE(TRIM({App Pseud})," ","%20"))) And it spits out these URLs: https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/kay_obsessive https://autoao3app.firebaseapp.com/#/mfd2021_round2/user/goblin%20fic%20(Kiestan)n The extra character on URLs where the app pseud has a parenthesis always matches the character just before the ). I don’t see what is causing it in the formula. Help!

Hi, I am currently connecting to airtable data via the API. I am able to sort my response in certain fields using desc and asc. However for non text fields in particular single select fields where in the UI you would sort First-Last. What would the parameter be for sorting these fields?

Part of my custom APP takes a number of different user inputs from a UI, and writes some of the resultant information as a new record in a table. In particular I want to do the following: Write a string value to a linked field in an existing table The string value to be passed is already guaranteed to exist as one of the linked options (since the user selected from a Select menu which is in turn populated from the table. *There are some other fields which need to be written as part of this record. The code looks something like the following. `` let machineNameField=tableTasksByMachineNumber.getFieldByNameIfExists(‘Machine Name’); let machineNamesRecord=useRecords(tableTasksByMachineNumber,machineNameField); let machineNamesList=machineNamesRecord.map(record=> {return(record.getCellValueAsString(machineNameField))}); let machineNamesListFormatted=machineNamesList.map(x=>{return({label: x, value:x})});` Machine Selection <Select

I’m developing an API on Node.js + express on Heroku, and every time I fetch anything with POST, I get a 400 Bad request error. Postman requests to the same endpoint work perfectly. So the only hypothesis I have is that I need a ‘Host’ header in my Airtable request (when I remove the ‘Host’ header in Postman. I get the same 400 Bad request error), but I don’t know what this ‘Host’ header should be. To reproduce: Create a simple Node.js+express app on Heroku where you return the same body as you get: app.post('/', (request, response) => { response.status(200).send(request.body); }) Create Airtable automation with fetch (or an app with remoteFetchAsync): let response = await fetch('https://....herokuapp.com/api/', { method: 'POST', body: JSON.stringify('Hello World!'), headers: { 'Content-Type': 'application/json; charset=UTF-8', 'Accept': 'application/json'