Solved

After through the documentation on DATETIME_PARSE() I’m not seeing the timezone respected when used in conjunction with either SET_LOCALE() or SET_TIMEZONE() for conversion of a string field containing date and time information. What am I missing here:

I have the following phone number +33661291700, do you know a formula that converts it to a US phone number? (e.g: (415) 555-2671) Thank you

Hi all, Hoping someone could help me correct a script. I have a base with multiple tables in it. There is a table called “Projects” and another table called “Potential Photoshoots”. I’m trying to use a script to move a single record from the “Potential Photoshoots” table to the “Projects” table. It should then delete the record from the “Potential Photoshoots” table. This all should happen automatically when a button is clicked. NOTE: The button field name and the button label are both titled “Move to Projects” and it exists on the “Potential Photoshoots” table. I’m new to Airtable and not very proficient with scripts, but I’ve been doing research and playing around to try and learn. I was able to work out the following script, but it doesn’t move the specific record whose button was clicked. From what I understand, that is because I need to use an input.recordAsync call. I think I understand where that should go, but it seems to cause other errors in the script when I add it. I also r

I have a “Lookup” field that shows me many values ​​in the same field according to the tab relationship. For example: It is related to a field called orders, the lookup shows a field with the number of orders, and the next lookup shows the month in which they were made, but it shows me the same repeated many times, (July, July, July, August, July , August). What I need is a formula that breaks me down and shows me only the months (July, August).

We have an Enterprise level account and are trying to implement a date field which will track the date that a status is changed in another field. This is all good on a move-forward basis, but we would also like to update it historically, which is proving to be trickier. With our enterprise account, we have 3 years of revision history, but it seems like the only way to access what we need is to open up every single record, scroll through until we find the action we’re wanting to track, and then approximate based off of Airtable’s generic date timeframes when that action was performed. Once we’re out of the 1 month timeframe, this goes to month by month and then year by year approximations, when what we’re really looking for is exact dates. Is there a better way to do this? I don’t see an access point in the scripting API to see record history. Our Enterprise audit logs only go back 6 months, and don’t offer this level of granularity. We know the data is there but are at a loss as to how

I was tring to modify a formula DATEADD({Start Date},13,‘days’) to find the end of the month but since months have differing amounts of days I wasn’t sure how I could do that. Bascially, I want the formula look at the start date and then output the last date in that month. So a start of 9/1/22 would equal 9/31/22, etc. Thanks in advance!

Hello everybody! I hope everyone is doing well. I was trying to create a system where we have a due date for a item (in this case a bill), and then have a single select field with options to say how often we have to pay it. I then thought it would be great if I didn’t have to change the due date and that is done automatically. However the formula I created isn’t correctly adding the days based on what I have in the single select field. It defaults to the first if statement. My formula: IF(Frequency,“weekly”,DATETIME_FORMAT(DATEADD({Due Date},7,‘Day’),‘MM/DD/YYYY’),IF(Frequency,“bi-weekly”,DATETIME_FORMAT(DATEADD({Due Date},2,‘week’),‘MM/DD/YYYY’))) Note: This is not all the option but I figured it was a problem with the structure and not the options. Any help would be greatly appreciated. Thanks!

Hey I’m coming from spreadsheets and wanted to start using Airtable, but the first thing I noticed was that I couldn’t use shift+scroll to navigate horizontally. My friend doesn’t have this issue on his Mac, but I’ve found dozens of other people with the same issue as far back as 2017 but no one has shared a solution. Any insight on the cause of this bug/how to fix it? I can’t use this if basic navigation is broken. (Using Chrome on Windows 10)

Hi, I use a script to update a field {TypeForm} by concatenating 4 fields {Rang},{TypeQuestion},{Question},{Option}. {Rang} is Single line text / {TypeQuestion} is Single select / {Question},{Option} are Rich text When i execute the following script: with these data: I get the following result: Why first column values {Rang} like 1., 2., 3. etc.are not properly transferred in {TypeForm} as we see 1. , 1., 1, Thanks a lot for your help. F.

