Solved

Hi Everyone, Thank you for reading my message ! I’m encountering an issue I don’t understand, as it should be pretty straightforward. Maybe one of you may help… The “Event” table is Linked to the “Invoices” Table, through the Invoice_ID’s linked record (see below) : An Event can have multiple invoices attached to it (as in multiple attendees). However in the above screenshot, the Invoice ID that you see IS NOT in the “Paid only Invoices” View, and appears anyway in the Linked record field which, as far as I understand, should not : My idea is to manage Event stock with Paid only invoices, so for me it would be very practical to have this information on this table. Thank you or your help with this ! Best, Da

I don’t see anything in the Developer docs for Apps or Scripts which has the option of setting a table’s or field’s permissions. There are methods to see if the table or user has permissions to make changes, but none to set them through the API as far as I can tell. Use case: I have created an archive of a large base with many tables for posterity prior to deleting a bunch of data. I’d feel better with the archive copy locked down to prevent any modifications. It would be great to be able to for-loop through the table’s and fields to lock them down in order to prevent record deletion, new record creation, and modification. Is there a way to do this programmatically or only through the GUI?

I extract only year from date field with DATETIME_FORMAT(Date, 'YYYY') and assign it to new field. If I order by that field it isn’t recognized as number, but as a string (the option is A-Z or Z-A). How can I change it to a number?

Hi all! I need help in calculating the average value of a single select field. I tried the count(values) and it works. However, AVERAGE(values) gives me NaN. In the image 2, I’ve created a roll up field of the linked records An alternative to this is creating a field in the first table with the formula VALUE(Strategy - Top Ten Targets (Pitch 1)) and then using the roll up function on that field and works! But I want to know whether it can calculate the average just by changing the formula in the roll up field. Thanks in advance!

