Solved

Hi,I'm trying to work out how to display the difference between two dates as weeks, then days.As an example, one of our crew will be away for 9 weeks and 3 days. It is difficult for them to work out how long that is if it's only displayed in days (66) and in weeks it's not accurate enough.If I useDATETIME_DIFF({End Date},{Start Date},'w')Then anything less than one week displays as 0.0, and the extra days are not accounted for.Ideally I'd like to be able to display "9w, 3d".Any help working this out would be greatly appreciated.

Hi there, I copied this script from the scripting app. I tried to search in topics already but I am going around in circles and still getting errors. I want to copy two fields additional fields from my task template to my tasks. The fields are called Status and Stage. The fields are same names in both tables. They are single select. Can someone help. I added these following lines based on info I could find in topics but I am still receiving “Error: x: Can’t create records: invalid cell value for field ‘Status’. Could not find a choice with that ID or name at main on line 126”

Hello everyone, I would like to have the sum of each column of Table 1 in a row of Table 2. My problem is that on table 2 I did a rollup and a link, so I have to add the clients one by one in the Clients column. Is there a solution so that the Customer column fills automatically when I add a customer in table 1? The ultimate goal of my question is simply to be able to retrieve the sum of the columns Achats - Sous traitants - Salaires Flo - Entrée of Table 1 to be able to make a percentage in an interface. I hope I've been clear enough for you to help me 🙂Thanks to all of you !   

Hi community,I have this problem : In a grid view, a table is sorted manually. After each opening, the order is kept.A script fetches the records of the table, and delivers them in alphabetical order, not in the manual order.I don't add any sort param - like 'sorts: [ {field: "someField"} ]' - I cannot figure out a 'handy' workaround... The option to read on a sorted priority field quickly becomes tedious, time consuming, and requiers a lot of energy...Thanks in advance if you can let me know how i can workaround this behavior.

I'm trying to randomly assign one of four Group IDs (AlphaGroup, BetaGroup, GammaGroup, DeltaGroup) to all existing/new records in my database whether they're imported in bulk or added manually. I've been using this formula—however since some of my records will be imported in bulk, their created time remains the same and gives them all the same Group ID). I also have First Name, Last Name, Email, and other fields that could potentially be useful here. Any idea how to address this? Thanks!  IF( SECOND( CREATED_TIME() ) < 15, "AlphaGroup", IF( SECOND( CREATED_TIME() ) < 30, "BetaGroup", IF( SECOND( CREATED_TIME() ) < 45, "GammaGroup", "DeltaGroup" ))) 

Hello everybody! I am trying to create some buttons in a table with a lot of different information. It looks like this:   The issue is: right now every button leads to the same URL. I want each (or at least) some of the buttons to direct to other URLs within the same table. Isn't that possible?

Hello Guys, Thanks for reading this and taking the time to help me out :slightly_smiling_face: I’am trying to customize my project management table and more precisely to implement a budget line. Thing is that the budget is not a fix number but a range. When i try to use the currency or the number field i’am stuck with only one possible number. Could you help me to fix this ? Cheers

and failing, to be honest. Please take note that I have no idea what I’m doing and this script is pieced together from snippets and posts I found on the forum. This is what i have until now. I’ve tried multiple variations but I haven’t been able to write to a new attachment field correctly. //script settings let settings = input.config({ title: 'Create individual records from multiple attachments in a single attachment field', description: 'Creates 1 individual record in another table for each attachment in a multiple attachment field in the source table, and links the new records back to the source record.', items: [ // Source table select input.config.table('tableSource', { label: 'Table with existing attachments' }), // Source table: Attachment field input.config.field('attachField', { parentTable: 'tableSource', label: 'Attachment field with multiple attachments to split', }), //

Hi, I'm trying to do an inner join between two columns and print in a new column (only the attachments that are in common in both columns). The problem is that the columns have attachment URLs, I tried to use the Script that @Andrey_Kovalev  suggested to me for just text, but it just prints me the first element or anything.  Those are the two columns that I'm trying to merge (Total Primary and Total 2). Total primary is: and Total 2 is: This is the result that I obtained: For example Sara should have Test 3 and Test 1, but She has only Test 1.This is the code that I tried to use with automation: //collect input let Rec = input.config() //load records let table = base.getTable("Users") let record = await table.selectRecordAsync(Rec.RecID) //declare inner join array let innerJoin2 = [] //function for filtering unique array entries function onlyUnique(value, index, self) { return self.indexOf(value) === index; } //check existence of the r

Hi, I am trying to update the existing records in my Table through Google Sheet and everytime I try to run the automation. I am getting an error “Received invalid inputs.” Record ID provided for Update record automation matches the ID in the Google Sheet along, I am just trying to update one record for now. Please help. Existing Table Existing G-Sheet Error while testing the automation

Every day I update all of my clients on the items I need from them so I can keep their projects on track. Having separate records for every single subtask is overkill so a single record is the parent record and I use the rich text check boxes “”/“” to keep track of the subtasks. For example: As the clients completes subtasks, I manually draft up an email or text with what is still needed. So I’m looking for a way to filter out subtask #2 and only leave me with: Subtask 1 Subtask 3 Any ideas?

Hi dear friends.I would appreciate your help regarding time differences.The clock should be +2 as you can see in the picture but for some reason when I do the formula it takes me back 2 hours and I couldn't figure out how to use the timezone formula.I would appreciate your help on how to write the formula correctly so that it works.Thank you! 

I thought I was being clever but my formula did not work. Cells are blank. Why?SWITCH(  {Decimal},  "0.75",  "3/4",  "0.50",  "1/2")

