Solved

Hi, I created a form for simple data entry and am including a “Created time” field so users will not have to manually fill in the date the form was submitted. The issue is, I also have legacy data from an old system that I want to import into the same table as the form submissions so the old data and any new data can be analyzed as a whole. This old data is organized by date and those dates are important to retain. When I add any old data into the table, the Created time field auto-fills to today’s date and I am unable to change it to the correct date. Are there any solutions for maintaining the Created time field, but also maintaining the correct dates for the old data? The only option I’ve thought of is converting the Created time field to a Date field, but that would mean anyone submitting new data via the form would have to manually enter the date. Thanks in advance! Colleen

I am new to scripting & know that I dont know exactly what I am doing however I like to learn & am kind of learning on the job taking it 1 step at a time.When creating a script the following code will allow the user to choose which table & field they want to use in the script from the script settings. // Click the "gear" icon in the top right to view settings let config = input.config({ title: "Script Title", description: "Script Description", items: [ input.config.table('selectedTable', { label: 'Table to use', description: 'Pick any table in this base!' }), input.config.field('selectedField', { label: 'Field inside the above table', parentTable: 'selectedTable', }) ] }); I want to be able to select multiple fields. But I only want to be able to select:Fields that are either a singleLineText or a multilineText.Only be able to select each field once.How w

I have a series of fields I want to concatenate together. The final result needs to include a semi-colon in between each piece of data, but not all columns have data. So I was working to do an IF statement to check if the last of the columns (far right column of data I want) had data, if so, concatenate it with the other fields. The formula I came up with (but is not a valid formula and I can't figure out why) is:   IF({Revenue Rolodex}, CONCATENATE({Revenue Rolodex},”;”,{VIP Day Social},”;”,{4M Event},”;”,{Applied to DID},”;”,{DID Calculator},”;”,{VIP Day Bootcamp},”;”,{2022 Advent Calendar},”:”,{VIP Day Quiz},”;”,{FREEBIE: Roadmap},”;”), IF({VIP Day Social}, CONCATENATE({VIP Day Social},”;”,{4M Event},”;”,{Applied to DID},”;”,{DID Calculator},”;”,{VIP Day Bootcamp},”;”,{2022 Advent Calendar},”:”,{VIP Day Quiz},”;”,{FREEBIE: Roadmap},”;”), IF({4M Event}, CONCATENATE({4M Event},”;”,{Applied to DID},”;”,{DID Calculator},”;”,{VIP Day Bootcamp},”;”,{2022 Advent Calenda

I want to create a file upload interface on my custom app so that collaborators/users of the app can upload an image from their file system to the base (instead of using the airtable interface) Is this possible, and if not, can you suggest any workarounds? Thank you!

I'm a scripting newbie and need a little help...I'm attempting to create a number of placement records, linking to a booking where the number of records is inputted by the user.I've cobbled together pieces from various example scripts I've found, but I'm hitting an error. Please see details below.This is the script:      This is the error: And these are the details of the object: Currently I suspect there's a type mismatch somewhere - but any help would be greatly appreciated!   

Hi All,. I am relatively new to Airtable and am hoping for guidance regarding an issue I have encountered. I have a table of riders which I use to record day to day notes and injury information. It is reviewed daily by our Doctor who then decides depending on the injury if the rider should take a break from competing or if they can be cleared immediately to continue . When the Doctor decides that the rider can be cleared I would like to have a button that she clicks which clears the relevant fields but also automatically creates a new record in another table to retain a copy of this information for reporting purposes at the end of the year. The relevant fields are 1) a linked record from another table showing venue incident took place 2) checkbox 3) a single select 4) long text 5) attachmentthanks

Hi, anyone can help with a trick to hide a record if one is marked with a tag?Example hereI want the Data Intelligence Intern to be excluded from the form without deleting it from the record Any tips?Cheers! 

 Hello everyone,I have to create a calendar of course sessions and I have a table in which I enter in one column the date, in one column the start time and in another column the end time because different days might have different times.I use the formula DATETIME_PARSE(CONCATENATE(DATESTR(Date),' ',{Start Time})) to create a date & time that can be displayed on the calendar. However, the result of the formula returns the wrong time, increased by one hour.Am I doing something wrong or is it a bug?Thanks for any assistance!

Hello, Is there a way to configure this formula to only return a time during specified business hours (7:30-4PM)? DATEADD(WORKDAY({Last Modified},1)) Thanks :slightly_smiling_face:

Hello! Is there a way to use the "When a form is submitted" automation trigger but send different emails based on different responses to the form? We have a single select option and we are looking to send different emails based on which option was chosen. I would just choose the "when a record matches conditions" option but we sometimes change the single select option and I dont want emails sent when that happens, just when the form is submitted. Im happy to use a workaround but dont know exactly what that might look like. Thank you!

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?