Solved

Hello, my goal is create an automation that update all record meet record update.see atached filewhen I change the value of record indicated from 99 to 1, I want all others records of same finish and same date chage to 1 too.ThanksSylvain

Hello all!  You guys have been so helpful in the past, I've got a new question to share tonight!  I am working on a base to track finances.  We categorize all our expenses (and income) and then budget for those categories.  I need to assign a category to each transaction I import into the base.  Occassionally, we will have a single transaction that purchased items from multiple categories, for instance we bought clothes and groceries at Walmart.  Clothes and groceries are separate categories.How would you guys structure your base to make recording these transactions as smooth as possible?Thanks!

Hi,Hope you are all doing well.I need a little help. I have a simple single select column which have different tags and can be updated time to time. I want to calculate the edit history of each tag in other column and wanted to know how many days requiring each tag i.e when it was changed from in progress to shipped. I want to calculate the time and no. of days.I'd really thankful if anyone provide me best solution 🙂Thanky you 

Hello everyoneI have a problem with the history of deleted attachments.I have 2 fields "Attachments" (images): Field A and Field BI have a Make scenario that generates the attachment of field B if the attachment of field A is filled in Airtable. The Field B attachment generated by Make is the same image as the Field A attachment to which the Make scenario adds a watermark and formats the name.>> No problemI have an Airtable automation that if the Field A attachment is deleted, then airtable deletes the Field B attachment.>> No problem eitherIf I delete the existing attachment in field A and put a new attachment in field A (a new image), then first Airtable deletes the attachment in field B (thanks to the Airtable automation) but then in field B instead of having the new image corresponding to the new attachment in field A (sent by Make), Airtable puts the old image in field B.In Make, I can see perfectly that the image sent to Airtable in Field B is the right one. No proble

Hey, i'm looking at a way to populate a kanban record with data that has been populated in a form.The end goal is for users to enter details into a form and that will automatically pull into a kanban board for projects to be started.Any help would be appreciated! Thanks!

Hello, I am having to add hours ("duration") to a field and outputting to a new field where a formula would be developed, however, I am not sure how to format the formula for the duration; here is my formula: IF(FIND("Algebra I", {Requires Additional Hours?}), {30:00},SUM({Total Hours Required}, {30:00})) "{30:00}" in both instances comes out red, meaning it is wrong, however, what I need to do is add 30 hours to the "{Total Hours Required}" field. Basically, if Algebra 1 is found in this drop-down menu "{Requires Additional Hours?}", it takes the value within "Total Hours Required" and is supposed to ad 30 hours and output it to this field. If Algebra 1 is not found, it stays at 30 hours, hinting at the first "{30:00}" in the IF() formula. Thanks in advance!

This is basically a leave tracker. Table 1: Employee DetailsThis table contains the start date of the employee and a column that computes the available leave credits they have accumulated.Column LEAVES is linked to Table 2 and should look up the duration of the leave request applied for while another field computes the remaining leave creditsTable 2: Leave RequestsThis table computes the duration of the leave applied for using the FROM and TO DATE. I've made the primary field an autonumber for a unique identifier.I've created an automation that does the following:Trigger: When a record enters the view (meaning the a form has been submitted)Find Records: From Table 1 that matches the first and last name of the requestorUpdate Record: This is where I'm stuck. I want the Linked Field LEAVES  in Table 1 to be updated with the Leave Application # so that it looks up and sums up the duration and automatically computes the number of leave credits left.I keep getting the below error

Hello! I am trying to link records with the same ID and I can’t figure out how to do it in buik - only one by one which is impractical for my purposes. Essentially, I have a table (“Forms”) that contains student usernames and the forms they submitted, and I’m using the username as the record ID, so multiple, identical record IDs exist for all the different forms a particular student submitted (i.e. Username1 - Form A, and Username 1 - Form B are listed in different rows). The ideal result I am picturing is that, in my main table, I could use a ‘link to another record’ field that links to the Forms table, I would paste the usernames in this field, and then I’d have a lookup field which would display all the forms that correspond to that username (i.e. for Username1’s linked record, the lookup field would display “Form A, Form B”). However, when I set this up, it’s only displaying the first form that exists in the Forms table, and it only works the way I want it to if I one by one add re

