Solved

Hello, My app keeps data on my server in sync with changes made to Airtable. My question: What is the best way to subscribe to record updates when using the blocks API? The useRecords hook simply returns all of the table’s records when a record is modified so it doesn’t seem the best way to keep track of updates. It looks as if the best way to do this is to write a custom useWatchable on all the records of the table so that I receive individual records as they get updated but I’d like to know if there’s a more elegant solution than this. I’d also like to know if there’s a native way to get notified via callback or event when a new record is created or if I’ll have to keep track of this on my end. Many thanks

Hi, I have a table called ‘Communiques’ which is linked to ‘Contact’ records. I want to be able to - when I create a new task record from Communiques to automatically have the ‘Contact’ filled in from the Contact associated from the Communiques table. Is this possible? I have created a video to show what I mean: Thanks

Hi, I was wondering if it’s possible to choose which fields appear in the abbreviated list view when I click on the 3 dots next to a link to another record field? I have created video to explain what I mean which you can view below share.getcloudapp.com – 20 Feb 21 Screen Recording 2021-02-20 at 03.18.34 pm.m3u8 Shared with CloudApp Thanks! Thanks!

Hey everyone, Hoping somebody can help here. I’m having trouble returning some info from a formula I have created. I have a table to show the duration of certain tickets that are received for problems. I have a Date Raised field, Date Resolved field, and a Days Outstanding field. I want the Days Outstanding to return the difference between Date Raised and Date Resolved when there is a value in the Date Resolved field, and I want it return the difference between Date Raised and TODAY() when the Date Resolved field is empty. I’m currently using this formula: IF({Date Resolved}!=BLANK(), DATETIME_DIFF({Date Resolved},{Date Raised}, ‘days’), DATETIME_DIFF(TODAY(),{Date Raised}, ‘days’)) It’s working fine when Date Resolved is populated, but returns NaN when it’s empty. I have created another field just to check that the today-date resolved formula works and it’s returning exactly what I want, it just doesn’t work when it’s inside the IF formula can anybody explain this and show me a solu

Hello, I am sure this is a pretty basic question but because I lack of knowledge I want to ask you what I am looking for in technical terms. How do I describe technically correct what I am looking for? This is what I am looking for: I have a “list of zip codes” where each zip code is assigned to a certain value. This value is a tax rate. I also have a “database of clients” where there is always a zip code. I want to find out which tax rate applies to them according on the “list of zip codes”. 3.I have a already a field where I link from my “database of clients” to the “list of zip codes”. If I type in manually in each line the zip code it works! BUT: I created a table where I put the list of zip codes and tax values, I linked it from my table where I store my user data and now I can look up manually by typing in the zip code in my user table the tax value from the new table. But I want that “automatically” so that the zip code from the user table automatically is requested in the oth

I am attempting to set up an automation and have a script update a linked field in a table. When testing my script the output gives me this error. “Your script has a syntax error” (adding this for search engines cause I could not find this on google at all) The bit of code that makes this error happen is this (it has no syntax highlighted saying it’s an error) await customersTable.updateRecordAsync(depo, { 'Dams': dogs }) depo is from here let depo = depositors.getRecord(depositors.recordIds[index]) depo looks like this when logged: {id: "rec1231412312", name: "Some name"} dogs is an array of objects (“dog” records) like this. I’m not sure where to go from here cause this error leads me nowhere. I have tried just passing an array of IDs. I’ve tried passing an array of objects with just the IDs and not the name. Nothing has worked so far. Is anyone able to tell me what I’m doing wrong?

I’m not sure to understand what’s happening. I’m pushing files as attachments and receive the response as expected. For example, I get the following for the file I uploaded: { "id": "attIuYUqNG4YvfUvz", "url": "https://<...>/doc.jpg", "filename": "doc.jpg" } But then when I look at the history, Any tip on why this may be happening? :thinking:

Hi, I’m new - sorry, ha ha! I’m trying to put the date from my date field {Start time for Pre-Meeting} into an email automation but it outputs in the unfriendly format So I’m trying to re-format that date in a formula field using DATETIME_FORMAT but I keep getting error messages. TIA for any help with this one! Cara.

Hello, I am trying to get repeating tasks to work based on their regularity (Daily, Weekly, Monthly) with the IF and DATEADD formula used together. Here is what I have tried: Can anyone suggest where I am going wrong?

Hi, I want to set up automations but ran into an issue I don’t know how to fix (see screen shot attached) I have no idea how to create a non-header row in the Airtable worksheet. I also thought rows in Airtable are called records? Thank you for your help, Steffen

Hello Friends - I created a formula to return the Week # an Item Sold, it was working great until this past week. In the screenshot below the second item in the list sold on August 10, 2019, at 9:01 pm. But the formula in the Week Sold field is returning that the item sold in Week 33 when it is actually Week 32. Here is the formula I’m using for the Week Sold field: DATETIME_FORMAT({Start Date},‘w’) Need your help, I think this is due to the fact that I have hours in my Date Sold field, but I’m not certain how to proceed with correcting the formula. Thanks in advance for your support!!!

We are looking to import a large Excel dataset into AirTable, ~500 multi-sheet xlsx files, as individual Bases. The Add a Base > Import data > Excel file selector has a limit for 1 file. Is there a means of creating multiple Bases off of a bulk upload process?

Hi all, Is there a way I could pass markdown - result of script run to automations? Like in the example here where the output table could be send in an email?

Hi, I’d like to rebound on a question by @Javier_Growth_Lab which has not been solved and the topic closed. I have set an automation to send a mail to my base collaborators. It works for all of them but one, The email is correct and is associated to my collaborator’s account. I did not set any address restrictions and he otherwise can perfectly interact with and edit the base. So I am a bit lost, I’ve tried the automations step by step and it works for other users, but for that one collaborator, the run fail message reports that I can’t email non-collaborators - but he is indeed a collaborator. Thanks in advance for your lights Cheers Kevin