I’m trying to overwrite a Field’s options with a list provided dynamically from data that is imported. I have successfully updated the options to use the previous values in addition to the new set of values (similar to the example the documentation provides). However, the use case for my app is to start from scratch: delete all existing records (and ideally field options), and import a fresh set of data with field options that match the new data. The documentation points to UpdateFieldOptionsOpts as a way to do this, but after trying a few combinations, I have not gotten it to work. Any thoughts from the community on what I might be doing wrong? Here is some sample code to demonstrate the issue: let choices = { choices: [ {"name": "Option 1"}, {"name": "Option 2"}, ] } if (field.hasPermissionToUpdateOptions(choices)) { await field.updateOptionsAsync(choices, {"enableSelectFieldChoiceDeletion": true}); }

Struggling with the Date time difference not showing the correct status. The problem is the failing to return “Due Soon” instead of “Due Tomorrow”. Today, the date is 24 August, but projects marked with a 26 August deadline are showing as “Due Tomorrow” and I don’t know why… IF(OR({Status}="To Do", {Status}="WIP"), IF({Deadline}=BLANK(), "Not Due", IF({Deadline}=TODAY(), "Due Today", IF(DATETIME_DIFF( TODAY(), {Deadline}, 'days') <= 1, "Due Tomorrow", IF(DATETIME_DIFF( TODAY(), {Deadline}, 'days') > 1, "Due Soon", IF(IS_AFTER( TODAY(), {Deadline}), "Overdue"))))),"-")

Hi everyone, I have a Stacker app, linked of course to Airtable, for which my colleagues use to plan events, sync these to internal calendars, etc. Some of these events run “Out of Hours”, i.e. starting or running into Saturdays or Sundays, or starting or running past 5pm Monday to Friday, and for compliance purposes, these events needs some special email notifications to fire to certain people. One workaround would be simply to have users mark a checkbox field to say “my event is out of hours”, but this still has the possibility of user error (and I’d like to streamline my Stacker app as much as possible). So, theorising a workaround, I’ve created four formula fields using DATETIME_FORMAT to extract the Start day, End day, Start time, and End time independently of any date and those values being combined in the date fields, which what my users configure. This has allowed me to get text values for “Saturday” and “Sunday”, and it’s easy enough to configure an automation for these, howev

I’m trying to test a very simple script, but I can’t seem to output specific fields to a table, no matter which fields I specific in selectRecordsAsync, the output is always the same: fields id and name. My code: let table = base.getTable("Procedimentos"); let query = await table.selectRecordsAsync({fields: ["Procedimento","Descrição"]}); output.table(query.records); What am I missing?

Hi - I recently noticed that the URLs for attachments in my base are ‘sometimes’ exported with additional parameters that looks something like this: &userId=usrRGFsp5k3BVKxoz&cs=5df56hubdtrt3673b79d I’d prefer just the basic URL, and am also concerned that exposing the UserID is a security flaw - since I’ve shared these asset links, usually images, on a public platform without inspecting the URL closely. I am using the API (via pyairtable) to get these URLs. Sometimes the extra parameters are included, and sometimes they’re not. I haven’t been able to ascertain what is causing the different outcomes. Has anyone experienced this, or had similar issues? Thanks!

Hi team, Here’s the context 2 fields: Scheduled date: A Date field with ISO format, 24h format, it includes Time and uses GMT for all collaborators Date validation: A formula field that runs the following code: IF( AND( {Scheduled date}, NOW() >= {Scheduled date} ), "Ready", "In Review" ) Problem: When Scheduled date = Today, the formula returns Ready, ignoring the time. For instance: Case A Scheduled date = 2022-08-23 18:00 GMT NOW() = 2022-08-23 19:00 GMT The formula returns Ready :x: Case B Scheduled date = 2022-08-24 18:00 GMT NOW() = 2022-08-23 19:00 GMT The formula returns In Review :white_check_mark: Could it be that NOW() doesn’t care about time? or is it using a different Time Zone?