Hey friendsI have a column of customer full names.I would like to separate this column into 2 separate columns - one for first names and the other for last names.I used the following formula (screenshot attached) to separate the first and last names, but there is a problem:If someone entered only their first name without a last name, the column remains empty and I don't understand why.I would be very happy for your help in this matter!Thank you 

I am new here, so please forgive me if I ask a question that might have been asked before.I keep track of my software subscriptions with Airtable, some are monthly based and some are yearly. Therefore, I created a single selection field with two options (monthly, yearly) and a date field that shows when the subscriptions are due. Now I would like to automatically update the due date after it has passed under the condition of monthly or yearly. I had something in mind like: IF ({subscription} = "yearly", NOW(), DATEADD( *1, 'year')({subscription} = "monthly", NOW(), DATEADD( *1, 'month')I guess it's terribly wrong, since it never worked 😭 

My record has a field that's named  'Automation history' which is where i want my scripts to keep a log whenever it does some changes, i keep this to identify errors etc. But the issue is that it get's replaced, is there any way to .push that value there instead of overwrite? All the other code i want to keep as is.This is my code:  let createOpportunity = await tableOpportunities.createRecordAsync({    'Opportunity Name': orgName,    'Organization number': orgNumber,    'Company Type': orgType,    'Foretaksregistret': orgRegisterDate,    'Kommune': orgKommune,    'Postnummer': orgPostNummer,    'Automation history': "Record created at " + yyyy + '-' + mm + '-' + dd + " ,&nbsp

In the new Community app, is it not possible for authors of posts to edit their posts after they're published? Added 1 minute later: Hmm. I just now looked at the Comments Options and I found an Edit Post command. But that command isn't there for a post I published just a short while ago? What's the difference? Do I get just 120 seconds to edit it or something like that? 

For some reason I can't insert the fields from the Find Records step as a token in the email body. Am I missing something obvious or is this a bug? I tested the Find Records step and it successfully returns records and shows me the related fields

Hi All,I have a Calendar table within a base that we use to assign calendar events to Airtable users. We also share the calendar link with everyone so the calendar will populate on their iPhone calendar and such.  Because of this, we want to show what event is assigned to which user in the calendar event ID (labeled "Event" in the screenshot below).  We currently do this with a concatenate formula but it will show each users full name, which makes the Event ID very long.  Current Event formula is as follows and works fine: CONCATENATE(IF({Tentative?}=1,"(t) ",""),Project, " ",{Service Call}," ", RMA," ",Title, " ", {User (Assigned To)})In short, I can not find a way in which to swap out each users name for their initials in the form of custom text (not just taking the first and last initial from the users name since two users have the same initials "JR").  I am looking for some sort of formula to insert into my existing {User (Assigned To)} spot in the for

Hi. I,m trying to filter records using filter formula based on record_id. The field is not exists in the table, and we don't want to create formula field to have record ids explicitly. Is there a way to compose query formula to filter data by their record_Ids like this:AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({record_id}) & ","), ", ", ","))))Thanks in advance.

Can someone help me out.  I'm want Airtable to return the "Column name" after he compares 4 adjacent cells in the same row. I expected to be something like...if(@A>@B AND(@A>@C) AND(@A>@D), "A")if(@B>@A AND(@B>@C) AND(@B>@D), "B")if(@C>@A AND(@C>@B) AND(@C>@D), "C")if(@D>@A AND(@D>@B) AND(@D>@C), "A") Thanks in advance!

Hey guysI have a brain drain problem with how I should set up a dynamic date formula, I have 2 tables in a base, one for odd weeks and one for even weeks. They both just contain 5 records, one for each workday. I have separate fields where the current date is shown, current weekday, current week number and if the current week is odd or even (it shows 0 for even and 1 for even). Now to the tricky part.I want to show in a field in the even table (week 50), lets say today Wednesday the 14th of dec. I want todays date to be visible in that field, on Tuesday the 13th should be visible and on tomorrow the 15th and so on. And I also want if the dates in the odd table shows next weeks date, and then when it becomes an odd week the even table updates the dates to the week after the odd. Any of you geniuses have a solution in mind?

If I embed a view on a website and leave the "Show view controls" enabled, then a visitor adjusts a filter or sort criteria in their browser, does that impact other viewers? Or are the view controls unique to that visitor for that browser session?Essentially, I want to know if one person changing a setting impacts the base itself, or just that visitor's experience.

Hello everyone,I am very new to scripting, so hoping I can get some support here.In short, I am trying to use the "Find Records" automation action to get a list of records, and then pass that list onto the script to delete them. Below is what I have but am getting "TypeError: Invalid arguments passed to table.deleteRecordAsync(recordOrRecordId): • recordOrRecordId → recordOrRecordId should be a Record, not undefined or recordOrRecordId should be a string, not undefined"I believe this is because the list is being passed to the script as a string, not a record, but am not certain that is the issue or how to rectify. Code is below, thanks in advance!let table = base.getTable('Milestones'); let inputConfig = input.config(); let recordsToDelete = inputConfig.RecordList; console.log(recordsToDelete); for (let deleteRecord of recordsToDelete) { await table.deleteRecordAsync(deleteRecord.id); output.text(`Deleted record for ${deleteRecord.name}`) }

Hello everyone, To begin with, sorry for my writing, I'm French and I'm not used to English yet.I'm looking to change the status of a column with a simple action, like a button or a formula but I don't know how to go about it.As you can see in the photo.I am eager to see your advice to carry out this action, thank you all!