Solved

I’m try to create a new field (Event End Date) based on the frequency of the Event (Event Day) and when the Event Day Started (Event Start Date). I started using the formula below but it doesn’t work. In addition, I need to code for Event Days where it’s a single day (i.e., “Thursdays”, “Fridays”, etc.) in which case the Event End Date = Event Start Date. IF( FIND ( "Tue - Fri", {Event Day}), DATEADD({Event Start Date},4, ‘days’)), IF( FIND ( "Tue-Fri", {Event Day}), DATEADD({Event Start Date},4, ‘days’)), IF( FIND ( "Wed - Sat", {Event Day}), DATEADD({Event Start Date},4, ‘days’)), IF( FIND "Tue - Thur”, {Event Day}), DATEADD({Event Start Date},3 , ‘days’)), IF( FIND "Tue - Thu”, {Event Day}), DATEADD({Event Start Date},3 , ‘days’)), IF( FIND "Wed-Fr”, {Event Day}), DATEADD({Event Start Date},3 , ‘days’), IF( {Event Day} = "Thur - Fri", DATEADD({Event Start Date},2, ‘days’)),

I am sending URL’s from Webflow which does not have URL validation easily integrated. I want to check and add the https:// to the beginning of the URL if it is not present when the field is created or updated. I have been looking through to forums but can’t seem to find an exact match. Would love some help with this please.

I’m finding unexpected behavior when sorting on a single select data lookup field. In the source table the HT Location is a single lookup field. I have the field values ordered in the “customize field type” control (note Dairy case in in blue before Bakery in green.): In the source table the sort behaves as expected (note Dairy case before Bakery.) The unexpected behavior is in the list table that references the source table. There’s a linked table field, and a lookup on the “HT Locations” field, which is then sorted. Here the order is different, with Bakery coming before Dairy case. I tried making a duplicate of the list table; it duplicated the odd sort behavior. I made a new table, added the same link and lookup fields, and it looked like this table sorts the look up field alphabetically – except for paper supplies – not the order of the look up fields Argh. Ideas?

Hi, I need to determine which of my projects were active in the previous month, and also active in the past 12 months. For the previous month, if we are now in June, I want to see which records were active in May (so I’m not looking for specific dates). For each record I’m looking at, I have a project start and project end which I can use to see when a project was active. So somehow I need to see if the previous month is within those project start and end dates. And ditto for the previous 12 months. I tried to find the answer here in the community and spent a lot of time looking at Airtable date functions, but I can’t seem to figure it out. Thanks in advance!

My use-case is that I want to send a slack message when a record is created. The reason I am not using the built-in Slack Message automation is that I want to customize the Slack Message using Attachments and Blocks features. I am wondering what is the best practice to get your SLACK_TOKEN from the Script itself. Is there a built-in variable that holds it? Should I use input variable or should I just assign the token to a variable? how safe it is? Thanks in advance!

I know locking the column will prevent users from editing/deleting data from a row - but will this also prevent someone from deleting the entire column?

I have a custom solution that automates adding a linked record and auto-filling some fields, and the app is wired to a button. Every time the button is pressed, the sidebar opens to the app. I imagine this is totally expected behavior, and desirable for most custom app implementations, but is there any way to get the app to run “in the background” without opening the sidebar? I’ve noticed, for instance, that if someone clicks the button from the expanded record view, rather than directly from the grid, the sidebar goes full screen and my user testing shows people are getting confused by this takeover and having trouble finding their way back to their original context. Can we just prevent the sidebar from opening somehow?

I am trying to creat a condition when the context of the table approved only than it can be posted on Softr website? Please help can not find any info on web :pray:t3:

Hi. I’ve been racking my brain for hours with something that was supposed to be simple. I have a tab called “customers” with my customers’ name and phone number. on this tab there are two columns that are the registration and name of the last barber who attended them. The calls are registered in the “Schedules” tab I would like that with each new appointment, the registration and name of the last barber who made the service to be changed. The common key between the two tables is the customer’s phone number. Can someone help me ?

Help please! I created a ‘Create Record’ automation with the following trigger: When a record matches conditions in table 1, it creates a record in table 4. (Works Fine) The problem is with the record it CREATES in table 4. It’s doing exactly what I want when it runs the test, but when I create a NEW record in table 1 that matches the conditions (triggering the action of creating the record in table 4), it’s filling in the field in table 4 with ONLY the first letter of the word(s) it’s supposed to be inserting. I cannot figure out what I’m doing wrong :weary: Any help is so appreciated!!!

I think I already know the answer (tables aren’t the same as spreadsheets so you can’t copy cells, only records), but wanted to post in the off chance someone can suggest a possible work around. Trying to copy a formulated date from one table to another so I can produce a gantt for each record in my base. Table 1 has records of each project with various fields containing start/stop/checkpoint dates Table 2 I was using as the base for my Gantt with only two fields (start date, end date) Currently I have to copy and paste but am hoping maybe there’s a scripting with a map loop solution out there? Example: Table 1 Record 1: Project 1 (Name) Field 1 (start project - date) Field 2 (check-in with employee - formula off of start project date) Field 3 (90-day assessment - formula off of start project date) Field 4 (end project - formula off of start project date) Record 2: Project 2 Name Field 1 (start project - date) Field 2 (check-in with employee - formula off of start project date

Hi Community, I have a table A, which has 3 fields. Field 1 is Name, Field 2 is Role, Field 3 is Skill-Level. Simulated data for Table A: John, Singer, High Michiel, Pianist, Medium Zule, Guitarist, High Table B has 3 fields. Field 1 is Name, Field 2 is Phone Number, Field 3 is Email Address. Simulated data: John, 12345, john@music.com Zule, 67891, zule@music.com Question: is there a way to ensure that when I add any new record in table A, only new records in table A with Skill-Level = High are automatically added to table B? Having combed through Airtable’s functions, I am sensing that this is not possible without using Zapier or Integromat or some JS code but I hope to avoid these options. Please advise, thank you!

I’m trying to duplicate a row via a mobile device (iOS). I noticed there wasn’t a way to do it explicitly through the interface, however, I am looking at implementing a workaround via a button which calls a script. This being said, is there a way to duplicate the current record verbatim via a script?

Hey all, new airtable user. I am a composer and I’m trying to put together a base that tracks a songs and co-writer percentages. One song might have one or several writers. If it’s more than one writer, I would like to track their percentage. For example, song 1 might have writer A, B, C each with a 33% writer’s share. The pertinent tables I have so far are: Song Table - contains song details and metadata Writer Table - contains information on composer Do I use a junction table for this? I could use a little hand holding if anyone has an answer!

I have text file following formate Name URL is there anyway i can import that text file info in two column

Hi, I would like to use the column number in a view in a formula. Example : If a record is listed as 5th is a view, I would like to use the number 5 in a formula. Is there an internal field giving me this number ? PS If this exists, is there a list of internal fields that can be used ? like RECORD_ID, …

I have three tables, Properties, Contacts, and Companies. Each table has a Last Unsuccessful and Last Successful contact field. Sometimes I have contact information on one or multiple of these tables (i.e. if a company owns multiple properties then I’ll create the linked relationship). I need a way to find the maximum date of when I last spoke to someone, whether I’m looking at either of the tables. On the table below I have two lookup fields and a natural date field for both successful and unsuccessful contacts. I referred to the thread below but not sure why I am getting an error. Formula to choose Earliest Date from list of 6 dates Dates and timezones Hi everyone! I have a table with a list of 6 different release dates - I’m trying to create a field that looks at all of those dates and picks the earliest/first one as “Initial Launch.” IS_BEFORE only seems to work with 2 dates and the factorial of 6 dates is 720 possibilities of combinations so I don’t thi

I would like to create a formulas to add the specific school year if the date in the column “DATE” is between DATE1 and DATE2 For example: IF date is 5/20/2021 THEN in the column school_year I will have 2020-21 IF date is 9/20/2020 THEN in the column school_year I will have 2020-21 IF date is 9/20/2021 THEN in the column school_year I will have 2021-22 What formulas should I use ?

Here is my script. The goal is to copy a value from a field into another field, but the field variable is dynamic. The fields do exist and will match the fieldvalue input variable. However, i don’t seem to be able to update the record by using a defined variable. Here is my script: let config = input.config() let recordId = config.recordid let name = config.fieldvalue let table = base.getTable(“Verifier / Trainer Body”) let query = await table.selectRecordsAsync() let record = query.getRecord(recordId) let field = table.getField(name) let fieldval = field.id console.log(fieldval) let value1 = record.getCellValue(“VB Total Score”) let copy = await table.updateRecordAsync(record,{fieldval:value1}) Thoughts?

Hi everyone - I’m still very new to Airtable and ran into a formula error that I’m trying to solve. Ideally, we would like to group tasks by the week they are due. I was able to find the formula to output the week number but can’t seem to find one that works that will produce the following output: “Week of 06/21”. I did find the following two formulas from a previous post: Display the "week of" for a given date starting with Monday CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Date},-DATETIME_FORMAT({Date},‘e’),‘days’),‘M/D’)) DATETIME_FORMAT({Date},‘e’)+1,‘days’),‘M/D’)) However, when I go to add the formula to my calculated field it returns an error. Could it be because my {Due Date} field is calculated as well? This is the formula that I am using: CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Due Date},-DATETIME_FORMAT({Due Date},‘e’)+1,‘days’),‘M/D’)) The specific error is as follows: Sorry, there was a problem saving this field. Invalid formula. Please check your f