I have a marriage date for some people and no date for others. I created a field called THIS YEARS ANNIVERSARY as shown below. IF({Marriage Date},DATETIME_PARSE( DATETIME_FORMAT( {Marriage Date}, ‘MMMM D’ )& ’ '& YEAR( TODAY() ), ‘MMM D YYYY’ )) I need a formula for NEXT year’s anniversary. If THIS YEARS ANNIVERSARY was a simple date field, I know how to use the DATE_Add formula but I am struggling with how to use the DATE Add formula to this formula field so it is also seen as a date so I can use it as a date field in a calendar. Any help would be appreciated.

Hey everyone, Is it possible to turn automations on and off from a script? I’m trying to turn them all off automatically during weekends, so messages don’t show up until monday. My caveman way would be something like const d = new Date(); let day = d.getDay(); if (day !== 0 && day !== 6) { //Turn all automations off } Would that make any sense? Or would it be better if I leave my automations on forever and try to script them in order to only activate on weekdays? Thanks in advance

Hi community, I need your help. I try to create multiple records with automation. If the new record created has the product A and “3month”, you have to create 3 records : 1st record : Add the product 1, product 2 and product 3 2rd record : add the product 4, 5 and 6 … To match the product i have to add when i create record, i create a data base with : Product A : Month 1 / Product 1, 2 and 3 Product A : Month 2 / Product 4,5,6 … Can you help me please ? Thank’s a lot, Matthieu

I’m setting up an Integromat integration to watch for Google Form responses and create new Airtable records accordingly. I’ve got pretty much everything working with the exception of one field… In my Google form it’s a multi-checkbox answer for the instruments people play, which (I believe) returns a comma-separated text string - or possibly it’s already treated as an array, I’m not sure. The values from that need to go into a Multi Select field in Airtable. The values in both the Google Form and the Airtable field are identical. From what I’ve found, I think this is going to involve some kind of array parsing, but I just cannot figure out what I should do in Integromat - their own documentation on this is not at all clear, so I was hoping someone here would be able to help me out.

Hello everyone, I am quite new to the Airtable world and for this I ask you for help. I have 1 base with 1 Employees table (with all the personal data) and 1 table with the relative data refresher courses and related expiration dates, type of certification, etc. (each employee can participate in many courses) What is the correct setting of the 2 tables like the definition of the primary fields? Thanks 1000

Hey all, I’ve been working on a Powershell script that creates many text files of various directories scattered on a network. Each text file contains lists of the file content of a network directory, name and extension. I figured I may as well use Airtable to audit each text file - which it does well. But the catch is, I’m not sure how I can actually parse a text file that I’ve uploaded into the Airtable attachments field into a Long Text field. Can this be done via an Automation? It was great when I discovered that I could bulk upload Text.txt files into separate records via the Gallery View Yellow button, simply select a bunch of files and drag it to the button - Excellent - that solved my first hurdle!!! But… now… I’m slightly concerned that as easy as those text files were to upload, I’ve no actual method to copy their content into a Long Text field and then do my usual Airtable formula thing to pull the text data apart. Appreciate any guidance on this! Perhaps I’ve gone about this

I have a series of views which capture items at various stages in a process based on filters of the dates and values, but I am hoping to get a daily snapshot of the queue sizes which can be exported into a excel report to show the progress and change of any bottlenecks. Is there a way to capture the number of items in a view, and if so for a given period in time? I was originally thinking of using an automation trigger based on a value that calculates which view it should be in, but time triggers do not seem to look at anything that isn’t time related.

Hello. I have a table that it is filled using a forms. there are two fields coming from two other tables that are selected by the customer. I need a formula column where it analyzes the two filled fields and returns the result (remuneration) based on a third table (remuneration_table). below I am attaching a photo to illustrate. basically I need the formula to return the candidate’s remuneration based on the sector and position he will be hired. Could someone help me?

I have a date formula to work out the number of days between 2 dates, if either or both of the dates are blank, it returns NaN, how can I amend the formula to only perform the calculation if both fields are populated? (Long overdue a lay-in and my brain is not functioning by itself, need help… :slightly_smiling_face: ) DATETIME_DIFF({Finished},{Started},“days”)

Hello great community. wonder if there is an option where we can get a custom email ID for a record for example (recordxyz11234@airtable.com) and when we communicate with this email id, all history will be logged in the record history as chat or notes This exact feature is in clickup, any recommendations how to do that native or via automation tool? thank you!

I’m working on a table where I have different currencies (in separate columns) and need to convert them all to one currency. I have a column marking the currency used and so the conditional if statement uses this to have a different calculation for each statement. However, for some reason, the formula doesn’t work but it does not return an error, it simply returns a blank Cell, so I have no idea what I’m doing wrong. Please HELP. IF({Currency} = “MXN”, {Amount in MXN}/{FX}, IF({Currency} = “EUR”, {Amount in EUR}*{FX}, IF({Currency} = “USD”,{Amount in USD}))) I know about the Currency converter app, but due to the Terms and conditions/privacy settings, I can’t use it.

Hello all. I’m trying to append the value of a specific field to the end of a URL that’s opened by clicking on a button field. For example, I have a field called ‘Deal ID’ and it has different values for each record. Example - Deal ID = 123456 URL = www.google.com/ What is the URL formula for if I wanted to append this ‘Deal ID’ on to the same URL for each record. I tried “www.google.com/{Deal ID}” but it didn’t work. Thanks Dan

Its probably a simple formula…but here goes… I have a record in airtable that looks like this: The A, B, C represent the responses to survey What I want to do is COUNT the number of each letter - so for example A = 3 B = 1 C = 2 E = 1 I have got as far as: IF({Col1}=‘A’,1,0) and that returns the 1 (in this example) What does the formula look like to check in Col2 - Col7 contains ‘A’ and then give me the total of 3? I hope that explains what I am trying to do clearly :grimacing: :nerd_face: Thanks in advance.

Consulta: Si tengo un campo donde ingreso la fecha de nacimiento de una persona, cómo debo formular otro campo para que me devuelva la edad de esa persona y que se actualice automáticamente cada vez que consulte la tabla. Gracias a todos!

This is killing me. It’s literally the last speedbump in my first Airtable script: I have this command: await email.updateRecordAsync(dateArray[i][0],{‘ActualFieldName’ : linkID}); It works! But THIS… await email.updateRecordAsync(dateArray[i][0],{fieldVar : linkID}); DOESN’T WORK. Even with the single-quotes gone, the system is still parsing my defined and assigned fieldVar as the string “fieldVar”. It’s maddening. Any ideas?

Hi community, I need your help. There is something i don’t understand with the formula bellow : IF( SEARCH("Jungle", {Order Line Items}), "Jungle", IF( SEARCH("Baby Plantes", {Order Line Items}), "Baby plante", IF( SEARCH("Pets Friendly", {Order Line Items}), "Pet's Friendly" ) ) ) I want to write a 4th condition but it never work. What is the importance of the space between the condition and the “)” ? How can i built easly this type of formula ? Thank’s a lot, Matthieu

Hi community, I need your help. I have a concatened formula who find 2 result on 2 colums + text I just want to add this condition : if you have 1 or 2 result missing, display a bank field. This is the formula : CONCATENATE("Diamètre : “,{Diamètre},” cm / ",“Hauteur : “,Hauteur,” cm”) The 2 column : “Diamètre” and “Hauteur” Thank’s for your help Matthieu

Hello! I’d like to have a set of single select options that indicate a follow-up timeframe. Example: 2 weeks, 1 month, 2 months… I’d then like to have an automation generate what that date would be, where the automation would take the record created date + that amount of time (2 wks, 1 month, etc.) The date generated by the automation would drive a view that looks for any follow-up dates within a week’s time span. I know how to create the view, I’m just hoping that it’s possible to create the automation to update the follow date field based on the option chosen within the single select field. Is this at all possible? Thanks in advance!

Thanks in advance, attached DB schema and issue.

Hello, We are trying to use an API key generated by myself (the owner) and it works fine to read data, but not when we try to write data (It says ‘You are not authorized to perform this operation’). The same code used to work previously with different API keys. Any help would be much appreciated. Thank you. Catherine

Let’s say I have a table with few rows - each one has a uniq ID Can a button cell have a script that will identify the ID in which he was called? for example - this is my table: id. Button 1 Click 2 Click when I click on the button on the first row - I can see what is also the id of this row.