Solved

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

I have multiple tables - one is the master table, the other tables are child tables. Records from the master table should be automatically linked to the child tables when they are created, based on a field that contains a matching value for the child table.For example, I have tables:Master, Project 1, Project 2, Project 3.Master project contains a list of companies and field that lists their projects.Project 1's table is supposed to contain *only* companies that are associated with Project 1Within the master table there is a field labeled "Projects", which contains zero, one or more of "Project 1", "Project 2", "Project 3".If the field contains "Project 1", it should be linked to the table named "Project 1"If the field contains "Project 1" and "Project 2", it should be linked to both "Project 1" and "Project 2" tables.Hoping to do this within Airtable Scripting, so that it is dynamic and able to update based on the table names.My current code looks like this (using a button to create a

Hello All.In table A I have all of my outbound communications listed. In this table there is a field called "Month Sent", this field is used to link table A & table B. Table B contains the aggregations of all the communications sent per month (Month sent, Total sends, Total opens, percentage opens, etc.). I want to show the metrics for the communications for each format type per month (i.e. email, SMS, etc.). The ideal way of doing this would be to somehow have a single select field for the format in table B which whenever changed automatically causes that record to calculate the number of communications for that format only and update the record accordingly. I know there is an option in the roll-up to add a condition, but that would mean creating a different view and roll-up condition for each format. In Google sheets, I simply had a table, combo box and if statement that read something along the lines of IF the combo box is equal to the format then add to the count.&nbs

Hello Airtable Community, I'm creating a form where I need a specific number of volunteers for each area of an event I'm planning, for example, I need 5 volunteers on Saturday from 9am-12pm; 5 volunteers on Saturday from 12pm-3pm, etc. What can I do in creating the form to where as the volunteers sign up for various slots, the available number of slots decreases from 5 available to 4 to 3 to 2 to 1 to 0?I don't want six volunteers to sign up, I don't want the sixth person to see it would be an option.  Any suggestions would be most appreciated!Best, Dan

Hi All,I have text field called Name, which contains data in the following format: XXX - YYY - ###, where XXX and YYY are random texts, ### is a 1/2/3 digit number and they are always separated by " - ".In another field I'm using the following formula: TRIM(MID(Name, FIND("-",Name,FIND("-",Name)+1)+1,3)).My goal is to find the number at the end of the Name field and use it as a number in other calculations, but although the result looks good, it is not recognized as a number.Any suggestions?Thank you in advance!