I feel this is super simple and I’m just not seeing something. If someone could put me out of my misery, it would be much appreciated. I want to send slack notifications when someone fills out a form. One of the fields is long text and asks for detailed description. I wanted to only show a preview of that field in the message. I see the “trim” option there but I don’t know how to actually use it! It’s not doing what I assume it should do. I am selecting + > the field (Description) > Continue > trim (insert) and it doesn’t do anything. When I do the exact same with any of the other properties (length, upper case, lower case, etc) it does react the way I would expect. Does anyone know how to do this? :thinking: See it not working here:

Hi Airtable Community! In my Airtable base, I’ve got two main tables: one for stories written by kids, and another for notes that volunteers write to the authors. These tables are related through a one-to-many linked record setup: there can be multiple notes for a story, but not multiple stories for a note. I’m trying to make two rollup fields: one that displays the text of the first two notes a story receives and one that displays the text of every note after the first two. I’d like to email notes back to authors after they have two notes and then again when they’ve accumulated several more, and would use each rollup field as part of the automation for the email body. The additional wrinkle is that the rollup should only count notes that haven’t been flagged (and therefore shouldn’t be returned), and there are handwritten notes too. My thought was to add an Autonumber field in the notes table–each note will have to have a higher number than the last. Then, the aggregation formula of t