Hi there, I’m a French PharmD and I use Airtable to manage all patients’ appointments. It’s very useful for all my team except 1 laborious step : create appointments. I manage all appointments in a dedicated table (every X days I create X records for next days, so anyone can select a slot). So far I create appointments (1 appointment = 1 record) one by one. Ideally, I would like to fill a form and create multiple records with an automated script. For exemple, if I fill a form with : from : 22/10/2022 09:00 to : 22/10/2022 11:45 every : 00:15 (fifteen minutes) ==> It run a script and create records : 22/10/2022 09:00 22/10/2022 09:15 22/10/2022 09:30 … 22/10/2022 11:45 As a Pharmacist I don’t have skills to create a reliable JavaScript code in automation. Any help would be grateful ! :slightly_smiling_face: Thank you, Hadrien

I have a formula field that creates an email address for me, but when there's an extra space after someone's last name it returns an extra "." and breaks my automation connection to create the email. Ex. sandy.castellano.  --- it should be sandy.castellano I thought adding TRIM to the last name would fix the issue but I keep getting an error code. Can anyone help with removing extra spaces in the last name? Current Code: SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(  (REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(LOWER(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(first_name & " " & last_name, ",", " "), "'", ""), "  ", "&nbs

Hello,sorry, if I ask a question that might have been asked before. I am creating a simple private bookkeeping table and would like to build a SWITCH function that stamps the DATE when a value changes ("paid" / "open").Furthermore, I have tried the TODAY() function, but it updates every day. The LAST_MODIFIED_TIME() works, but if I change the value of the field, it will automatically update again. I would like to build a function that stamps the date only once, after the value "paid" / "open" changed for the first time.This is the formula I used so far:SWITCH(Status, "bezahlt", LAST_MODIFIED_TIME()) Thank you very much!

Hallo can you change the Icons in the rating field or add some self created ones?I would like to add some flower icons instead of stars or thumbs.ThanksDaniel

I want to make an automation that runs a script, and in that script I'd like to call an ajax function (either with jQuery somehow or with XMLHttpRequest() etc.) to grab some external data from a Google calendar. Is this possible? I've searched around and can't seem to find any information on it and the script editor says the ajax functions aren't defined, so I'm not sure if/how I can include jQuery if that can help.Thanks

Hello,I am setting up a record to duplicate a record (but only certain fields) in a base by taking input variables and then creating a new record and inputting these into the new record as suchlet recordIdNew = await table.createRecordAsync({    "DateTest": StartDate,      "SingleLineText": SingleLineText,    "PhoneNumberTest": PhoneNumberTest,    "CheckBoxTest": CheckBoxTest,    "LongTextTest": LongTextTest,    "EmailTest": EmailTest,    "SingleSelectTest": {name: SingleSelectTest},}); I have managed to achieve this with all the required data formats but I’m really struggling with Multiple Select.  I am able to pull the data from the original records field and it shows in the console as followsCONSOLE.LOG▶(2) ["AA", "BB"] The issue is, I don’t know how to add it to the new record (like I am able to do with all of the other data types) I have

I am trying to make a formula that takes the date/time from a previous column, and if the time is in the p.m, display the current date, however, if the time is in the a.m, to display the previous day's date. Attached it my current formula, which works for the p.m. times, but shows a mixture of 'Invalid Date' and an oddly specific time (see photos)Any ideas what I'm doing wrong?  

Hi everyone,I need to show people on a map but for privacy concerns I would like to change the exact position randomly. I found a ruby script that is doing exactly what I need : do you think it could be possible to turn it into an airtable script or with formulas ?I don't have any experience with scripts or coding yet so I don't know if it's something that Airtable can do.Here's the ruby script :lat = (point[0] * Math::PI / 180).to_d lon = (point[1] * Math::PI / 180).to_d max_distance = 200.to_d min_distance = 100.to_d earth_radius = 6_371_000.to_d distance = Math.sqrt(rand * (max_distance ** 2 - min_distance ** 2) + min_distance ** 2) delta_lat = Math.cos(rand * Math::PI) * distance / earth_radius sign = rand(2) * 2 - 1 delta_lon = sign * Math.acos( ((Math.cos(distance/earth_radius) - Math.cos(delta_lat)) / (Math.cos(lat) * Math.cos(delta_lat + lat))) + 1) [(lat + delta_lat) * 180 / Math::PI, (lon + delta_lon) * 180 / Math::PI]Do you have an idea how to transcript this ?Thank

I encounter an error whenever I add a new column or row. We have a free account. My base currently has 13 columns and 6 rows. Please help.

I’m using a button to trigger a Zapier webhook. It’s annoying that every time the button is clicked, a browser window is opened. As I can select to run a script with the push of a button, is there any way to run a script in the background that triggers the webhook? Thanks!

Due to the change in the tools being used as a community forum, I cannot edit my posts anymore.Is there a solution for this?

Either I've stumbled upon a great bug or I'm a complete idiot. If history is anything to go by let's assume the latter.In a greater context I'm using a formula to check if TODAY() is in the range of some dates.Sometimes the date is from an automatic Created Time field, other times it's from a regular date field. When I check the Created Time (doesn't matter if the field is with out without a timestamp) on a record created moment ago against TODAY() I get a false.I used it in a long formula, but boiled down to it's minimum it just doesn't work. IF(TODAY()={Created Time},"1","0") The above returns 0 on a record created 15 minutes ago.If I ask it to check a date field with today's date inserted, then it returns 1.What's going on and how can I work around this?

Hello!I am trying to set up an automation where when a record is updated, the email column in the same row as that record receives an email with the information in the updated record.For example, I have 3 columns: Name, Email and Unique URL. I want to be able to put in a URL for that Name and have that URL be sent in an automated email to the same email address associated with the name.I have the email column and the unique url on the left hand side but when I go to test it, it gives me an error/shows up empty with the fields, saying I do not have an email and it doesn't show the URL I have put in the grid. Screenshots attached. What am I doing wrong here? Any help would be greatly appreciated!

I'm trying/hoping I can do this. I have an extension added to a table (SyncWith) but that needs to be manually triggered to run/update the sync. Ideally I'd like to create an automation to run once a day and trigger that extension, maybe with a custom script or something that can interact with it.Is such a thing possible with scripting? I'm still new to Airtable.

I have a Base with below:Table A = CollectionsTable B = ProjectsTable C = Dept 1 Sub TasksTable D = Dept 2 Sub TasksTable E = Dept 3 Sub TasksTable F = Dept 4 Sub TasksWe create Projects and Collections, with Linked Records.When a Project is added, it then links to all the different table sub tasks. These are very different based on departmental needs, hence the different tables.I need to have a direct link between each sub task and their respective collections so that I can run High level meetings accessing each departments status/info in an Interface with ability to change data. This means an interface run from Table A with grid views inserted for each table A, B, C, D, E, FRight now it works if I use a Collection lookup field on each subtask table to monitor for changes, and then an automation that then updates a sub task to a new linked record field connecting to the collection any time there is changes. However as my base grows, and automations grow, I am concerned that there

Hi all, I'm trying to set up a HTML button with a link that includes a variable "Name" (name of the product) like this: I tried adding " " to make everything except &Name& green but it didn't work. Is there a way to put HTML in the formula and use variables? Surely I'm missing something. Thanks!  

I can't seem to figure out how to loop a concate formula. I have 2 columns: Show Name and Episode Number. Show is single select and Episode is multi. My desired output is a string that loops the show name before the episode number; instead I only get Show Name, then a list of episodes with a comma deliminator.The desired outputs are the names of linked records. Example base below. Any help truly appreciated.https://airtable.com/shr07v7lc15RGEaj5 Show (single)Episode (Multi)FormulaDesired OutputThe Boys301, 302, 303The Boys 301, 302, 303The Boys 301, The Boys 302, The Boys 303The West Wing401, 502, 302The West Wing 401, 502, 302The West Wing 401, The West Wing 502, The West Wing 302Archer201, 303, 105Archer 201, 303, 105Archer 201, Archer 303, Archer 105