Hi, I’m pulling what little hair I have left out trying to search for an answer to my problem. Any advice would be very gratefully appreciated. I am trying to create a button that will create a custom url based on the following: https://random.company.co.uk/crsc/api/status/?dateOfBirth=<DD/MM/YYYY>&s urname=&hasAgreedTermsAndConditions=true&organisationName=&employeeSu rname=&employeeForename= The elements will be referenced from our airtable. Any clues as to where to start will be met with whoops of joy. Thanks, Huw

Is it possible to create an automation that will create a record at the end of the day if a student is not marked absent they will be counted as present. I have a form for teachers to fill out when a student is absent. However, I want to create something that will also count when a student is present, not just the change to present. For example, if there is a class of 4 students and everyone is in attendance then I would get a record at the end of the day where 4 different records were created saying that all students were present. Is there a script that is possible for this? Currently, my automation is grouping all four “present” students into a single record and I want a different record for each.

Good day everyone! For gmail automation, in the Message section - is there a way to format fields that are inserted into the content of the message? Examples are below: I would love for the message to be easier for the client to read. Thanks!!

Hey everyone Having a bit of problems with this script. I have a tasklist and at the end of the record I have a delete button. When I press the button I want it to delete just that record. But when I use this script it seams to delete just any of the records in the list except the record I want to delete. Can someone pls advise? // Delete a record in the Tasks table let table = base.getTable(“Tasks”); let query = await table.selectRecordsAsync({fields: }); let recordId = query.records[0].id; await table.deleteRecordAsync(recordId); console.log(“Deleted a record!”);

Why are all my DATETIME_DIFF formulas coming up as a negative number? My formula is: DATETIME_DIFF({Birthday}, TODAY(), ‘years’) and I am getting for example -29 instead of 29.

I want to do daily updates from each person on my team. I’ve created a table that has each of their names in a drop-down. The primary field is the date. I have a daily meeting where i’d like those records to be waiting for me to type the daily update in the “Notes” field. Then the next day, have those lines waiting for me again to fill in with that day’s inormation. They all go into one big log, and then I have a view that is just “Today”, filtered by today’s date. I made another table with the Names in a list so I could just cut and paste them each day, but that’s tedious. Is there a way to either replicate these records for every weekday in the future (or future month, etc.)? Or a way to have those 10 blank records (for 10 employees) waiting for me to fill in each day?

I want to update certain values (columns) of a record automatically in another table if it meets the condition. How can I do so? I have added a checkbox in Table 1. If the check box in Table 1 is checked, then update the values in Table 2.

I have table where I’m tracking attendance versus enrollment of a training workshop. I’m using a name field that also has a lookup field displaying whether someone goes by a formal name or an alias. I have another field that has an array of all attendees of the workshop an individual has enrolled in. I’ve had some success finding the enrollee’s name in the array of attendance to determine whether the enrollee is among those in the array. However, I’m running into an issue where, in some cases the enrollee, though listed as using an alias, may in fact have attended the workshop under their formal name. So, I need to use a formula that can search for and find either the alias or the formal name in the array, but it doesn’t seem to be working. Here’s what I have in the case of an enrollee who uses an alias who also attends the workshop using that alias: FIND( (IF({Alias (from Name)},{Alias (from Name)},Name)), {Workshop Session 000 Attendance}) I have tried including AND, but nothing is

Hello, I would like to create a new static date when a checkbox is clicked. It should be [day the checkbox is clicked] + [X Days]. I’m actually using IF({Follow-up 1 sent?} = 1, (DATEADD(TODAY(),2,"days")),BLANK()) However the Today() function keeps updating the date to … today. I’d like the newly created date to be static and not be incremented every day by the TODAY() function. Thanks

I want to avoid replicate the same base filter 10X times on the same view I could not find a combination for that. Why is it limited ?