Hi Community, I have a cruddy report that cannot give me the data i need which forces me to calculate the number of days a person has been helping our organization and I was hoping there might be a formula that can help automate the calculation a bit, but I cannot wrap my head around it (terrible with IF formulas). The report is run once per month and will produce 4 different combinations of dates for the in and out field. Combination 1, OUT date is prior to the start of the month, and IN date is after the last date of the reporting month OR blank . This calculation would then be the same as the number of days in the month. Example for May (OUT is 4/20/21 and IN is 6/5/21 or blank, would = 31 days) Combination 2, OUT date is prior to the start of the month, and IN date is within the month of reporting. This calculation would be the datediff between the IN date and the last day of the previous month. Example would be (OUT 4/20/21, IN 5/14/21= 14 days) Combination 3, OUT date begin

Hello community! This is my first Airtable script. I’ve been proud so far but there’s a detail that I cannot crack. The situation is: I’m generating a dynamic chart via quickcharts.io using Airtable fields and I want to create a .png file from it to send by email. So I created a formula field that generates the appropriate URL for the chart, this works perfectly. Then, I created a script that runs upon that URL being updated, here’s the kink. The script is based on a similar Airtable script which takes a URL and creates a file in another column on the same table. The issue is that the ´filename´ is not being updated. It creates the file perfectly, but the filename is taken as a part of the URL which is unreadable and doesn’t contain the file extension. Here’s my take: let table = base.getTable("Table 5"); let attachmentField = table.getField("Attachments") let inVar = input.config(); let url = inVar.Attachment_URL; let updates = []; let attachmentUrl = [{url: url, filename: 'Chart.pn

Hey, I’m facing a specific issue in Airtable Automations: Background: I’ve created a automation to do the following: Trigger: Receipt of Webhook Action: Update a Record in Airtable. The trigger is working fine, however the action is continuously failing with the following error: “Received invalid inputs.”. I’ve taken the usual steps of: Re-test the Trigger and then re-try the Action Re-configure the fields to be updated in the Action Check the field types that need to be updated in the action. Does anyone have experience with what could be the issue here? (Screenshot attached)