In the documentation for the NOW() function it states that: If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies. I have a Zapier process that polls a view, does this count as a sync dependency? The formula i’m using calculates whether the value in a date field is greater than the current datetime, and if it is it will appear in the View that Zapier is watching. It’s important that the formula is calculated 24/7 and not just when the base is open.

I’m trying to use Airtable Automations to an update to a single select field that I use for status on my records. I cannot see a way to tell my automation to change the value in this field to one of the pre-defined possible values for my status field, so I tell it to just use the name of one of my values. The Automation then creates an entirely new status for my single select filed, with that name, so I wind up with a duplicate value in my single select field, and the record status is set to that duplicate value with an identical name, rather than to my desired value. This means that my downstream automations triggered from that desired status do not fire, because the record is set to some new status which is completely separate, even though it has the same name. How can I make my automation update the single select field value to one of my predefined possible values?

I am using python to run sum calculations and data summaries at various sub-groupings. This is being done using python pandas and the data format is a dataframe. I have to convert this dataframe to a list according to the airtable python wrapper documentation, which I have used before, just not the dataframe part. After converting to a list, I am getting this error requests.exceptions.HTTPError: (‘422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2’, “422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2 [Error: {‘type’: ‘INVALID_REQUEST_BODY’, ‘message’: ‘Could not parse request body’}]”) is anyone familiar with this any why it is happening?

Hi, Apologies if this has been covered elsewhere. I’ve got a table with 3 fields: Customer (Single Line Text) Interests (Multiple Select Field) VTS (Formula Field) and I’m trying to get the VTS field to populate with the Customer Code if “VTS” has been selected in the Interests field. I used the formula IF({Interests} = “VTS”, {Customer}) Screenshot 2021-02-13 231010|700x490 and it returned a result when “VTS” was the only item selected in the Interests field, but not when more than one option had been selected. I’m assuming it’s the equals sign that needs editing, but I’m not sure what I need to replace it with. Any help would be much appreciated.

Can you spot an error with this formula? I’ve tried multiple variations and keep getting, “Sorry there was a problem saving this field. Invalid formula…” SUBSTITUTE( SUBSTITUTE( SUBSTITUTE({Status}, “Destroyed”,”Sold” ), “Gifted”,”Sold” ), “Stored/Loan”,”Sold” )

Hello! New Airtable user here! I’ve been racking my brain for days trying to figure this out. I am trying to create a formula based on a selection. What I am trying to accomplish is: If the rate is HOURLY, calculate date/time difference for # of hours If the rate is DAILY, calculate date/time difference for # of days if the rate is TOTAL, calculate the rate X 1 Any help or suggestions would be awesome!

Hello, I need help trying to figure out this formula. I have spent the last three days looking through the community and I believe this is the closest article I can find, (Formula Help! IF AND + checkboxes) but I still can’t seem to get this working. I originally created an IF statement based on blank fields. The purpose was based on keeping track of our workflow. Now, we have the need to added other “flags” that I will need to change the formula to "Done! " without completing all the steps from the original IF statement. The first flag is a “Canceled” Checkbox. If the checkbox is checked I need the status to change to “Done !” regardless of other fields are still blank. The second is new additions of two extra fields added to the Single Select field in the Shipping Method. If the option of “Picked Up” or “Dropped Off” is selected, I would need the Status to change to “Done”, without having to select a date for the “Delivered” Column. What I am trying to accomplish is when either o

Hello, I am not sure how to word this and did not find any topics that matched what I wanted to achieve, so I wanted to ask if this is possible. We track all of our orders within one table. Each order has a unique name. That name comes from a ticketing system. (Example REQ0000001) We have a team of about five people who pick these orders to ship off to customers. I am often asked what is on the order because sometimes all the fields don’t populate correctly on the ticketing system. What I am trying to achieve is a self-serve user portal, where the team can type the request number and they are shown the line items of the order. I guess like the opposite of a form entry, but instead a record lookup. Any ideas would be appreciated. I am guessing, I might have to use a third-party app to achieve this.

Perhaps I am just completely missing something but I have been attempting to set up an automated outlook email to send certain notifications to some of our customers. Most of the formatting I have been able to find in the link provided in the automation on Airtable’s markdown syntax. The only thing I am struggling with is line breaks. The documentation states that “Every line break will be treated as a hard line break”. When I test out the email by sending it to myself, I notice, that everything, regardless of how many line breaks I manually put in to the preview, comes out with only a single line break. Example: In the example above, ideally, there would be an extra space / line break between the statement above it and the word “Sincerely” itself. Just curious if anyone had a solution or additional information on this matter? Thank you for the help in advance!

Hi there, I recognize the power of regex expressions, but I’m just pathetic at composing them, so I’m reaching out for help from someone who actually understands the syntax. I have a table in which all entries contain a URL with this structure: https://scholarship.ode.state.oh.us/Student/Home/Details/555555?stdntID=444444 From record to record, only two components of the URL change: The number immediately following Details/ (i.e. 555555) The number immediately following stdntID= (i.e. 444444) I need to write two formulas, one for each of the components named above, to extract these unique numbers. If anyone could help in this regard, goodness what a kindness it would be. Thank you for taking the time to read and consider.

HI All I am wanting to have a trigger set for a reminder to follow up on a job/task, eg; when something is urgent i want it flag me every day, important every 3 days, general every 7 days, once i have followed up and changed the dates of last follow up. I can’t seem to get the trigger to work when i’m trying to set up in automations.